Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / September 2005

Tip: Looking for answers? Try searching our database.

Method or Data Method not Found

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ross - 08 Sep 2005 16:17 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.