Discuss "print option" in the ASP Development forum.

Hi,

I have a drop down right now a user selects a name and hits submit and it opens up a excel file


I have to make a change so that a user can select multiple names from the drop down and when he hits submit button it opens up a excel file for all the names that were selected and prints out the excel files for all the names.

I am just not getting the printing side of the excel file can someone tell me how i can make it happen.

todd

As far as I know, you can't use ASP to make an Excel document print. You can only use ASP to add a header which will generate the Excel document.

As for selecting multiple users, do the following in your HTML:

This will store a comma delimited string in the post value. Create an array from this using the Split() function and then iterate through this array to generate your documents.

__________________
jmurrayhead
If you agree with me... click the icon!
If my post solved your problem, click the button in the lower right-hand corner of the post.

Join our Folding team: DeveloperBarn Folding

I would create a simple CSV file using FSO dependent on the options selected, then redirect the page to that file you just created, this will prompt the user to dl/open the file, at this poing the user simply presses CTRL+P to bring up the print options.

Hi,

I have not tried it as my on vacation currently but i thought of this idea and u guys might tell me if it will work or not

when i hit submit button it opens up a excel file in the excel file i will have the body tag can i have a function called onload so when the page is loading the function is called which has window.print()

will this work

todd

I don't see why not as long as you are controlling with JS.

__________________
"You'll never be as perfect as BLaaaaaaaaarche."

ok guys i am back to work

i had the code window.print which i fire in onload event

when the page is loaded it shows me the print option dialog box is there a way i can automatically print it instead of the user clicking on "OK" button in the dialog box

todd

as per my knowledge u can not do like this when u use window.print

for details pls see this link
Print Directly to Printer

__________________
Love is physical attraction and mental destruction