Internet explorer

[tazrad]

I have a worksheet that is open from a webpage. Their are 4 command buttons which copy and paste data from another worksheet to this worksheet.
The marcos work fine when running in Excel but I think most of my users will not download the file just open it in Internet Explorer.

The marcos run but the data does not appear until the screen in refreshed.

Anyone have some code it fix this?

Excel 2003

 

[kevin.philips]

Hi,

Rather than mess around in excel and what it does when opened in IE you could try and write some code to force the user to download the workbook rather than opening it, a google search for force download excel should get you started. I have some code to do this in ASP.net if you need it.

Regards

Kevin

 

[Legacy 98055]

Or just zip it up.

 

[riaz]

You could force the file to open in Excel rather than in IE, so even if your users elect to open the file, it will still open in excel.

My computer/tools/folder options/file types
scroll down to xls
use the advanced button
uncheck the box for "browse in same window"

HTH