Problem with VBA and SkinFramework

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi everybody 

Im working with Office Beta 2007 (Excel) and VBA: Retail 6.5 version 1012.

First, Excel's UserForms  doesnt have a "Load" event. They have "Activate" and "Initialize" events.

Second, Excel's UserForms doesnt have a hwnd property (Me.hwnd).

So here what i did:

On my UserForm "initialize" event:

 SkinFramework1.LoadSkin ThisWorkbook.Path & "\" & "Office2007.cjstyles", "NormalOffice2007.ini"

SkinFramework1.ApplyWindow (Application.VBE.ActiveVBProject.VBComponents.VBE.MainWindow.hwnd)

My problem is that the skin apply to my form but doesnt apply to my controls (CommandButtons and others VB controls). 

Any ideas?

Thanks

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Robin Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 25 July 2006 Status: Offline Points: 1	Post Options Post Reply Quote Robin Report Post Thanks(0) Quote Reply Topic: Problem with VBA and SkinFramework Posted: 25 July 2006 at 10:21am
	Hi everybody Im working with Office Beta 2007 (Excel) and VBA: Retail 6.5 version 1012. First, Excel's UserForms doesnt have a "Load" event. They have "Activate" and "Initialize" events. Second, Excel's UserForms doesnt have a hwnd property (Me.hwnd). So here what i did: On my UserForm "initialize" event: SkinFramework1.LoadSkin ThisWorkbook.Path & "\" & "Office2007.cjstyles", "NormalOffice2007.ini" SkinFramework1.ApplyWindow (Application.VBE.ActiveVBProject.VBComponents.VBE.MainWindow.hwnd) My problem is that the skin apply to my form but doesnt apply to my controls (CommandButtons and others VB controls). Any ideas? Thanks

Oleg Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 21 May 2003 Location: United States Status: Offline Points: 11234	Post Options Post Reply Quote Oleg Report Post Thanks(0) Quote Reply Posted: 25 July 2006 at 12:54pm
	Hello, Now skinframework ActiveX support only Visual Basic 6.0. No .NET not VBA no other.
	Oleg, Support Team CODEJOCK SOFTWARE SOLUTIONS