cannot open workbook

[MichaelJPhilipsz]

When I use the following code to open an excel workbook from Access the workbook is opened but in read only mode and is not visible in Excel. How may I open a workbook so that I may see it?


Workbooks.Open ("D:\Data\MYMPM\MS71_GAFA_Analysis\GAF_Template _v1-01.xlsb")

[ItsMe]

Workbooks is a collection in Excel, not Access. At least, I cannot find any reference to the Workbooks collection for Access on MSDN. Bottom line, your code is using an Excel reference.

I would start by instantiating an instance of Excel and use that instance to open your xlsb file. Apparently, you already have created a reference to Excel in your Access application, otherwise the code you posted would not compile.

So maybe something like ...

Dim xlApp As New Excel.Application
Dim myBook As Workbook
Dim mySheet As Worksheet
Set myBook = xlApp.Workbooks.Open("C:\Test\ExcelFiles\TestFile.xlsx")

[MichaelJPhilipsz]

Thanks for that. That seems to work. It does open the file although the file remains non readable until the Access application is closed down.

[ItsMe]

I am not understanding what you mean by closing down the application. The application the code is using is a New instance. That instance is the one you want to interact with.

Because you are using a New instance, you should have full control via that instance. There can be exceptions with security and privileges. Also, if someone else (or another instance of Excel) has the file open while your code runs.

Test your code in a control environment by creating your own XLSB file on your C drive.

Take advantage of the fact that you instantiated a running instance of Excel. Maybe use xlApp.Visible or something, depending on what your goals are.

[aytee111]

Excel doesn't like to share! May have nothing to do with Access.

[warmslime]

Excel doesn't like to share! May have nothing to do with Access.

Do you mean that you're not able to reference its cells by pointing or using any of the functions in the View tab from any other Excel windows? Cause I've noticed that too.