|
-
Sep 25th, 2003, 12:26 AM
#1
Thread Starter
New Member
Urgent need to help (resolved)
Why does it can't find the pathname? something like that:
Dim objExcel as object
Public sub command1_Clikc()
set objExcel=GetObject("C:\Documents and Settings\Administrator\My Documets\ledger.xls")
objExcel.application.visible=true
objExcel.Parent.Windows(1).Visible = True
objExcel.Application.WindowState = 1
Set objExcel = Nothing
End Sub
Please correct it for me. Thanks.
Last edited by caribouca; Sep 25th, 2003 at 01:04 PM.
-
Sep 25th, 2003, 03:20 AM
#2
Lively Member
It can't find the pathname because you can't spell Documents. 
I think, although I might be wrong, that there's a special syntax for folders with spaces in their names.
Also, why do you have an ampersand (&) in the path? Is your spreadsheet file really called: & book1.xls?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|