Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Label printing from Excel - scaling or what?
Message
 
 
À
04/07/2005 11:04:10
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01028807
Message ID:
01029231
Vues:
20
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform