|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
09-02-2008
| #1 (permalink) |
| | Open Tab Delimited File with Excel I've been serching this group and a few web sites looking for a script that will open a tab delimited file with Excel. I've not found a script that performs this function. Can anyone post a solution here please. Thanks in advance. Hal |
My System Specs |
|
09-02-2008
| #2 (permalink) |
| | Re: Open Tab Delimited File with Excel "Hal" <Hal@xxxxxx> wrote in message news:E1B9C349-03C1-4E26-A65F-B39C7E8A0066@xxxxxx Quote: > I've been serching this group and a few web sites looking for a script > that > will open a tab delimited file with Excel. I've not found a script that > performs this function. Can anyone post a solution here please. > > Thanks in advance. then this CMD.EXE command should open the file in excel: start excel data.txt You could execute that command from a vbscript using .RUN. So, this does what you asked, but does it do all that you want? /Al |
| My System Specs |
|
09-03-2008
| #3 (permalink) |
| | Re: Open Tab Delimited File with Excel On Sep 2, 10:30 pm, "Al Dunbar" <AlanD...@xxxxxx> wrote: Quote: > "Hal" <H...@xxxxxx> wrote in message > > news:E1B9C349-03C1-4E26-A65F-B39C7E8A0066@xxxxxx > Quote: > > I've been serching this group and a few web sites looking for a script > > that > > will open a tab delimited file with Excel. I've not found a script that > > performs this function. Can anyone post a solution here please. Quote: > > Thanks in advance. > If the tab-delimited file is of type .txt (other types work, but not .csv), > then this CMD.EXE command should open the file in excel: > > start excel data.txt > > You could execute that command from a vbscript using .RUN. > > So, this does what you asked, but does it do all that you want? > > /Al Excel 2003. Further, they are associated with Excel, so that this works as well ... start "" data.csv Tom Lavedas =========== http://members.cox.net/tglbatch/wsh/ |
| My System Specs |
|
09-03-2008
| #4 (permalink) |
| Vista Ultimate x64 | Re: Open Tab Delimited File with Excel I've been serching this group and a few web sites looking for a script that will open a tab delimited file with Excel. I've not found a script that performs this function. Can anyone post a solution here please. Thanks in advance. Hal |
| My System Specs |
|
09-03-2008
| #5 (permalink) |
| Vista Ultimate x64 | Re: Open Tab Delimited File with Excel  Quote: Originally Posted by Hal  I've been serching this group and a few web sites looking for a script that will open a tab delimited file with Excel. I've not found a script that performs this function. Can anyone post a solution here please. Thanks in advance. Hal I've been serching this group and a few web sites looking for a script that will open a tab delimited file with Excel. I've not found a script that performs this function. Can anyone post a solution here please. Thanks in advance. Hal |
| My System Specs |
|
09-03-2008
| #6 (permalink) |
| Vista Ultimate x64 | Re: Open Tab Delimited File with Excel I've been serching this group and a few web sites looking for a script that will open a tab delimited file with Excel. I've not found a script that performs this function.a solution here please. Thanks in advance. Hal |
| My System Specs |
|
09-03-2008
| #7 (permalink) |
| | Re: Open Tab Delimited File with Excel "Al Dunbar" wrote: <snip> Quote: > > If the tab-delimited file is of type .txt (other types work, but not .csv), > then this CMD.EXE command should open the file in excel: > > start excel data.txt > > You could execute that command from a vbscript using .RUN. > > So, this does what you asked, but does it do all that you want? > > /Al > The files I want to open are tab deliminted text files that have an extension of .DAT. I have a script that takes user input and hands off the input to a batch file. The batch file returns a directory listing of all files and their locations which are displayed in Notepad. Basically I'd like to take the results of this directory listing and via another input box, have the script open the data file in Excel. I know there are better ways to handle this task and if I were a programmer, I'd have this thing figured out in Visual Basic. However, one semester of VB, five years ago is not enough to call myself a programmer. Regards, Hal |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| export results to tab-delimited file | PowerShell | |||
| How To Get Excel File Folder to Associate with Excel File Open | Vista file management | |||
| Vista ASP.NET 2.0 Cannot open Excel File using Microsoft.Excel 12.0 COM object | Microsoft Office | |||
| Excel 2007 display shift when open file in explorer | Vista General | |||
| Opening an Open Office data file in Excel | Vista General | |||
