Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
This may help:
*xlLastCell=11
*xlR1C1 = -4150
lcLastCell = ObjExcel.ActiveSheet.Range("A1").SpecialCells(xlLastCell).Address(.f.,.f.,xlR1C1)
?ObjExcel.ActiveSheet.UsedRange.Rows.Count
?ObjExcel.ActiveSheet.UsedRange.Columns.Count
>Hi everyone,
> I am working on a project where I open an existing excel sheet and add information to it from a DBF file. So far I figured out how to open the spreadsheet and add to it but I am having trouble finding out what column I can start at. I don't want to write over data that is already there. Does anyone know how to find the first available column? I think the concept is to go end of the spreadsheet "A65536" and then CRTL+END but having trouble getting it to work. Any help would be greatly appreciated.
>Thanks
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement