Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto open text files
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto open text files
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto open text files
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel v. 2000 won't auto-open later version files | Excel Discussion (Misc queries) | |||
2003 sp3 changes how text .xls files open | Excel Discussion (Misc queries) | |||
Open several text files using a macro | Excel Discussion (Misc queries) | |||
text files open with all data in first column | Excel Discussion (Misc queries) | |||
open text files as a worksheet | Excel Programming |