Opening data file

[jpen]

Hi all,

I have a directory with data files (txt format) which I import in Excel. Now I want to start a macro at the moment I select one of these files. How can I do this??

Thanks

 

[ChrisUK]

Why not use your macro to open the file then call the macro you want directly afterwards.

To open a file for import then execute another macro afterwards use this code.

Workbooks.OpenText Filename:="C:Filesmyfile.txt", Origin:=xlWindows _
, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _
, Space:=False, Other:=False, FieldInfo:=Array(1, 1)

Call mymacro


Hope this helps

 

[jpen]

The problem is that the filename in the macro is not a variabel. I have about 100 data files (all having another name) which I want to import in Excel.