Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. eddy556

    Excel not responding

    Hi, I have been writing vba within excel and now whenever I open it is just hangs....is there anyway of rectifying this? THanks
  2. eddy556

    Allowing varibles to be available in another application

    Hi, thanks! I'm getting an ambiguous name error? Do you know what that means? Thanks
  3. eddy556

    Allowing varibles to be available in another application

    Okay thanks for your help but I'm still a bit confused. oApp.Run "samedayInvoice.xls!Save_Invoice" is just an example what I am actually trying to run iso "samedayInvoice.xls!Reset_Invoice" which has two buttons, one on the Excel spreadsheet, and one on an Access form. What I want is for when...
  4. eddy556

    Allowing varibles to be available in another application

    Well I'm not sure if this is the right way but this seems to execute functions in the other application: oApp.Run "samedayInvoice.xls!Save_Invoice
  5. eddy556

    Allowing varibles to be available in another application

    Hi, is it possible to somehow allow a vba variable to be available within another application. What I am wanting to do is for a macro to realise that it was executed by another application and therfore run a different set of code. What I was thinking to do was set a 'flag' variable and if it...
  6. eddy556

    VBA loop to write data to an Excel spreasheet on different lines

    Hi, thanks! Works great! Lol I was also wondering why it was opening Excel twice! Didn't realise I had dublicated the code Thanks again :)
  7. eddy556

    VBA loop to write data to an Excel spreasheet on different lines

    Hi, what I am trying to code is a loop in VBA which will go through a recordset and write each record onto a different line within excel. For example the first record will be written into cells B9, C9, D9, E9, then the next record goes to B10, C10, D10, E10 etc. However I get error 424 - object...

Part and Inventory Search

Back
Top