Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to make a Macro that would so I can open a CSV file and it.
Is there anyone out there that can teach me how to do this?
|
#2
|
|||
|
|||
Sometimes, the best way to learn is to turn the macro recorder on and then do
what you want manually. Then turn the macro recorder off and look at the code. Bob L wrote: Is there anyone out there that can teach me how to do this? -- Dave Peterson |
#3
|
|||
|
|||
If you record a macro while doing you will get something you can boil down
to something like this. Workbooks.OpenText Filename:=ActiveWorkbook.Path & "\" & [wbtoget], Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=False _ Space:=False, Other:=True, OtherChar:=",", FieldInfo:=Array(Array(1, 1) , _ TrailingMinusNumbers:=True -- Don Guillett SalesAid Software "Bob L" <Bob wrote in message ... Is there anyone out there that can teach me how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I set up a Macro to automatically run when I open a speci. | Excel Discussion (Misc queries) | |||
Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
Make a macro of keystrokes. ie. F2,Shift & Home & right cursor,de. | Excel Worksheet Functions | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) |