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 Westi 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. DaMorf

    problem using VBA to open excel and run macro

    Nothing special, Private Sub workbook_open() Run "Macro1" End Sub but if i just open the excel file it doesn't close, it only does it when i use the Access button. Cheers,
  2. DaMorf

    problem using VBA to open excel and run macro

    Thanks Skip, That got rid of the error message but the second excel sheet closes itself once the macro has run, how do i get it to stay open? Thanks
  3. DaMorf

    problem using VBA to open excel and run macro

    Hi, i have a button in access that runs a macro to ouput to excel, i have also written into the same button code to open a second excel file. The second excel file has code written into it to run a macro on open and is linked to the download file. The problem i have is that when the macro...
  4. DaMorf

    Open an existing Excel file using cmd button

    That's done it!! Thanks both for replies!!!
  5. DaMorf

    Open an existing Excel file using cmd button

    I am trying to add it into an existing button that executes a macro, i am new to VBA so am not sure what kind of code would be required, all i have tried to use so far are docmd functions. i assumed that i would put in the function followed by the filepath, probably a bit naive...
  6. DaMorf

    Open an existing Excel file using cmd button

    PH, thanks for your reply. How would i incorperate that into the command, do you have an example code? Thanks
  7. DaMorf

    Open an existing Excel file using cmd button

    Hi, I am attempting to write code into a button that will open an existing excel file that i have created. i can output data to a file but cannot seem to just open it? Any idea's? Many thanks,
  8. DaMorf

    Table query from Access beginner

    Thanks for your reply Phil, No I don't have a date feild just 12 individual month fields and a Business area field. i don't know that i am organising this correctly but i need to find a way of selecteing the month field from criteria in a combo box
  9. DaMorf

    Table query from Access beginner

    Hi, I am fairly new to access (about 6 months of on/off usage) and i am having some trouble with a table, i have a table which lists budgets for different area's and shows month by month data. the problem i have is i need to run a query that will return the budget for a given month using a...
  10. DaMorf

    Table query from Access beginner

    Hi, I am fairly new to access (about 6 months of on/off usage) and i am having some trouble with a table, i have a table which lists budgets for different area's and shows month by month data. the problem i have is i need to run a query that will return the budget for a given month using a...

Part and Inventory Search

Back
Top