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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Embedding Excel in an OLE container

Status
Not open for further replies.
Pipe2Path

Pipe2Path

Programmer
Aug 28, 2001
60
I am having trouble sizing the instance of the Excel spreadsheet into an OLE container control in VB. It doesn't fill up the entire control, and so the user has to resize it manually.

Would anyone be able to help me with how to resize the embedded object to fit the control fully? I have tried the SizeMode constants, but none of them seem to work.

Thanks.
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
575
remeng
remeng
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
207
sal21
sal21
JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
187
dhookom
dhookom
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
340
huiettcm
huiettcm
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
330
combo
combo

Part and Inventory Search

Sponsor

Back
Top