PDA

View Full Version : Solved: File Address



PliskinAJ
05-31-2007, 03:08 PM
I have been working on a program and I am now stuck. Is there a way that I can search the computer like you do in an open or a saveas window, but have it return the file's address into a string? I can't just open the document because I have to convert a txt file to a spreadsheet and it is Delimited. I want to keep all that formatting automated.

PliskinAJ
05-31-2007, 03:23 PM
Never mind. I finally found it.

filename = Application.GetOpenFilename(fileFilter:="Text Files (*.txt), *.txt")

Is what i needed I look around for hours trying to find it. Give up and ask. 10 minutes after that i find it. Thanks tho.

mdmackillop
05-31-2007, 03:42 PM
Hi Pliskin,
Welcome to VBAX,
Always good to find your own solution, and thanks for posting it. If this is "solved" you can mark it so using the Thread Tools dropdown.
Regards
MD