Macro to close open files without saving it

[Roma1r]

Require assistance with setting up a macro.

The macro the way it’s currently setup reads a filename in a cell reference (data extraction worksheet, cell reference b7) and opens that file, copies data back to the main workbook and then opens the next file (data extraction worksheet, cell reference b8). Before the file copy, it unhides a worksheet (where it’s copying from).

I need assistance with closing the files opened (in cell reference b7 and b8) within the macro, and no need to save.

Please Login or Register  to view this content.

[BellyGas]

When you open the workbook assign it to a variable:

Please Login or Register  to view this content.

Then, to close the workbook you simply:

Please Login or Register  to view this content.

[mohan.r1980]

try

Please Login or Register  to view this content.

[mohan.r1980]

Hi

i am trying to make easy your code
try

Please Login or Register  to view this content.

[mohan.r1980]

Your welcome and thanks for rep+