Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export method question -- Spreadsheet ActiveX component on user form
It seems like the Export method always opens a second application o
Excel when the MS Office 2003 "Spreadsheet" web component is placed o a user form. Am I missing something and is there a workaround? To replicate: Place spreadsheet component on blank user form and ad the following code to the form itself: Sub UserForm_Initialize() Dim ssConstants Set ssConstants = Me.Spreadsheet1.Constants Me.Spreadsheet1.Export "test.xls" End Sub Thanks in advance. : -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activex component can't create object | New Users to Excel | |||
ActiveX Component Can't create object - Any Explainations? | Excel Programming | |||
DsoFile ActiveX component can't create object on other computers | Excel Programming | |||
ActiveX component can't be created | Excel Programming | |||
activex component can't create object with SAP 6.20 | Excel Programming |