[EXCEL] Open Text/CSV File in Excel

[JMichaelTX]

##Macro Library “[EXCEL] Open Text/CSV File in Excel”

Created in response to request by @nfotx:

Select or Show a Menu Item

First things first. I am truly a KM beginner. So laugh all you want. Everyday I download data that comes from the website as a TextEdit file. I want to import the data into Excel. Below is my macro "Import well data" and below that is the Alert I receive after I "Try" the macro. My next question will be how do I get the macro to "click" the Text file button in the Import dialog box? Also, is there any way to read the entire Alert when it pops up? Thanks. [image] [image][image]

Neil, hope this works for you. Let me know if you find any issues.

EDIT: Updated to Ver 1.1 on Mon, Dec 21, 2015 at 12:57 PM US CT

Provide much better makeAlias() functions, provided by @ccstone

[EXCEL] Open Text-CSV File in Excel.kmmacros (6.5 KB)