| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
|
Import Data, using a command line switch
Is the File extension ".csv"?
"Balisteor" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import Data, using a command line switch
No ".txt"
"Dead.Zone" wrote: Is the File extension ".csv"? "Balisteor" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import Data, using a command line switch
Sorry let me redo that. Yes it is a file containing comma seperated values.
but saves as a ".txt" file. Is all i need to do is rename it to ".csv" ? "Dead.Zone" wrote: Is the File extension ".csv"? "Balisteor" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import Data, using a command line switch
That does it .. THANK YOU.
"Dead.Zone" wrote: Is the File extension ".csv"? "Balisteor" wrote: 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 csv fiel from command line | 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) | |||
Linear Mode
