Open a comma delimited text file in Excel

[JLC123]

I have a nice little GUI app gathering various system information, mostly log files, for the user to read on request. Everything is working great because I've put the information into simple text files that are just pulled up in notepad when the corresponding radio button is selected. However, I've dumped the APP and SYS logs into comma delimited files. They pull up in Excel just fine, but without the delimiters. I've attached the tiny snipit of code I'm talking about. How can I get the file to load the way I want it to without adding a whole mousemove type script?

Thanks in advance!

Case $msg = $APP
   If GUIRead($APP) = $GUI_CHECKED Then
      Run ("C:\Program Files\Microsoft Office\Office10\excel.exe c:\app.txt")
   EndIf

[this-is-me]

Try

Run ('C:\Program Files\Microsoft Office\Office10\excel.exe "c:\app.txt"')

Instead.

[JLC123]

Sorry, but that works exactly the same. The file opens, it's just not recognizing the delimiters.

[CyberSlug]

Rename your *.txt files to *.csv

(Excel does not automagically process *.txt files unless you do special steps in the File > Open menu....)

[LazyCoder]

Simply rename your file (or copy it and launch the copy) to app.csv and everything should be just fine.

Note that I'm unsure it will work really fine if your delimiter is a semi-colon instead of the usual comma...

[LazyCoder]

Damn! CyberSlug got me!

[CyberSlug]

Damn! CyberSlug got me!

<{POST_SNAPBACK}>

Nearly 1 1/2 hours pass before two identical posts in the span of a minute.

[JLC123]

Thank you CyberSlug and LazyCoder!!

(You can explain to Larry for me if you're so inclined.)

Saved me a whopping 22 lines of code opening the app, then the file and walking through the wizard. <yuck!> AND, it's a much cleaner presentation.

Maybe someday I'll be able to answer some questions instead of asking them all the time.

[mfbcons]

Thank you CyberSlug and LazyCoder!!

(You can explain to Larry for me if you're so inclined.)

Saved me a whopping 22 lines of code opening the app, then the file and walking through the wizard. <yuck!> AND, it's a much cleaner presentation.

Maybe someday I'll be able to answer some questions instead of asking them all the time.

$oExcel = _ExcelBookOpenTxt($sFilePath, $sDelimiter = ",", $iStartRow = 1, $iDataType = 1, $iTextQualifier = 1, $fConsecDelim = False, $fVisible = 1)

I attached the excel UDF I used (found in the forum)