View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default Microsoft Add-Ins

Your command button may be trying to re-open the XLA.

Try closing the xla and then clicking the button


"Dianne & Shane Bursey" wrote:

I have created an Excel Add-in to be used in conjunction with and Execl file
that I have also created. More specifically I have created a spreadsheet
that in part contains a command button that when pressed calls upon a module
(a pop up calendar) that is contained in the .xla file.

I copied both the .xls and the .xla file to a floppy disk to be used on my
computer at work. (all works fine on my computer at home)
At work, I copied the .xla file to the microsoft add-ins folder, and the
..xls in my own folder that is on the hard drive.
I can open the .xls file, but when I press the command button to call the
pop up calendar, I receive the following message.

" A document with the name -------.xla is already open. you cannot open 2
documents wtih the same name, even if the documents are in different
folders. to open te second document, either close the document that is
currently open, or rename one of the documents."

The names of the only documents that I am trying to access are
AttenProfile.xla

and Profiling.xls.
There are no other documents open.!!!!

Anyone have any suggestions??? I can't figure this out, I'm too much of a
novice for this....

Thanks alot in advance

Dianne