Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Find and Replace the value in the Excel Cell ?
Message
From
14/12/2013 06:46:34
 
 
To
13/12/2013 22:53:54
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP3
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01590219
Message ID:
01590226
Views:
58
lox=getobject(,'excel.application')
loSh = lox.Workbooks(1).Sheets(1)
do while .T.
   loCell = losh.cells.find('Total')
   if isnull(loCell)
      exit
   Endif
   loCell.value = 'SubTotal'
Enddo
>Hi,
>
>I have open an Excel Worksheet in VFP9 and I want to
>find all the cells with the value of "Total" and replace it with "SubTotal:"
>
>How can I do it ?
>
>Please advise.
>
>Regards,
>Derek Yim
Previous
Reply
Map
View

Click here to load this message in the networking platform