TaRaKa Posted August 17, 2004 Share Posted August 17, 2004 Is it Posible to edit and print Excel Documents From within a VB6 runtime enviroment if so how i know the code to edit the documents in VBA but im not sure if this is posible. Link to comment Share on other sites More sharing options...
0 TaRaKa Posted August 17, 2004 Author Share Posted August 17, 2004 Could this be done with Object linking and embeding Link to comment Share on other sites More sharing options...
0 James Rose Posted August 17, 2004 Share Posted August 17, 2004 yes this can be done with OLE. Select the OLE control, place it on a form. When you do this a dialog will come up asking you what type of OLE Object. Select "Microsoft Excel Worksheet" and there you go! However, I believe this is only the start of what you are trying to accomplish. What is the rest? Link to comment Share on other sites More sharing options...
0 TaRaKa Posted August 17, 2004 Author Share Posted August 17, 2004 im trying to get a printed out put from a very large VB data access system preferably id like to be able to fill in the cells and print out the worksheet that is alread created Link to comment Share on other sites More sharing options...
0 James Rose Posted August 17, 2004 Share Posted August 17, 2004 Well, I'm wondering why you're wantingto pass this info into Excel and then print. It SEEMS like the long way around to your needs. Now, again, I am no sure of your EXACT needs, but it seems that you can place the data into a grid and print that form. Or use the included Crystal Reports (a bit heavy for your needs) to create a report. Link to comment Share on other sites More sharing options...
Question
TaRaKa
Is it Posible to edit and print Excel Documents From within a VB6 runtime enviroment
if so how
i know the code to edit the documents in VBA but im not sure if this is posible.
Link to comment
Share on other sites
4 answers to this question
Recommended Posts