Problem with Opening Excel within Webspeed

[King_O_Cyrus]

Looking for suggestion to solve this scenario ...

I'm running a program via AppServer to generate the data (program was already available so I'm calling that program instead of generating the data within Webspeed) and then taking the data files made and using them to open an Excel spreadsheet.

Individually, the steps work as desired. But once both pieces are put together, the Excel portion fails to execute. It appears that the disconnect to AppServer, or the waiting of the data files to be created, may be the source of the problem as it times out. Tried pauses and a few other things to delay the Excel portion but nothing seems to work. Both sections take about 15 seconds a piece to run (if that).

Any suggestions on how to get this to work?

 

[King_O_Cyrus]

Does anyone have any potential solutions or workarounds?

Deadline Friday :blue:

 

[joey.jeremiah]

i don't follow.


you generate the data using an appserver

... then taking the files and using them to open an excel spreadsheet.


what files ? xls ? csv ? html ? something else ?

opening them in excel how ? activex ? winapi ? with in a browser ? something else ?


you talked about a sync problem

if one step started before the other has finished ?


is this a web app ? should it open in a browser ? stream the file ?

tell us more about the process.