forms in xla
 

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

forms in xla
 

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

forms in xla
 

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