Replies

What I am trying to do is reuse code. I have written an add in. The add in includes several class modules. I want to use the code I have already written, rather than rewritting. I also want inheritance and overloading, but I already know Excel does not offer that with version 2002

I create a new workbook. I add a module to the new workbook. I add a reference to my add in, SomeAddin via the “Tools, References” I go to the Object Browser and view the objects available to me, which are sheets and modules.

Now I see that I need to set an Instancing property of the Class Module to PublicNotCreatable.. Once I do this, the class in the XLA is exposed to the other workbook.

Therefore I have answered my own question.

Thanks for the help.

What I am trying to do is reuse code. I have written an add in. The add in includes several class modules. I want to use the code I have already written, rather than rewritting. I also want inheritance and overloading, but I already know Excel does not offer that with version 2002

I create a new workbook. I add a module to the new workbook. I add a reference to my add in, SomeAddin via the “Tools, References” I go to the Object Browser and view the objects available to me, which are sheets and modules.

Now I see that I need to set an Instancing property of the Class Module to PublicNotCreatable.. Once I do this, the class in the XLA is exposed to the other workbook.

Therefore I have answered my own question.

Thanks for the help.

You are correct
I want to

Dim m_SomeClass as new SomeClass

Sub Tryme()
m_SomeClass.DoIt
End Sub

Where SomeClass in in SomeAddin.xla.

You are correct
I want to

Dim m_SomeClass as new SomeClass

Sub Tryme()
m_SomeClass.DoIt
End Sub

Where SomeClass in in SomeAddin.xla.

I opened the file, saved as Excel Workbook (eliminating the 95/97 format). I Inserted a new worksheet. I copied the entire contentes of the offending worksheet and used paste special to put the contents onto the new worksheet, formula first, then formating. I then deleted the offending worksheet.

I found the offending worksheet by copying them to a new workbook one at a time, opening in Office XP after each copy, until it failed to open. I believe we only have one user with this issue, but he has many offending workbooks.

Some days I love MS Office, some days I hate M$ Office.

Thanks for your hel

I opened the file, saved as Excel Workbook (eliminating the 95/97 format). I Inserted a new worksheet. I copied the entire contentes of the offending worksheet and used paste special to put the contents onto the new worksheet, formula first, then formating. I then deleted the offending worksheet.

I found the offending worksheet by copying them to a new workbook one at a time, opening in Office XP after each copy, until it failed to open. I believe we only have one user with this issue, but he has many offending workbooks.

Some days I love MS Office, some days I hate M$ Office.

Thanks for your hel

Sorry, forgot to include that detail in my first post. I tried that.

Sorry, forgot to include that detail in my first post. I tried that.

Very interesting.

Jan Karel Pieterse noted that one method works in 2000 but not 97. I just verified on XP. My process must work on both, therefore I was developing in the older version. Glad I am. I saved hours of frustration finding it early.

Thanks again.

Thanks. The sample you sent does work in Excel 97 as well.

However the following does not

Sub Test()
frmLogin.Show
frmLogin.hide
End Sub

Sub SecondRoutine()
MsgBox “The Login Name is ‘” & frmLogin.UserName & “‘”
End Sub

I will move forward by creating a class – calling the form from the class. The class will not destroy itself, as long as I program in such a way that it does not go out of scope. When I am done with it, I can then set it to nothing.

Thanks for your help

Thanks for the reply.

However, I do not want to destroy the form, I simply want to hide it. I want to treat it like a class and give it some properties, and contiue to access the properties. I will destry it when the spreadsheet closes.

There was a typo in my post. Originally simply used frmLogin, but my property never returned a value. I then changed the code to use m_frmLogin.

The bottom line is, the propery is not available. In VB I can hide a form and continue to access it. Apparently in VBA the form is destroyed and not hidden

Thanks

I tried , but I must have typo’ed something. It works fine now.

This is a form input button, not a toolbar button issue. I assumed it was an IE specific issue, but it is not. I should have posted to “Web Design, Coding and Scripting” Mozilla behaves the same way, which is interesting, since Netscape is based on Mozilla. I have searched webmonkey to no avail. I have the book “Internet Explorer 5 developers guide” and cannot find what I am looking for. I have expiermented with CSS, tag attributes, etc. I even switched to an XL skin in this forum. However the buttons are not XL.

I could use a graphic for an input button, perhaps.

Edited by WyllyWylly to add URL code. See the Quick Guide.[/i][/size]

Are you also aware of
http://devedge.netscape.com/toolbox/tools-validation/%5B/url%5D
and
http://devedge.netscape.com/viewsource/2003/mozilla-webdev/?%5B/url%5D