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
Ross - 08 Sep 2005 16:56 GMT
To All,
Please ignore this the post.
It was some kind of error in the Dim statements. Sorry
> Hello,
> I am getting a compile error (see subject) for the following code:
[quoted text clipped - 22 lines]
>
> Ross