Excel User Group

Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Sign in | Join | Help

Daily Dose of Excel » All Tags » Printing (RSS)

Browse by Tags

Daily Dose of Excel

Home

Syndication

Recent Posts

Tags

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Dymo LabelWriter Part II

A couple of weeks ago, I posted some code to print labels on a Dymo LabelWriter 450. I wanted to post the finished code because it has a few more tricks in it. Function PrintBoardFileLabel(ws As Worksheet) As Boolean Dim bReturn As Boolean Dim vaPrinters As Variant Dim i As Long [...] Read More...

Published Tue, Aug 08 2010 7:30 AM by Daily Dose of Excel

Filed under: VBA, Automation, Printing
Printing to a DYMO LabelWriter 450 from VBA

I recently had to make some file folders at work. About five minutes after I was done, I purchased a DYMO LabelWriter 450. I was using one of those label makers where you punch in the text, hit print, and press down on a lever to cut the label. Then you have [...] Read More...

Published Tue, Aug 08 2010 7:30 AM by Daily Dose of Excel

Filed under: Automation, Printing
VBA Page of Pages in a Cell

In Page of Pages in a Cell, Jan Karel uses defined names and Excel 4 Macro commands to return the current page and total pages in a workbook. The problem is that it doesn’t work properly when the cell is repeated (e.g. File - Page Setup - Sheet - Rows to Repeat at Top). [...] Read More...

Published Tue, Jan 01 2010 4:52 PM by Daily Dose of Excel

Filed under: VBA, Printing

Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.