tech_boy

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

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

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

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

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

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

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

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