tech_boy

Member
  • Content count

    41
  • Joined

  • Last visited

Community Reputation

0 Neutral

About tech_boy

  • Birthday 01/29/1986

Contact Methods

  • MSN
    rampantrabbit70@hotmail.com
  • Website URL
    http://
  1. Hi guys, I've got an Excel spreadsheet that is running a macro updating it every 15 seconds. The macro looks at one workbook then updates the numbers in the second workbook every 15 seconds. If I use the "Paste Special" method to paste this automatically updating workbook into MS Powerpoint, will the refresh macro continue to run when powerpoint is running its presentation? Thanks. - Jon
  2. Thanks for the advice So if I have a macro by the name of "sort" which looks like this: Sub sort() ' ' Sort Macro ' Macro recorded 01/08/2011 by jmoore10 ' Range("C3:C22").Select ActiveCell.Offset(-1, 0).Range("A1:C21").sort Key1:=ActiveCell.Offset(0, 2). _ Range("A1"), Order1:=xlDescending, Header:=xlGuess, OrderCustom:=1, _ MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal End Sub Would I then use the following code within the same Module as my Macro? Public dTime As Date Sub Run_Macro() dTime = Now + TimeValue("00:15:00") Application.OnTime dTime, "Run_Macro" End Sub As well as having the following code in my main workbook: Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnTime dTime, "Run_Macro", , False End Sub Private Sub Workbook_Open() Application.OnTime Now + TimeValue("00:15:00"), "Run_Macro" End Sub Forgive the amount of code here, I'm just trying to get my head around all of it! Thanks again, - Jon
  3. Hello all, I have a simple macro that sorts a column in MS Excel in descending order. Is it possible to automatically schedule this to happen every 30mins or so? Thanks in advance, - Jon
  4. Hello all, This is a relatively complex problem to explain, but i'll give it my best shot! OK... I have the following code: Public Sub LookUp(s) Dim vOurResult Dim lookFor lookFor = s With Sheets("DATA").Range("comment") vOurResult = .Find(What:=lookFor, After:=.Cells(1, 1), LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Offset(0, 9) End With If vOurResult = 0 Then Exit Sub ' Ends program if no comment present for this customer Else MsgBox vOurResult ' Displays messagebox with corresponding comment End If End Sub This basically runs a macro that looks through a hidden datasheet within an excel document which looks to see if any given customer has anything written in their "Comment" column; it it does, then it is displayed. My spreadsheet has a "Trailer Number" column and if someone enters a customer number adjacent to a particular set of trailer numbers, I need an error message to be displayed telling the user that they cannot use this kind of trailer and when they click "OK" the Customer ID field needs to be automatically wiped. I'm sorry if this explaination is terrible, please ask me for any extra information you may need! Thanks in advance, - Jon
  5. Yeah i've managed to install it with no trouble at all, but when you try and run the game, it changes the resolution of the screen as if it is trying to load, but then it reverts back to normal after a few seconds and nothing else happens. I have tried using compatibility mode (all of them!) but still no joy... highly unhelpful beast that it is! Thanks for the advice about event viewer, I didn't think of that at all and will have a look when I get back! Thanks for the replies very helpful as always! Jon
  6. Hi Gang! I'm attempting to take a trip down memory lane by playing an old rugby game: Rugby Challenge 2006 (ubisoft). Whenever I try and load it, well, it doesn't load at all! I've looked on the Microsoft website to see if there are known compatibility issues with this game, but I can't seem to find any. Can any one give me any clues on how to waste my time more effectively? Cheers, Jon Sorry, I should have mentioned that I'm trying to run it on Windows 7 64 bit OS
  7. Hi Guys, Every now and again a friends PC loses its PS-2 mouse. Plugging in a USB mouse solved the problem in the short term, then I ran MalwareBytes and it found and removed a few trojans... once i'd rebooted, the PC found the PS-2 mouse again. Thought the problem was solved... until the very same thing happened 3 days later... and then 4 days after that! Now i'd be happy to believe that the first time was fair-game, but he's got fairly adequate anti-virus (if you can call McAfee adequate) so I don't know whether it could be the anti-virus that isn't working or whether there is a deeper problem? Is the anti-virus leaking trojans or is the computer just being rubbish? Cheers in advance, Jon
  8. Hi Guys, I've written a batch file that should delete all old printers on a computer, then import a 'ports.reg' registry file to add the correct IP ports to that machine, then it is meant to install the new printers. The problem is that after it has added the correct ports, it tries to add the new printers but I get the very helpful error message "Operation Could not be completed".... here is my script, and i've included the ports.reg file too: rem delete old printers wmic PRINTER delete rem stop printer spooler Net stop Spooler rem reg delete "HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Ports" /f /va %windir%\regedit /S ports.reg net start spooler pause rem add printer RUNDLL32 PRINTUI.DLL,PrintUIEntry /if /b "HP Officejet Pro K5400 Series" /f "\\juniorfs\NETLOGON\Printers\HP-K5400\hpwk540a.inf" /r "\\juniorfs\JSchoolVillach" /m "Villach Room" Ports.Reg: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Ports] "COM1:"="9600,n,8,1" "COM2:"="9600,n,8,1" "COM3:"="9600,n,8,1" "COM4:"="9600,n,8,1" "FILE:"="" "LPT1:"="" "LPT2:"="" "LPT3:"="" @="" "Ne00:"="" "Ne01:"="" "Ne02:"="" "Ne03:"="" "\\\\juniorfs\\JSchoolFL1"="" "\\\\juniorfs\\JSchoolVillach"="" Any help would be gratefully received! Thanks a lot, -Jon
  9. Its not a problem to go and get a USB CD-Rom drive and run chkdsk that way, I was just hoping that I could use the LAN. Never mind ay, maybe the lovely(!) people at Microsoft or somewhere will someday help us out! Thanks for your replies!
  10. Hello all, Is it at all possible to run chkdsk over a LAN? The PC that needs it run has had its CD-ROM drive ruined by lovely schoolkids and I was wondering (to make my life much easier) whether you could run chkdsk over the LAN? Cheers in advance Jon
  11. ah! Well again this is entirely up to you. I'd probably be happy with the 8gb but then again I dont use any programs/games as memory intensive as you! It all depends when you want to throw more money at the computer? I mean, if you dont mind parting with a bit more money now, you can upgrade the motherboard but not necessarily buy its maximum ram, update that at a later date should you need it? On the other hand, you could stick with that motherboard and go with the 8gb ram but when the time comes to upgrade you'd have to buy motherboard and ram at the same time. -jon
  12. Wouldn't say you've quite lost touch with reality! Personally I'd start off with 8gb now and see how you fare with that, in two years or so have a look at sticking a few more GB's in. Alternatively just stick the lot in now and have an almighty machine... NASA might ask to borrow it mind.... Its your choice i guess, i'd personally stick half of it in and see how it goes! -Jon
  13. Hello all! I was just wondering if anyone had any experience of using Symantec Ghost on a large number of computers throughout a network... i've just started using it on a school network of around 100ish PC's. I'd heard that the ghost client that is left on the computers after "ghosting" can add to network traffic, admittedly each client doesn't use much, but if there are 100 of them 'talking' to the server then it could cause somewhat of a problem? Just seeing if anyone had heard of this? cheers, -Jon
  14. genius!!! thanks a lot all... i've gone down the route of using the sif file to turn it off!! Thanks again! -Jon
  15. yeah man, all you had to do was make the Unattended files into an .ISO image, then you can use Nero to burn that to DVD if you want, but clearly ISOBuster works too, excellent! -Jon