Excel Error: File Already Open

  • Thread starter Thread starter Heath
  • Start date Start date
H

Heath

Occasionally when I implement my Excel 97 Add-ins to my
colleague’s computers
they receive an error when trying to use the functionality’s
from a button.

When they click the button they receive an error that says that the
file they
trying to access is already open.

When I go in and look at how the macro is assigned it is assigning the
full
path to the workbook.

I know that if I reload the buttons when Excel opens I don't have any
problems,
but is there a way to keep this from happening?

I suppose it would have to do with qualifying the following code:

With ExcelButton
.OnAction = "PasteFormulaFormat"
End With

I am not sure exactly what will fix this.

Any help would be appreciated (or if you can directly me to an old
article that covers this)

Heath
 
Back
Top