Open text file in sheet 2, from file dialog box

[chrisjd2]

Hope you guys can help!

I'm baffled on how I can create a macro to open a .txt file into Sheet2 with delimited comma and tab.
i.e Data From Text.

I thought of using QueryTable.Add but cannot get it to work.

I need to be able to manually select the file, so I need FileDialog(msoFileDialogFilePicker).

HELP! Lol

many thanks
chris

[kalbasiatka]

Please Login or Register  to view this content.