Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using variables to give Column Reference in EXCEL
Message
From
24/06/2011 11:25:27
Sergey Berezniker
New York, United States
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Using variables to give Column Reference in EXCEL
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01515862
Message ID:
01515866
Views:
55
You asked how to use variable not how to correctly specify range.
lcRange = "G:G"
oExcel.ActiveSheet.Range(lcRange).NumberFormat="$###,###";($###.###)"
>Doesn't the RANGE property require a starting place as well? Can you get away with only lcEndColumn's value only?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform