Close macro file

  • Thread starter Thread starter MrRJ
  • Start date Start date
M

MrRJ

Hi,

I have built a macro in which it has done it thing. Now, it is complete,
can I close the file that contains the macro too? Is that possible?

MrRJ
 
ActiveWorkbook.Close
' closes the active workbook and lets the user decide if
' changes are to be saved or not
 
Jim: the problem is the saveas closes the oringal workbook and only nleaves
the saveas file opened. if yo want to go back to the original file you have
to re-open the workbook.
 
Thanks guys. I didn't want to close the whole application, just in case the
user has other files open. So, I created a simple line with the specific
file name that the macro is being used.

I am all good.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro line too long? 1
Run Macro If Cell have "x" value 0
User prompt for CSV format 5
Need help on VBA excel macro and API to close an external application 0
Macros problem closing another file 0
Determine name of macro contained in each excel file in a folder 9
Macro to generate powerpoint slides 43
Schedule a macro on a specific time 4

Back
Top