Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding a logo to an Excel spread sheet
Message
De
12/07/2003 10:08:45
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00808850
Message ID:
00809567
Vues:
22
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform