|
-
April 14th, 1999, 08:17 AM
#1
How to reference a UserForm in Excel from Access
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|