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

Open and close workbooks 1
Save All Worksheets as CSV 7
closing another file by code causes failure to run workbook activate event 2
Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse 8
Open and save blank workbook with Command Prompt 0
auto close in Excel 2007 4
Opening a list of Excel files and run a macro in each 17
How to force macros refer to ActiveWorkbook 2

Top