Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a logo to an Excel spread sheet
Message
From
12/07/2003 10:08:45
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00808850
Message ID:
00809567
Views:
23
Hi Yuri,

I was not explicit. I changed where I put the
".WorkSheets(1).Pictures.Insert"(CSCLogo)
line of code in the overal routine so the .gif would insert on the spread sheet where I wanted it.

WITH oExcel
&& Insert 3 rows:
.Cells(1,1).Value=[Insert row above this line]
.Range("A1").Select
.Selection.EntireRow.Insert
.Range("A2").Select
.Selection.EntireRow.Insert
.Range("A3").Select
.Selection.EntireRow.Insert
.Range("A4").Select
.Selection.EntireRow.Insert
*
.Range("B2").Select
.WorkSheets(1).Pictures.Insert(CSCLogo)
*
&& Insert 2 line title:
.Range("F1").Value = "INSUFFICIENT DATA REPORT"

ETC.


Thanks! Have a great weekend.

Paige
Previous
Reply
Map
View

Click here to load this message in the networking platform