Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Import the Excel File

    Hi:

    In Macro:

    How can I import the the Excel file?

    I know which Action I use, Transferspreedsheet..
    But, it needs me to enter the Table name, and File name (path)

    I enter the table name, but how can I skip the path name, because, everytime the Excel file is different directory, how can I set that?
    If diff drive, do can I set?

    path: J:\
    Can I set option, when run the macro, can the program ask me where is the Excel file I want to import it? Because macro just fix the same path.
    Thanks.
    Last edited by accessman2; 10-05-05 at 14:39.

Posting Permissions

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