E
Eric
I'ld like to have an explanation on this cause I think its very strange.
I have a 200kb Excel file on a corporate network.
Using VB.NET I execute the following 2 tasks.
Task 1 (takes 15 seconds to execute):
Open Workbook using Excel.Workbooks.Open(networkPath)
Save Workbook using Workbook.SaveAs(networkPath)
Task 2 (takes 5 secondes):
Copy Workbook on local drive.
Open Workbook using Excel.Workbooks.Open(localPath)
Save Workbook using Workbook.SaveAs(localPath)
Copy Workbook back on network.
Where is the 10 seconds overhead going on task 1??? Is it because there's a
lot of ping pong communication on the network ??? Can I reduce Task 1
execution time to the level of Task 2 while keeping the Workbook on the
network the entire time???
Thx for the input!
I have a 200kb Excel file on a corporate network.
Using VB.NET I execute the following 2 tasks.
Task 1 (takes 15 seconds to execute):
Open Workbook using Excel.Workbooks.Open(networkPath)
Save Workbook using Workbook.SaveAs(networkPath)
Task 2 (takes 5 secondes):
Copy Workbook on local drive.
Open Workbook using Excel.Workbooks.Open(localPath)
Save Workbook using Workbook.SaveAs(localPath)
Copy Workbook back on network.
Where is the 10 seconds overhead going on task 1??? Is it because there's a
lot of ping pong communication on the network ??? Can I reduce Task 1
execution time to the level of Task 2 while keeping the Workbook on the
network the entire time???
Thx for the input!