regevli Posted September 23, 2005 Share Posted September 23, 2005 helloi have this web application ment to be used by the local user only, i have iis installed on the local computer , now im trying to print excel wrksheet using th folowing code:function print_report(file) dim excel Set excel = CreateObject("Excel.Application") excel.application.visible= False excel.workbooks.open file,3,False excel.application.activeprinter="psc1100 on Ne00:" excel.application.sheets(1).printout excel.quit end functionwhen i used it in one computer it worked fine but when i copied the program to another computer (using iis and all) i get an error like "cant set activeprinter in the application collection"whats the problem ?is there any other way to print excel file using asp ?thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now