Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a problem with some forms in an add in...
I programmed the forms in a workbook to test them, then exported them to a directory from which I imported them to a referenced xla. All the macro's and forms work in the test workbook, but now that I have migrated the module and the form to the xla it doesn't work anymore.I have other forms and modules in the xla that do work when i call them from my test workbook. I can't seem to find where the problem lies, anybody have an idea? Regards, Sam |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sam,
Why don't you turn the addin back to a workbook and test it vas workbook, When you get it working, save it again as an addin. By the way, what is the error? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Sam" wrote in message m... I have a problem with some forms in an add in... I programmed the forms in a workbook to test them, then exported them to a directory from which I imported them to a referenced xla. All the macro's and forms work in the test workbook, but now that I have migrated the module and the form to the xla it doesn't work anymore.I have other forms and modules in the xla that do work when i call them from my test workbook. I can't seem to find where the problem lies, anybody have an idea? Regards, Sam |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The error was something like "can't find object". I was calling a
form... The problem has been solved though. When I exported the modules and forms I did it by "removing and saving" them. I tried the same thing again by exporting from the workbook, importing in the add-in, saving the add-in, and then I "removed and not saved" the forms and modules from the workbook. A bit strange, but this way it worked... Just something that I need to keep in mind for next times :-) Thanks for the reply. Regards, Sam Gerené "Bob Phillips" wrote in message ... Sam, Why don't you turn the addin back to a workbook and test it vas workbook, When you get it working, save it again as an addin. By the way, what is the error? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Sam" wrote in message m... I have a problem with some forms in an add in... I programmed the forms in a workbook to test them, then exported them to a directory from which I imported them to a referenced xla. All the macro's and forms work in the test workbook, but now that I have migrated the module and the form to the xla it doesn't work anymore.I have other forms and modules in the xla that do work when i call them from my test workbook. I can't seem to find where the problem lies, anybody have an idea? Regards, Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forms | Excel Discussion (Misc queries) | |||
Pop Up Forms | Excel Discussion (Misc queries) | |||
Forms Box | Excel Programming | |||
Why some forms not available? | Excel Programming | |||
VB Forms | Excel Programming |