Hello,

I have a progam that performs certain database actions on a csv file
(f.x. transforms to excel, rearranges, copy-pastes, creates new
processed file).
For this to work i have up until now required the user to save this csv
file as a specified constant filename so that the code recognizes it.
The code is something like: Workbooks("csvfile.csv").activate. What i
would rather do is make some kind of prompt, where the user can choose
what file to process, a.k.a i want the user too choose from a standard
windows "open file" window, preferable with some kind of standard path.
When VBA has the opened this file, i think activesheet will be enough
the rest of the process. Do you have any suggestions?


--
erikhs
------------------------------------------------------------------------
erikhs's Profile: http://www.excelforum.com/member.php...o&userid=32788
View this thread: http://www.excelforum.com/showthread...hreadid=531857