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 wOOdy-Soft 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: *

  • Users: 1229
  • Content: Threads
  • Order by date
  1. 1229

    Save as New file each time macro is ran in VBA

    I'm working on a macro in VBA with Excel. My objective is to have the macro automatically save the new file the macro just created. Each time the macro runs I want the filename to change. For example, I run the macro and it saves the file as C:\7-1-01.xls. Tommorrow I run the macro and I want...
  2. 1229

    opening files in excel with a macro that contains passwords

    I don't know a lot about macros. I have used the macro recorder to create my macro to open 11 files that I use everyday. The problem is these 11 files contain passwords and the macro will not automatically open these files. It prompts me to enter my password for each file it opens. Is there...

Part and Inventory Search

Back
Top