Hi again,
I'm dealing with a new challenge and I need your help.
I'm saving only a sheet using the following code:
The question is: is there a way to put a vba code on this new workbook open method?
Please Login or Register to view this content.
The goal is that every new xls created to have the following code on workbook_open:
thank you.Please Login or Register to view this content.
Instead of copying the worksheet to a new book, why not just save the current workbook under a new filename and then re-open the original
Elegant Simplicity............. Not Always
also
is simpler ;-)Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
because my workbook has multiple worksheets and I only save 1 of them. and i save that worksheet multiple times to multiple files :
Please Login or Register to view this content.
Use a template which has the workbook code in it.
Last edited by Norie; 04-10-2013 at 07:09 AM.
If posting code please use code tags, see here.
Or delete the sheets you don't want, save under a new name then reopen the original file.
I saved my file using Worksheets("name").copy
and added code on workbook_open using VBIDE.CodeModule
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks