Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Currency Field Problem
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel Currency Field Problem
Divers
Thread ID:
00860427
Message ID:
00860427
Vues:
56
Hello all,
I'm having a problem formatting some Excel columns to display as currency. Here is the code I'm using, taken from Excel's Macro Editor. In this case, the VFP code is the same as the VB. Here it is:
.Columns("J:K").Select
.Selection.Style = "Currency"
(this is, of course, wrapped in a WITH...ENDWITH)

This blows up on the second line, says "Invalid number of parameters". I also tried it by selecting an individual cell (to see if maybe it didn't like the columns), but received the same error. Thanks for any assistance,

jfh
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform