File Opening Twice

[MattSmithProg]

Hi All,

I use our corporate intranet to distibute little applications based in Excel. We then provide URL's to download the Excel workbooks so they can then use them.

We have just upgraded to IE5.5 and have found that on some machines when people download the file it says that the file is being modified by either myself or themselves and asks to Notify, Read Only or Cancel.

It is for some reason opening twice.

I do have Workbook_Open events in my workbooks if that makes a difference.

I can't make the download fault on my machine and can't find any differences between machines.

Any help on the matter would be greatly appreciated.

Matt Smith No two nulls are the same

 

[MiggyD]

In your _Open events, did you use a direct path instead of Active.Workbook?

I'm only guessing here 'cause I'm home at the moment and the Excel proggy is at work. But, I remember once that I ended-up using something similar to:

if active.workbook.name <> &quot;ThisOne.xls&quot; then
Workbooks.open &quot;z:\somewhere\ThisOne.xls&quot;
endif

Which resolved a different problem I had. Hope this helps you in someway.

--MiggyD It's better to have two heads to solve a problem from different angles than to have tunnel vision to a dead end.

 

[MattSmithProg]

No,

It only does a series of events to check what functionality the User has and screen settings.

Thanks for your help

Matt Smith No two nulls are the same