Ingolf Brudeli
April 14th, 1999, 08:17 AM
Hi, all.
Does anyone know how I can access a UserForm in an MS Excel 97 spreadsheet from MS Access 97??
Accessing the spreadsheet itself works fine using the GetObject function, but I can't find any way to control the UserForms.
Dim XLWbk as Workbook
Set XLWbk = GetObject("somePath\someWbk.xls")
XLWbk.Sheets(1).Select 'Works fine
'But how can I make a User Form appear?
Best Regards
Ingolf Brudeli
Does anyone know how I can access a UserForm in an MS Excel 97 spreadsheet from MS Access 97??
Accessing the spreadsheet itself works fine using the GetObject function, but I can't find any way to control the UserForms.
Dim XLWbk as Workbook
Set XLWbk = GetObject("somePath\someWbk.xls")
XLWbk.Sheets(1).Select 'Works fine
'But how can I make a User Form appear?
Best Regards
Ingolf Brudeli