Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Foxypreviewer question

Status
Not open for further replies.

titoneon

MIS
Dec 11, 2009
335
US
Hi all,

I created in vfp 9.0 sp2 using Foxypreviewer a report form and in the "Title" section of the report, i added a logo which is a "jpg file",so i can open this report in Ms word 2010, using the code below, and it was sending everything, plus the logo that was in my "TITLE" section of my report, so the Ms word document shows at the top of the document, the logo and then below the rest of report.

Code:
SET REPORTBEHAVIOR 90
DO FOXYPREVIEWER.APP
REPORT FORM iso-730 OBJECT TYPE 12 TO FILE "&lc_wpath" preview


now i want to send the output of this report to Excel and open it on Excel so i did what is below
Code:
SET REPORTBEHAVIOR 90
DO FOXYPREVIEWER.APP
REPORT FORM iso-730 OBJECT TYPE 13 TO FILE "&lc_wpath" preview

the report is shown and opened in Excel, everything shows ok but the logo i have in the vfp report, is not shown at all at the top of the EXCEL FILE( and this is what i want to accomplish, otherwise, i will have insert each time i open it in Excel the logo file.
Can anyone advise
Thanks in advance

Thanks a lot
 
The excel output of foxypreviewer is a data only output, it populates the cells, it doesn't forward any graphics into the xlsx it creates.
Rather automate excel directly to get what you want instead of going through foxypreviewer.

Bye, Olaf.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top