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

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!

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

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

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

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

genius!!! thanks a lot all... i've gone down the route of using the sif file to turn it off!! Thanks again! -Jon

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

Hiya, Sorry if this is a silly question! You said you've got the reg key to turn of sys restore at the T-12 stage, what do you have to put into cmdlines.txt to do this? Cheers -Jon

I suppose you could make a generic CD containing all of the Drivers for all of the PC's that you will be using the disc to install on, but I guess thats upto the situation, i'm just using this disc for my own personal PC so dont need too many drivers, but you can use the guide to use more than one set of drivers. The problem really is that not too many (if any) different makes of computers/ hardware will use the same drivers. Hope that wasn't totally useless!! Jon

hey guys im having this problem too, i know that adding the /disallowsystemrestore switch will solve it... but since WMP10 hotfix is already integrated, how does one make it un-integrated for want of a better word cheers, jon

@ dansouza is the "MP10setup.exe /Q:A /R:N" in RunOnceEx? because i think i tried that but it still moaned about the system restore! @ Ctr-X What code did you use in Cmdlines.txt? Tech

hello again! I've changed the switch in the config.txt to /s and changed the switch in the RunOnceEx.cmd to /s aswell, and still i'm getting the same error message! Is this only a switch problem or is there something else that im doing wrong? Jonny Sorry... as it turns out, when i run my RunOnceEx file on my machine, it doesnt write to the registry either! thought that might be of use to someone! thanks again

Ah... that would explain a lot! thanks guys, most appreciated! I'll try a different switch and let you know how it goes, or post my next problem Jonny

Sorry guys, major oversight on my part, heres my runonceex file, its extremely small as i'm just trying to get it to work for one application before going the whole hog! @Echo Off SET PP=%SystemDrive%\Install\ SET KEY=HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\RunOnceEx REG ADD %KEY% /V TITLE /D "Installing Programs" /f REG ADD %KEY /VE /D "Microsoft .Net 1.1" /f REG ADD %KEY /V 1 /D "%PP%dotnetfx.exe /qb" /f EXIT Thanks again for looking guys! Jonny

good evening all, and a very happy thursday to you! Slight problem, when my unattended installation finishes, and i log on, the computer starts RunOnceEx, it seems to install .netframework 1.1, but then it gives the error message "command line option syntax error" and so does not work! Does anyone have a clue as to what can be wrong with this!? most annoying! cheers, jonny

thanks for your fast and knowledgeable reply martin! Few questions, After following the 7Zip installer method, im left with a file called dotnetfx.exe (for example) is that the app that has to be run through RunOnceEx? Also, is RunOnceEx the only way to install switchless installers, or is there another way? Cheers again Jonny Sorry, is there no way to call it from cmdlines.txt directly and not have to use runonceex?. appologies for being a berk!

ok... newbie question coming up... Righty, so my installer has been made (happy days), it all works fine, BUT, where in the folder hierachy for my unattended CD does it go? Appologies for the horrendous question, but its wednesday and i'm tired! Jonny