Select path file Excell from access 2003

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • itasking
    New Member
    • Mar 2008
    • 2
    #1

    Select path file Excell from access 2003

    Hi everyone,

    can someone show me how to select excell file path from access 2003.

    thanks.
    Tags: None
    • ADezii
      Recognized Expert Expert
      • Apr 2006
      • 8834
      #2
      Originally posted by itasking
      Hi everyone,

      can someone show me how to select excell file path from access 2003.

      thanks.
      1. Set a Reference to the Microsoft Excel XX.X Object library
      2. Copy & Paste the following code where appropriate:
        [CODE=vb
        ]Dim appExcel As New Excel.Applicati on

        MsgBox "The Path to Excel.exe is: " & appExcel.path & "\"[/CODE]
      3. Let me know how you make out.

        Comment

        Previous template Next
        Working...