Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Data, using a command line switch
Hello all. I would like to know if it is possible to open a comma delimited text file without going through the import data wizard. I want to be able to use a command line switch or if there are default import settings that I can set so that when i have Excel open the text file it will import it correctly without any user input. Thank you for you reading :D |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Data, using a command line switch
try this Sub OpenAFile() Dim fname As String fname = Application.GetOpenFilename(("Text Files (*.csv), *.csv")) Workbooks.Open fname End Sub at least on my pc, Vista and excel 2003, it just opens without any wizardry "§ Balisteor." <§ wrote in message ... Hello all. I would like to know if it is possible to open a comma delimited text file without going through the import data wizard. I want to be able to use a command line switch or if there are default import settings that I can set so that when i have Excel open the text file it will import it correctly without any user input. Thank you for you reading :D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data, using a command line switch | Excel Discussion (Misc queries) | |||
What is the command-line print switch in Excel? | Excel Discussion (Misc queries) | |||
shortcut with command line switch probs | Excel Discussion (Misc queries) | |||
Is there a command line "switch" To close Excel | Excel Discussion (Misc queries) | |||
Read only command line switch | Excel Discussion (Misc queries) |