Just to save you some checking.

Open that file manually.

Then make sure it's the activeworkbook.
Open the VBE (alt-f11 is one way)
show the immediate window (ctrl-g)
and type this:
?activeworkbook.fullname
(and hit enter)

You'll be able to copy|paste from that immediate window into your code.



Merlynsdad wrote:

I'm defining a constant that will access a file. I've been testing it with
the following constant:

Const cstrDatabaseWB As String = "C:\Documents and Settings\5YPJB\My
Documents\Excel documents\Sherry project\real1.xls"

That works fine. Now I'm working with the real file, named by someone else,
and I've got the constant defined as

Const cstrDatabaseWB As String = "G:\WI\ACS\ACS QA\FY10 CQRS and Local
Reviews (version 1).xls"

There is a space in the folder name "ACS AQ" and multiple spaces in the
filename. I'm getting a Run time Error 1004 Application/Object Defined Error
when the code tries to execute the following line:

Application.Workbooks.Open (cstrDatabaseWB)

I tried using single quotes inside the double quotes around the file name
but that didn't help. How do I need to modify this code to open this file?

Any help will be greatly appreciated.

--

Dave Peterson