Close specific workbook

R

Robert_L_Ross

I have one workbook that has a macro that imports a .txt or .dat file,
processes it then saves it to a specified location.

At the end of the macro, I tried closing the ActiveWorkbook but that ended
up being the 'new' file I created.

How do I close the 'source' file (the filet that is running the macro)?
 

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

Making a macro only work on certain files 2
Need Help with Macro Security 1
Embedded Excel into Word with Tables 0
Select Text to End of Footnote 9
Save workbook without shapes 0
Macro to select and delete levels of a document 2
Opening a list of Excel files and run a macro in each 17
closing another file by code causes failure to run workbook activate event 2

Top