Re: Spaces in folder name and file name
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Thu, 29 Oct 2009 15:33:51 -0500
The code isn't the problem.
You've got a mismatch between your spelling of the drive/path/filename in your
code and the actual name of the file.
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
.
- References:
- Spaces in folder name and file name
- From: Merlynsdad
- Spaces in folder name and file name
- Prev by Date: RE: Range PasteSpecial error
- Next by Date: RE: Range PasteSpecial error
- Previous by thread: Spaces in folder name and file name
- Next by thread: RE: Spaces in folder name and file name
- Index(es):
Relevant Pages
|
