Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing pictures in excel with VB
Hi,
Usually I do use Excel as print medium for my VB programs. Since I have to print pictures, I have created a XLT template with an image object at the right place with the right sizes. The "picturealignment" and "picturesizemode" properties (should) give me the perfect result. However when I launch the program, I do not have the possibilty to fill the image object with the picture, I've tried : activesheet.image1.picture = loadpicture("c:\MyPicture") but .... this command works perfectly as an Excel macro (VBA) but not at all with a standalone VB program. Any suggestions ? Thank you very much. Jean-Marie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing pictures in excel with VB
Do you have a reference set to the OLE Automation Library (stdole2.tlb in
xl2002). -- Regards, Tom Ogilvy "Jean-Marie Bossuyt" wrote in message ... Hi, Usually I do use Excel as print medium for my VB programs. Since I have to print pictures, I have created a XLT template with an image object at the right place with the right sizes. The "picturealignment" and "picturesizemode" properties (should) give me the perfect result. However when I launch the program, I do not have the possibilty to fill the image object with the picture, I've tried : activesheet.image1.picture = loadpicture("c:\MyPicture") but .... this command works perfectly as an Excel macro (VBA) but not at all with a standalone VB program. Any suggestions ? Thank you very much. Jean-Marie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing comments with pictures | Excel Discussion (Misc queries) | |||
Printing spreadsheets with pictures in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel printing problem, pictures trunkates | Excel Discussion (Misc queries) | |||
Pictures and/or Graphs in Print Preview not Printing in Excel and | Excel Discussion (Misc queries) | |||
Problem with Excel distorting pictures during printing | Excel Discussion (Misc queries) |