Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Office Automation with Excel - Footers
Message
De
14/01/2016 13:20:31
 
 
À
14/01/2016 11:42:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01629767
Message ID:
01629809
Vues:
71
>>>My code is pretty basic
>>>
>>>
>>>WITH oExceletc4.ActiveSheet.PageSetup
>>>	.LeftFooter = "&[Path]&[File] &[Tab]"
>>>	.RightFooter = "Page &P of &N"
>>>ENDWITH
>>>
>>>
>>>I really do not see how it could be a problem in the code. The code does what it is meant to do, just not sure why that section gets highlighted
>>
>>Oh, wonder if the issue is what VFP is doing with the ampersands before it even sends the code. Macros are evaluated inside strings. Maybe try using the appropriate CHR() instead.
>>
>>Tamar
>
>AFAIR that should only matter in [] bracketed strings. I wonder if Excel concatination of strings throws a wrench in there

Easy to test by assigning the values to variables and then setting the properties to the variables rather than the text strings. Then, in the Debugger, you can what you're actually passing to Excel.

Tamar
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform