CSV Import - user to select file

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Excel File into Access DB where user can specify file name andcell range to import	ssa	Microsoft Access External Data	1	18th May 2011 01:18 AM
User Select File on Import External Data	L.Mathe	Microsoft Excel Programming	3	14th Mar 2010 09:07 PM
Allow User to Select Path of Import File	=?Utf-8?B?RGF2ZSBD?=	Microsoft Access External Data	3	29th Sep 2005 02:02 PM
How do I create a file dialog box to select a file to import?	=?Utf-8?B?U2NvcnBpb1JD?=	Microsoft Access	4	20th Nov 2004 11:27 AM
open file dialog-select file-import worksheet	=?Utf-8?B?RGl2aW5lZGFy?=	Microsoft Excel Programming	1	16th Jan 2004 07:13 PM