| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parsing data macro
Thanks! I'll give it a try...
-- C.J. Miller "Ron Rosenfeld" wrote: On Wed, 25 Jan 2006 19:20:02 -0800, "cjmillerFL" wrote: Thanks Ron, That worked very well. As a followup, is there anyway to have the macro prompt me for the file to open? -- C.J. Miller Here's something simple I came across, but I don't have enough experience in this area to know the potential pitfalls: --------------------- Dim fn As Variant fn = Application.GetOpenFilename("Text Files (*.txt), *.txt") If fn = False Then Exit Sub Workbooks.OpenText FileName:=fn _ ... (the rest of your data/text to columns process) ------------------------- --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Threaded Mode
