Open and close excel file using VBA Excel

Open and close excel file using VBA

Objective

To open and close excel file using VBA Excel.

 Approach:

Here we are using a dialog box to open a excel file.We are opening only xlsx type of files here.

Code

Sub OpenCloseExcelFile()
Dim MyTargetFile As Variant
'First open a excel file
MyTargetFile = Application.GetOpenFilename("Excel Files (*.xlsx), *xlsx")
Workbooks.Open Filename:=MyTargetFile
'Give a name to the opened excel file, because it ensures that you are closing the correct file.
MyOpenedFile = ActiveWorkbook.Name
'If needed we can add code to modify data or perform any operation on opened excel file
'As a general practice, we can save the workbook before we close
Workbooks(MyOpenedFile).Save
'Close the workbook
Workbooks(MyOpenedFile).Close
End Sub

 

Note:

  1. You can use this approach when you have opened multiple files, then you can provide each of them a temporary name [e.g. MyOpenedFile], then close any file which you do not require.
  2.  If needed,we can also add code for data manipulation in between,.
  3. Saving a file before closing is optional, it depends if you have modified the file or not.

Post you may like

Save a excel file at a fixed path using VBA excel

 

 

 

 

1 comment on “Open and close excel file using VBA Excel

Comments are closed.