G
Guest
Hello,
I am getting a compile error (see subject) for the following code:
Set wbk = app.Workbooks.Open(FileName:=strCompleteExcelName)
The "highligted" compile error is ".Workbooks". I borrowed this code form
another individuals program and it works in her database (and it compiles)
but it doesn't in my database.
I have made the refererence library in my database identical to hers in :
1. # Components
2. Priority of the components
Both databases are in 2002 format.
When I type "App." the workbooks option it is not available in my database
but it is in her database.
I am running both databases on my hard-drive.
Why can't I get "App.Workbooks" to appear in the drop-down on my database
but is does appear on her database?
Thank you.
Ross
I am getting a compile error (see subject) for the following code:
Set wbk = app.Workbooks.Open(FileName:=strCompleteExcelName)
The "highligted" compile error is ".Workbooks". I borrowed this code form
another individuals program and it works in her database (and it compiles)
but it doesn't in my database.
I have made the refererence library in my database identical to hers in :
1. # Components
2. Priority of the components
Both databases are in 2002 format.
When I type "App." the workbooks option it is not available in my database
but it is in her database.
I am running both databases on my hard-drive.
Why can't I get "App.Workbooks" to appear in the drop-down on my database
but is does appear on her database?
Thank you.
Ross