| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CSV Import - user to select file
To all,
I have recorded a macro that imports a csv file into my worksheet. However the file selected is 'hard coded' into the macro. Is there any way that I can get this to change depending on which file the user wants to select to open. Thanks Joseph Crabtree |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CSV Import - user to select file
sInputFile = Application.GetOpenFilename("Text files, *.txt", , "Select
your text file", , False) If sInputFile = "False" Then MsgBox "Import cancelled at user request." Exit Sub End If joecrabtree wrote: To all, I have recorded a macro that imports a csv file into my worksheet. However the file selected is 'hard coded' into the macro. Is there any way that I can get this to change depending on which file the user wants to select to open. Thanks Joseph Crabtree |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open file dialog-select file-import worksheet | Excel Programming | |||
| Import File with browse and select (even from Pocket PC?) | Excel Programming | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
Hybrid Mode
