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 |