Import Data, using a command line switch

B

Balisteor

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
 
B

Balisteor.

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" ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Data, using a command line switch 1
WORD VBA Search and switch to advanced ... 1
Corrupt PST 2x/week HELP! 0
Creating a Search using a combo box and then creating a report. 4
Accessibilty - how to open doc with keyboard? 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Excel does not accept text format! 0

Top