Import Data

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

I have a database application that basically analyzes data and gives the
user useful data on it. The issue is that the data it uses is imported
from a text file that a vendor sends us each week. I have everything setup
to use import setting but I was hoping to get out of the loop each week and
write a macro that prompts the user for the data path where the file they
want to analyze is located. Does anyone know what command or syntax to use
to accomplish this.

Thanks
 
Brent,

Is the data file have a different name/location each week?

You can use a TransferText action in a macro to do what you ask.
 
Yes the data file is named differently and the users can save that email
attachment anywhere and usually do :) Is there a command to make it ask you
for a path?
 
I think I got what I needed from the post above but I was looking for it to
allow them to browse and click on the file.

Thanks
 
Back
Top