Open Excel file using a variable that references the file

Question

In Excel VBA I write: Set mWB = Application.Workbooks("File.xlsx")

Then: mWB.Close() I noticed is a possibility, but in the autocomplete list I only see close, not open.

How can I open an excel file in VBA using a variable of type Excel (Dim mWB As Workbook) that holds a reference to the file?

I don't want to use: Application.Workbooks.Open ("File.xlsx"), which I know is possible!

ChrisN · Accepted Answer · 2012-09-16 13:52:56Z

1

Simple answer is that isn't how that class works. If you wanted to though, you could create a class to do that?

answered Sep 16, 2012 at 13:52

ChrisN

5805 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Workbook objects store references to workbooks that are in memory. If the workbook is closed, it cannot be referenced as a workbook.

chris neilsen · Accepted Answer · 2012-09-16 19:02:42Z

0

Try

set mwb = Application.Workbooks.Open ("File.xlsx")

answered Sep 16, 2012 at 19:02

chris neilsen

53.3k10 gold badges91 silver badges127 bronze badges