Excel Import - freezing

[centralpressure]

I have a simple script where I am importing a text file from the desktop into Excel, but it hangs up at the data source selection screen. I can't seem to figure out why. At first I thought it was my computer, so I tested it on another machine and same problem. There is a spot where I am tabbing 7 times to get the data source to select from the desktop, it appears as though the tabbing stops on 'Cancel' and the screen hangs there. Below is a portion of the script, thanks for any thoughts.

Run("C:\Program Files\Microsoft Office\Office11\Excel.exe")

WinwaitActive("Microsoft Excel - Book1")

Send("!d")

WinWaitActive("Microsoft Excel - Book1")

Send("d")

Send("d")

WinWaitActive("Select Data Source")

Send("{TAB 7}")

Send("{Down}")

Send("{Enter}")

Send("all")

Send("{Enter}")

WinWaitActive("Text Import Wizard - Step 1 of 3")

Send("n")

Send("n")

Send("n")

Send("F")

Send("{Enter}")

WinWaitActive("Microsoft Excel - Book1")

Send("^a")

[rliiack]

I would say your title on WinWaitActive maybe wrong. Did you find the title by using Au3info?

Edited October 6, 2009 by rliiack

[PsaltyDS]

I have a simple script where I am importing a text file from the desktop into Excel, but it hangs up at the data source selection screen. I can't seem to figure out why. At first I thought it was my computer, so I tested it on another machine and same problem. There is a spot where I am tabbing 7 times to get the data source to select from the desktop, it appears as though the tabbing stops on 'Cancel' and the screen hangs there. Below is a portion of the script, thanks for any thoughts.

Run("C:\Program Files\Microsoft Office\Office11\Excel.exe")

WinwaitActive("Microsoft Excel - Book1")

Send("!d")

WinWaitActive("Microsoft Excel - Book1")

Send("d")

Send("d")

WinWaitActive("Select Data Source")

Send("{TAB 7}")

Send("{Down}")

Send("{Enter}")

Send("all")

Send("{Enter}")

WinWaitActive("Text Import Wizard - Step 1 of 3")

Send("n")

Send("n")

Send("n")

Send("F")

Send("{Enter}")

WinWaitActive("Microsoft Excel - Book1")

Send("^a")

What kind of file are you importing? If it's just a CSV I believe you could just do:

$oExcel = _ExcelBookOpen(@DesktopDir & "\MyFile.csv")