Hello Guys: I am doing an ASP Report that will write the contents to an Excel File. I know you can set the content type to Excel, however: I am not sure this will work for our purposes.
Our Excel file has 5 different tabs / sheets that must remain in 5 seperate tabs, and as a result, I don't think changing the content type will allow for that. So my question is: in my ASP code, how do I specify which tab / sheet I would like to write the output to? I have a general objExcel connection object declared. So I need a new connection for each sheet? Or can I just do something different in my query? Thanks for any help Andy ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
