Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Office Automation with Excel - Footers
Message
From
13/01/2016 15:34:11
 
 
To
13/01/2016 15:10:21
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01629767
Message ID:
01629768
Views:
65
>I am using office automation and want to add a filename and path to a footer. It seems simple and add this simple value to the leftfooter
>
>"&[Path]&[File] &[Tab]"
>
>Now when I go into the print preview for Excel I see it show up as Path} File} Tab}
>
>When I go into the page layout and into the actual footer in the Excel sheet everything looks perfectly fine as shown above without the quotes in the correct left footer box only it is highlighted for some odd reason. If I click the cursor after it so it is not highlighted and hit OK everything shows the file paths as they should be.
>
>What is making this section get highlighted and hence not work properly?

Have you tried recording a macro as you set up such a footer interactively and compared the macro's code to your code?

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform