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.Code:<select multiple="multiple"> <option value="1">Option 1</option> <option value="2">Option 2</option> <option value="3">Option 3</option> <option value="4">Option 4</option> </select>
jmurrayhead
If you agree, give me rep.
If you like it here...throw us a few bones to help support us.
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
Posting Permissions 
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks