Jump to content

tech_boy

Member
 View Profile  See their activity

  • Posts

    41

  • Joined

  • Last visited

  • Donations

    0.00 USD 

  • Country

    United Kingdom

 Content Type 

Posts posted by tech_boy

    Linking an Excel File to Powerpoint issues

    in Microsoft Office

    Posted

    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

    0

    Scheduled VBA Sorting Macro

    in Programming (C++, Delphi, VB/VBS, CMD/batch, etc.)

    Posted

    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

    0

    Using VB to clear Cells in MS excel

    in Programming (C++, Delphi, VB/VBS, CMD/batch, etc.)

    Posted · Edited by tech_boy

    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

    0

    7 64bit compatibility issue?

    in Gamers Hangout

    Posted

    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

    0

    7 64bit compatibility issue?

    in Gamers Hangout

    Posted · Edited by tech_boy

    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

    0

    Windows XP SP3 losing mouse connection occasionally

    in Windows XP

    Posted

    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

    0

    Printer Script Failing

    in Programming (C++, Delphi, VB/VBS, CMD/batch, etc.)

    Posted

    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 :unsure: 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

    0

    How much ram do I need for a new pc?

    in Windows Vista

    Posted

    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

    0

    How much ram do I need for a new pc?

    in Windows Vista

    Posted

    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

    0

    Symantec Ghost client network traffic?

    in Networks and the Internet

    Posted

    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

    0

    Big time noob question

    in Unattended Windows 2000/XP/2003

    Posted

    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

    0

    run once ex error message

    in Unattended Windows 2000/XP/2003

    Posted · Edited by tech_boy

    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 :wacko:

    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

    0

    run once ex error message

    in Unattended Windows 2000/XP/2003

    Posted

    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

    0

    run once ex error message

    in Unattended Windows 2000/XP/2003

    Posted

    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

    0

    How to make a 7-Zip Switchless Installer

    in Application Installs

    Posted · Edited by tech_boy

    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!

    0
×
×
  • Create New...