Hi I have a workbook called Dec2012 I was wondering if anyone could help me as to where I put the workbook name in the code so I can open other workbooks and use them normally without the macro upsetting them .
Hi I have a workbook called Dec2012 I was wondering if anyone could help me as to where I put the workbook name in the code so I can open other workbooks and use them normally without the macro upsetting them .
Does the code reside in Dec2012 or in another workbook?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
ITS IN DEC2012 I HAVE A SAVE MACRO ON AUTO_OPEN WOULD I JUST PUT Application.Run "'DEC2012.xlsm'!Save" OR DO I HAVE TO WRITE THE FILE NAME INTO THE MACRO TOO ?
Can you post your code here please?
Please Login or Register to view this content.
Please Login or Register to view this content.
rjm87,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
Oops Sorry , Ill know for again
Will this save all open workbooks or just DEC12 ?
I have only added code tags to your post, i have not posted any solution yet. Working on it.
Just change ActiveWorkbook to ThisWorkbook.
I'm pretty sure that you don't need a macro for this, I think that excel will auto-save every so often if you configure it like that - though I haven't used Excel 97 for a very long time.
What are you trying to achieve? You want to open the file and then have it save every 15 mins?
Thats what i wanted to tell the OP to change activeworkbook to thisworkbook. But i too havent worked on Excel 97 since ages so am not sure whether any other part too needs to be changed.
Actually I bet the OP hasn't either going on his filename
Its excel 2007 im using now , it was an example of one of the macros i was using i am looking to know if there is a way to put the workbookname into the macro so it only runs in dec12
Did you try what Kyle suggested?
How would i add this into another macro ?
You don't, it goes into your existing macro
How do i get the macro to work by the filename ?
I've told you, to make it operate on only that workbook, change ActiveWorkbook, to ThisWorkbook in your code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks