Force Excel to use pipe character as CSV separator from command line

ltpitt
ltpitt used Ask the Experts™
on
Hi there,

I'd need to know if there is a way to put in a batch file an option to force Excel to open a csv file using | as delimiter.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
not from a batch file but yes from a vbscript
(you can call the vbscript from the batch file if you need batch for something)

the answer was provided by Bill Prew , in this same site, here is the link
OPEN CSV DELIMITED WITH PIPE
Question inactive, solution provided

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial