• 0

[VB6]


Question

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

  • 0

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

  • 0

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

  • 0

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.