Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel macro
Message
From
21/06/2001 16:38:09
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00522064
Message ID:
00522174
Views:
13
>Not really VFP related but I need to setup a formula (macro?) in Excel where if a user enters a number greater than 0 it puts a date the number was entered (like today) in the next column in the same row. Anyone have any suggestions? TIA.

John,
I never tried that myself. If you could formulate it in Excel VFP systnax would be :
oExec.Activeworkbook.Activesheet.Range('B:B').Cells.Formula = ...
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform