script task to adjust printer setting

Question

0.00/5 (No votes)

See more:

i want to write a script to adjust printer setting.Using script component i want to open the excel file that i have placed in the folder and make printing settings and save that file

Posted 8-Dec-15 23:58pm

varun_streetScientist

Updated 9-Dec-15 0:07am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-Dec-15 6:07am

Where is the issue then?

varun_streetScientist 9-Dec-15 6:15am

i want the to know the script code for doing this change

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2015-12-09T00:26:00

Solution 1

Printer settings are saved in the document. You can easily find out how to do it by making the changes in the Workbook while recording a macro.

Posted 9-Dec-15 0:26am

Richard MacCutchan

Comments

varun_streetScientist 9-Dec-15 7:30am

yeah that's true but i want it to do by writing script component..actually i want to do it in SSIS

Richard MacCutchan 9-Dec-15 8:29am

What does SSIS have to do with Excel files?

varun_streetScientist 10-Dec-15 1:25am

i want to code the script in C#,i would be thankful if you will help me.To be more precise i am putting my question once again--
i want to write a script to adjust printer setting.Using script component i want to open the excel file that i have placed in the folder and make printing settings and save that file.
e.g--At the time of generating the report from ssrs in excel format there only i want to change the page size.as per my wish i can change the page size.

Richard MacCutchan 10-Dec-15 4:18am

Well you will still need to do what I suggested above, to find out what the values are and how to set them. You then need to use the Excel Interop features to edit the Excel file from your C# application. But, quite frankly, a VBA macro would be much simpler.

varun_streetScientist 10-Dec-15 8:42am

if Possible can you please give some piece of code to do the above implementation like how to kick start this

Richard MacCutchan 10-Dec-15 8:46am

I don't have any code, you will need to read the documentation and look for samples for yourself.

varun_streetScientist 11-Dec-15 7:37am

can anyone here to suggest me how to start the approach as i am in learning phase only

Richard MacCutchan 11-Dec-15 8:00am

How much more information do you need? I have given you an explanation of how you can find the commands to reset the printer settings. I have also given you a link to the library that enables you to edit an Excel file. Now it is up to you to do the research, coding and testing.