Close Window
Free Ebook
Get Your Free Excel
Top 15 Excel Tutorials from
Instant Access!

Print To Specified Printer Using Shellexecute

Is this possible? Or does it always use the default printer?

Free Excel Courses

Similar Excel Tutorials

How to print all worksheets at once from Excel. This saves you the time of having to go to each sheet individually ...

In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet. This a ...

I'll teach you how to show gridlines for Excel when you print your files. This is a neat little feature that will ...

How to print the comments in a worksheet when you print from Excel. This includes how to print the comments within ...

Helpful Excel Macros

- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth

- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when

- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in

- This free Excel macro allows you to display the print preview mode or window in Excel for a specified Excel worksheet.

- This free Excel macro will print the current active worksheet in Excel. This means that whatever sheet you are currentl

Similar Topics

I added a print button to my userform


Private Sub btn1_Click()
End Sub

This prints out the userform as I would like, however it autoprints to the default printer and doesn't allow any printing options so I can't select to "print to one page". So as of now it is only printing out half my form and cutting off the rest.

Any suggestions?

I have a spread sheet that prints in duplex no matter what I do. I have made sure the printer duplex function is turned off but yet it insists in printing duplex. It is only this one workbook other workbooks print fine.
I hope you have an ansewer.

Why do I sometimes get extra blank pages from the printer on Word or Excel
documents? How can I prevent this?

Hello -

I am using Excel 2007. In prior versions of excel, when copying data, if I wanted to copy visible cells only, I would select "Go To, Special, Visible Cells Only" and then copy a range a cells. The default was always set to copy everything (including hidden cells), unless I specifically selected copy visible cells only.

In 2007, the default is somehow set to always copy only visible cells. Sometimes, I want to be able to copy all cells including those hidden but cannot seem to figure out how to swith this default option. I looked under Excel Options and did not see an option there.

I don't want to have to unhide and rehide everything each time i copy. I know i could do the hiding and unhiding via VBA but would prefer not to have to.

Thanks for your suggestions.

Hello, what I would like to do is take a portion of a sheet..... So the cells I want to mirror are in the proposal sheet cells B32 x F51. And then mirror the exact duplicate copy to another sheet. The other sheet should have those same values at A20 X G39. What I am trying to do is have a sheet that has skus, prices, and so forth and then when I add,delete, merge, color, or do anything to the cell on the "proposal creation" sheet I want it to mirror only a specific cells to another sheet that is "salesman copy" that we will print to clients. So this way ont he proposal copy a salesman can insert rows or even change the color of the cells and then have it mirror exactly the same on the "salesman copy" which is what we will print for clients. Thank you.

Even though I have used Page Layout to set my margins at .3 left and right, I cannot make my columns as wide as they need to be because the spreadsheet continues to print with one inch margins. I am on a deadline -- Help!


I would like to have a help in programming the code for Auto refresh every 5 seconds or so in the excel sheet attached.

The file is Downloaded from one of the sites.
Need to modify with adding a code of auto refreshing every 5 seconds instead of default 1 minutes.


How can I stretch a spreadsheet to fit the page? If I try to make it one page by one page, it changes nothing. If I change the percentage, it becomes two wide...I am just trying to change the height so that it can be read on an 8.5 x 11 piece of paper.

Here's my formula... =SUM(S7)-T5

If that number is less than -100, I want it to show as blank.

Any help?

Right now, I'm trying to accomplish this by making a conditional format...meaning when my cell equals less than -100 I make the cell color and font the same (so it looks blank, but its not). When I print it, it still shows the negative value.


I have a VBMacro Excel file loaded on a Server that numerous people access. A Macro in this file creates a Copy of a specific Sheet within the Active Workbook and I want to Save it to the individual's Desktop.

How do I find out what the current User's desktop folder path is each time the Marco is run by a different User?

Example User's path: 'C:\Documents and Settings\jfarc\Desktop'

Where 'jfarc' is the name of the current User which, will of course change with every different User that runs the Macro.

Also, is there a way to pull out of Excel what is the current User's 'Options | General | Default File location' entry? Which may differ from the above directory.

I am familiar with and use the following coding for Opening/Saving files to the current directory of the opened workbook, but it only gives the path of the existing Excel workbook and not the current User's Directory Path:

Dim wbThis As Workbook
Set wbThis = ThisWorkbook
ChDir wbThis.Path

Hey guys,

I'm trying to write a macro which prints to PDF and saves the file name as the contents of a cell. I've been looking through all the posts currently on this forum to get something working. I'm using the following code -

Sub PrintPDF()
Filename = "C:\Documents and Settings\samb\My Documents\" & ActiveSheet.Range("Z1").Value
SendKeys Filename & "{ENTER}", False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF:", Collate:=True
End Sub

The macro prints to PDF, but then it stops at the Save As stage, where I have to manually enter the name of the file and click Save. I want the macro to automatically name the file with the contents of cell Z1. I then want it to then automatically press enter. Any ideas where I'm going wrong? Any help would be much appreciated!

A previous poster explained what I also need; there were no responses,
so I thought I would try again.

Does anyone know of an Excel template--or a small stand-alone
program--that will calculate the interest/principal breakdown when
payments are varied in amount and frequency? Free or low-cost, please.
I need one that will work on my Mac/Office 2004. I will need to print
out periodic reports.

Here is the way the previous poster described it:
"Excel template: Loan Amortization for random/irregular payments,
figures days
between payment dates.
I have a loan with a variable beginning balance and irregular payments
annual large payment. (based on collections)
Would like to enter payment and date.
then Excel would figure days since last payment, interest amount,
amount, Ending Principal balance.
And total interest paid, total pricipal paid
If I change the starting principal, excel would recalculate all

Thanks very much.

Related pages

fill handle in excel 2007excel transpose examplegetopenfilename vba exceldelete blank rows vbaist to est converterexcel count alphabetcalculate weeks between two dates excelctrl enter in exceldecision trees excelwritten down value method of depreciation formulagolf scorecard template excelthisworkbook vbaedit kml filesvlookup statementexcel odbc sql queryyearly leave plannercpp deduction calculatorexcel file locked by another userexcel 2013 arrow keys not workingremove duplicates in excel 2003trend forecasting excelvba connect to sqlwatermark excel 2007convert 5 kilos to stones and poundsexcel working out percentagescopying conditional formattingexcel sum by cell colortranspose formula excelexcel dynamic named rangeforeign exchange rate bloombergexcel macro formpaypal charges calculatorconcatenate a range of cellsproductivity spreadsheetfree 2d barcodewhere to find excel autosave filescalculate cumulative interest in excelimei check digitrename vba modulertrim excelvlookup in access queryexit vbageneral mail failure excel 2007how to calculate cash on cash returnexcel vba column countmsgbox vba codeshift rota generatorvisio vba tutorialsensitivity analysis excel 2007excel vba odbc connectionhow to insert square root in excelhow to create payslipaustralia redundancy calculatororg chart template excel 2010how to create a gauge chart in excelaccrued interest calculator excelvba 424 object requiredchange underline colorexcel round down to nearest 10qfx file formatcombine worksheets in excelweight conversion stone to kg chartexcel activex controlshow to unhide row in excelreset vba passwordmailto multiple email addressesexcel pmt mortgageedit kml fileswhat is excel macro enabled workbookamount in words excel formulaformula to calculate federal income taxmacros are disabledmerge multiple excel workbooksedit large csv filesvlookup multiple values in one cellhow to expand row height in excelhow to create employee attendance sheet in excel