I'm using a multi-dimensional model (underlying Access Database) with an Excel (2003) user interface. From Excel I can easily choose from various members within the dimensions i.e the version dimension (Actual, Budget...), the entitiy dimension (businesses) and the time dimension (i.e. annual, profiled....) etc.
I have a printing tool which allows me to print information by entity or time and will list all of the entities or time members which I can select from and can then choose which chart of accounts I want to print for the selection.
I can specify whether I want to print landscape or portrait and how many copies I want from the dialog but it prints to the default printer only and what I want to be able to do is show the print dialog (i.e code below) and from there deterime the options.
I don't want to do this for each selection though as I could select i.e. 50 entities x 3 chart of accounts and I'm therefore going to have to do this 150 times.
Can I get it to remember:
a) which printer to use;
b) the orientation; and
c) the number of copies.
I would therefore only select the options after selecting the print criteria and the same would apply to each print thereafter.
Please let me know if you need more information.
Any help is appreciated.
I have a printing tool which allows me to print information by entity or time and will list all of the entities or time members which I can select from and can then choose which chart of accounts I want to print for the selection.
I can specify whether I want to print landscape or portrait and how many copies I want from the dialog but it prints to the default printer only and what I want to be able to do is show the print dialog (i.e code below) and from there deterime the options.
Code:
Application.Dialogs(xlDialogPrint).ShowI don't want to do this for each selection though as I could select i.e. 50 entities x 3 chart of accounts and I'm therefore going to have to do this 150 times.
Can I get it to remember:
a) which printer to use;
b) the orientation; and
c) the number of copies.
I would therefore only select the options after selecting the print criteria and the same would apply to each print thereafter.
Please let me know if you need more information.
Any help is appreciated.
