is this possible

[MarkElls]

I currently have a spreadsheet with a load of data (say 100 rows). I need to call an ASP page on a server and pass the data over. Currently I call the ASP page as part of a loop. But I need to kill the explorer page once the page has processed the data otherwise we just stop there. I have been able to avoid the waiting, and the loop will open 100 odd Internet eplorer sessions which I have to kill.

Is there another way? - does not have to be .net would like VBscript or Java script.

All I want is to open the excel click on a button and then the Excel starts at one row, works its way through the spreadsheet and does not leave any windows open. There are one hundred rows currently could go up to five hundred and multiple sheets.


Thanks a lot.
Wonko the Sane

 

[BoulderBum]

I'm not sure what exactly you want to do, but this may be better handled as a Client/Server app rather than trying to automate a web app. If you want to do it through .NET, you may want to handle it as a file upload (maybe even in XML if you have Office 2003

 

[MarkElls]

Part of the brief is that it must be an automated process, thats the whole point of having a system.
I currently have a XL file on my PC, I have access to a CE(Crystal Enterprise) server. The data in the XL file needs to be read and then used to schedule a whole load of Crystal reports.
The system for doing this needs to be as close to fully automated. I have considered using DTS, VB, VBA in the XL file, C# and ASP. I also have the possibility of using .NET although it does not create a wrapper for the DLL that I need to use in the project.

Now curently I run a loop from top of XL file to bottom and for each row I call a ASP page. The problem with this is I end up with a potential 150 - 300 Internet Explorer on my screen.

I am considering using Java script as it may be possible to close an Internet Explorer window in Java script.

Any thoughts are always appreciated.
Wonko the sane