Microsoft Add-Ins

[Dianne & Shane Bursey]

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

 

[Guest]

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

Try closing the xla and then clicking the button

 

[Bob Phillips]

You're creating add-ins and calling yourself a novice?

What is probably happening is that the add-in is loaded, and then the xls
file is trying to refer to some code in the add-in, but thinks the add-in is
in a different directory.

Have you installed the add-in properly, or just loaded it like any other
workbook?

--

HTH

RP
(remove nothere from the email address if mailing direct)