I am trying to save all Open workbooks using this code. It saves the first file just fine but gives a debug error on the Workbook.Saveas line the next time through the loop. I have six open workbooks that will need to be saved. Thanks for any help that can be offered.
Please Login or Register to view this content.
Last edited by Traymond; 01-06-2011 at 11:44 AM.
Your code looks like it is trying to save each workbook as the same name. Activeworkbook.name would be the name of the workbook you are running the code from.
Does each workbook already have a name?
yes they do. i just basically need it to save each open workbook with it's existing name into the N:\Junk folder
Last edited by Traymond; 01-06-2011 at 10:19 AM.
Please Login or Register to view this content.
snb, i get an error on the workbooks.close false line . any suggestions ?
Are you renaming the files? If not
snb's code should be workbook.close falsePlease Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
still not working correctly
Try explaining what you want to do more fully, or at least answer what you have been asked
Example scenario: i have 6 workbooks that i always have opened. they are WB1,WB2,WB3,WB4,WB5,WB6. The macro will run from WB1. i need it to save each of these open workbooks into the N:\Junk folder and save them with the already existing name. In this example after i ran the macro i could open the N:\Junk folder and find WB1.xls WB2.xls WB3.xls WB4.xls WB5.xls WB6.xls workbook files. I hope this helps explain better what i am trying to do. Thanks
snb's code should work, try this minor amendment
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by shg; 01-06-2011 at 11:31 AM.
Entia non sunt multiplicanda sine necessitate
I did not test this but would this work?
Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Save all the workbooks as the same name?
I modified shg code just a little and it works perfectly !!!! thanks for the help. below is the code after i made changes. i did not need it to close any workbooks so i took that code out. I had to add the &"\" to the path . If i do not do this it always saves he files to the folder the file was opened from . don't get me to lying. Thanks again.
Please Login or Register to view this content.
Last edited by Traymond; 01-06-2011 at 11:50 AM.
Same name but with a different number at the end, WB1, WB2, and etc.Originally Posted by shg
Please Login or Register to view this content.
Missed that, Mordred, sorry.Same name but with a different number at the end, WB1, WB2, and etc.
What is wbname in that code, snb?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks