JimmyT
February 10th, 2000, 05:36 PM
I am creating a VB front end that will generate formatted reports that take user input and convert them into Excel Spreadsheet entries.
I am able to open various dialog boxes from Excel within my VB program. What I would like to be able to accomplish is use the PageSetup dialog from Excel to actually format Excel Spreadsheets from my VB Front End.
I would like to avoid having to make the Spreadsheet visible to the user (as he/she doesn't need it) but allow the VB front end to take the user selections from the PageSetup dialog and convert them into actual spreadsheet settings.
As an alternative, does anyone know where the icons that are used in MS WORD or MS EXCEL toolbars reside? I would, of course, prefer not to have to create my own dialog, but would be willing to do so if I can easily use the standard MS OFFICE icons.
Thanks...
I am able to open various dialog boxes from Excel within my VB program. What I would like to be able to accomplish is use the PageSetup dialog from Excel to actually format Excel Spreadsheets from my VB Front End.
I would like to avoid having to make the Spreadsheet visible to the user (as he/she doesn't need it) but allow the VB front end to take the user selections from the PageSetup dialog and convert them into actual spreadsheet settings.
As an alternative, does anyone know where the icons that are used in MS WORD or MS EXCEL toolbars reside? I would, of course, prefer not to have to create my own dialog, but would be willing to do so if I can easily use the standard MS OFFICE icons.
Thanks...