Exploring whether I can create a text file with embedded VBA code that will
allow file to be openned in excel.

Thanks in advance.

--
Michael Maloney

Michael

Not sure what you mean. You can save a text file as .csv and it will open
automatically in Excel. You can also record/write a macro opening any other
type of text file with the text import wizard, saving this code to your
personal.xls. This would then always be available to re-run every time XL
was opened

VBA embedded in a text file...no

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Michael Maloney" wrote in
message ...
Exploring whether I can create a text file with embedded VBA code that
will
allow file to be openned in excel.

Thanks in advance.

--
Michael Maloney

VBA embedded in a text file...no

follow-up question:

Since name of text file will change every time, can a macro (VBA) be created
to open to most recent (date/time stamp) file in a particular folder?

Thanks again. Mike


"Nick Hodge" wrote:

Michael

Not sure what you mean. You can save a text file as .csv and it will open
automatically in Excel. You can also record/write a macro opening any other
type of text file with the text import wizard, saving this code to your
personal.xls. This would then always be available to re-run every time XL
was opened

VBA embedded in a text file...no

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Michael Maloney" wrote in
message ...
Exploring whether I can create a text file with embedded VBA code that
will
allow file to be openned in excel.

Thanks in advance.

--
Michael Maloney