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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Save as New file each time macro is ran in VBA
Here is my code....PLEASE HELP (if possible) Let me give you some background information. 1. I create a new blank workbook everytime this macro runs. 2. I do a SaveAs command (see below) in the beginning of my macro so I can identify this workbook throughout the macro. (Here's where I think...- 1229
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Save as New file each time macro is ran in VBA
I tried MyFilName = "C:\" & Format(Now, "m-d-yy") & ".Xls" ? MyFilName C:\7-11-01.Xls I'm still getting an error message that says "Wrong number of arguments or invalid property assignment" Is there another way to do this?- 1229
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- 1229
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- 1229
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
