Excel OLE in VB - Vertical Scroll Bars and Multiple Worksheets
Posted on 2004-10-28
In the project I am currently working on, in VB 6, I am trying to add an Excel OLE object. I can get the worksheet to come up but I don't see any scroll bars. How do I get the scroll bars (vertical) to appearand work to allow the user to scroll through the worksheet? Also, the users want a multiple page worksheet to appear. They want each page to be editable and then to print each and every worksheet. I currently print a report using word9. I want to get all of the Excel worksheets to print into this word9 document. I am a novice programmer so all help, patience, and direction is greatly appreciated.