Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Label printing from Excel - scaling or what?
Message
 
 
To
04/07/2005 11:04:10
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01028807
Message ID:
01029231
Views:
19
Hi Dragan,

I would record Page Setup in Excel macro and than play with those settings in VFP.

>I'm replacing a little app written in Access with a couple of forms in my app. The issue at hand is label printing from Excel. I've copied the automation code (mutatis mutandis) and the template sheet from this app (without change) and achieved the printing OK.
>
>Well, almost OK. Two types of labels need to print (one of those Zebra printers), and while one prints perfectly, the other is printing slightly wider in my case, while the same label prints perfectly from Excel called via Access. The sheet itself is a little weird - the print area contains cells which are rotated 90 degrees, and then the page is set to print landscape - so a few tricks were employed to make this work in the first place.
>
>The Excel printarea in case prints about two characters wider than the actual label - and these two are on the left (which, unfortunately, involves the first digits of the price). The same thing when invoked from Access prints fine on the same printer.
>
>I'll have my hands on the printer in case in a few days and will have to tweak this to print correctly. So, calling all the Excel and label magicians out there - what should I look at? Is there anything that Excel may be doing behind my back to scale it? Is there a way to turn that off? Is there a setting that may have a different default depending on any local settings? (Don't know how would this be possible - Excel is invoked via automation on the same machine, so any defaults should be the same, or should they?)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform