Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Add-Ins
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Add-Ins
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) "Dianne & Shane Bursey" wrote in message news:uZZ8e.1066157$Xk.706616@pd7tw3no... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I covert Microsoft Word file into Microsoft Excel one? | Excel Discussion (Misc queries) | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Relation Microsoft Access avec Microsoft Excel | Excel Discussion (Misc queries) | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
How do I import Microsoft Word files into Microsoft Excel? | New Users to Excel |