Results 1 to 2 of 2

Thread: Urgent need to help (resolved)

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2003
    Location
    Toronto,canada
    Posts
    6

    Question 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.

  2. #2
    Lively Member MileOut's Avatar
    Join Date
    Nov 2001
    Location
    Glasgow
    Posts
    83
    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?
    Talk History Forum - Discussing the past...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width