Method or Data Method not Found

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
To All,

Please ignore this the post.

It was some kind of error in the Dim statements. Sorry
 
Back
Top