Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have never used either of the above applications, so am unsure which to choose. My problem: I need a user to give the location of a text file, which then opens and is used as a reference point for the rest of my macro (I am basically converting text information into spreadsheet information). However, I do not want the user to go through the text wizard to avoid upsetting the rest of the macro. I currently get the user to type the location of the text file into a cell of a spreadsheet, but the above applications would be more user-friendly. Which one should I use, and what would the syntax be? Thanks in advance, Ewan. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
Application.GetOpenFilename | Excel Programming | |||
Application.GetOpenFilename | Excel Programming | |||
Application.FindFile | Excel Programming | |||
Application.GetOpenFileName | Excel Programming |