Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export a form via code?
I have a form with MANY controls. I am changing some of the controls'
properties in my program. Is there any I can export the form with the changes properties? Could I export it via code while the properties are changed? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export a form via code?
The best test, specific to your situation, is to do it and examine the
results. -- Regards, Tom Ogilvy wrote in message ... I have a form with MANY controls. I am changing some of the controls' properties in my program. Is there any I can export the form with the changes properties? Could I export it via code while the properties are changed? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export a form via code?
Thanks for the reply.
I tried to export it via code but it didn't work, probably because I was guessing at the code to export it. I din't see anything helpful in the VBA help. I tired FormName.Export "FileName" and a few other things that did not work. On Sun, 25 Jan 2004 22:06:19 -0500, "Tom Ogilvy" wrote: The best test, specific to your situation, is to do it and examine the results. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export a form via code?
ThisWorkbook.VBProject.VBComponents("UserForm1").E xport "C:\T\UserForm1.frm"
Rob wrote in message ... Thanks for the reply. I tried to export it via code but it didn't work, probably because I was guessing at the code to export it. I din't see anything helpful in the VBA help. I tired FormName.Export "FileName" and a few other things that did not work. On Sun, 25 Jan 2004 22:06:19 -0500, "Tom Ogilvy" wrote: The best test, specific to your situation, is to do it and examine the results. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export a form via code?
Just to add, create a reference to the Microsoft Visual Basic Extensibility
Library. Then in the VBE, use the object browser to search for Export in the VBIDE library. Highlight the export command under VBComponents and hit F1 to get help (or click the help icon in the object browser). -- Regards, Tom Ogilvy Rob van Gelder wrote in message ... ThisWorkbook.VBProject.VBComponents("UserForm1").E xport "C:\T\UserForm1.frm" Rob wrote in message ... Thanks for the reply. I tried to export it via code but it didn't work, probably because I was guessing at the code to export it. I din't see anything helpful in the VBA help. I tired FormName.Export "FileName" and a few other things that did not work. On Sun, 25 Jan 2004 22:06:19 -0500, "Tom Ogilvy" wrote: The best test, specific to your situation, is to do it and examine the results. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code to Export Data from Chart | Excel Discussion (Misc queries) | |||
Export as XML for an Excel Order form document | Excel Discussion (Misc queries) | |||
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
Automate Export from Form Template to Seperate Table | Excel Discussion (Misc queries) | |||
Export method question -- Spreadsheet ActiveX component on user form | Excel Programming |