Closing an Excel file in VBA

[GeneralShamu]

I am opening an excel file by coding up the directory and exact file name.

After I am done extracting and pasting everything into "ThisWorkbook", i.e. the workbook that has the macro to open this file, I need to close it.

I tried:
work_sheet_macro_opens.Select
ActiveWorkbook.Close

but it is not working.

Please bear in mind that given the loop structure it is not defined which workbook I will end up on (in terms of the 'active sheet/book').

Anyone have any ideas?

 

[Norie]

How are you opening the workbook(s)?

Are you creating a reference to them when you open?

Something like this perhaps?

Set wbOpen = Workbooks.Open ("C:\NameOfWorkbookToOpen.xls")
 
' code to do stuff
' now close workbook
 
wbOpen.Close

 

[GeneralShamu]

I define a Filepath and Filename

Then use Workbooks.Open

Then I enter a for each loop to go through every work sheet in "ActiveWorkbook.Worksheets"

 

[Norie]

Well use something like I posted when you use Workbooks.Open.

You can use the refrerence for a lot more than just closing the workbook.

Dim wbOpen As Workbook
Dim ws As Worksheet
 
   Set wbOpen = Workbooks.Open ("C:\NameOfWorkbookToOpen.xls")
    
    For Each ws In wbOpen.Worksheets
        ' code to do stuff
    Next ws

   ' now close workbook
   wbOpen.Close

 

[GeneralShamu]

Well use something like I posted when you use Workbooks.Open.

You can use the refrerence for a lot more than just closing the workbook.

Dim wbOpen As Workbook
Dim ws As Worksheet
 
   Set wbOpen = Workbooks.Open ("C:\NameOfWorkbookToOpen.xls")
    
    For Each ws In wbOpen.Worksheets
        ' code to do stuff
    Next ws

   ' now close workbook
   wbOpen.Close

Got it, thank you!