Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing Excel Object From Another Form

Status
Not open for further replies.
frankR40

frankR40

Programmer
Feb 3, 2004
3
US
If I create an Excel Object, workbook, sheet, etc. on one form, how do I access that object instance from another form. I keep getting an object required error, I'm not sure about the snytax.

Thanks for the help.
 
Sort by date Sort by votes
Declare it as a public variable, and use form1.myExcelObj...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
get value from html page 1
Replies
7
Views
449
strongm
strongm
Andrzejek
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
294
Andrzejek
Andrzejek
44MARCO
  • Locked
  • Question
MACRO SETTINGS - VBA PROJECT OBJECT MODEL 1
Replies
2
Views
778
strongm
strongm
sal21
  • Locked
  • Question
NOT FOR ME, get value from table web
Replies
1
Views
247
sal21
sal21
Swi
  • Locked
  • Question
API - multipart/form-data
Replies
3
Views
1K
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top