Hi everyone
First, I would like to thank those who help me each time I need help.
Well, I would like to register an Excel table, like this :
Dim xls_file, tab_file As String
xls_file = "c:\temp\file.xls"
tab_file = "c:\temp\file.tab"
Register Table xls_file TYPE XLS Titles Range "A2:F6"
Open Table tab_file
....then compute the content of the table.....
This assumes of course that datas start always in first column.
BUT in this example, F6 is of course variable. It could be G55, or B477,
etc....it depends of the contents of Excel file.
The question is : how to know the number of lines and columns into the Excel
file, BEFORE registering it ? By this way I should compute the Range of
Excel cells :
Dim str_range As String
str_range = Chr$(65+nb_columns-1) + nb_lines ' where 65 is the ASCII code
of 'A'
This assumes too that 1 <= nb_columns <= 26
Thank you for your help, I hope that this problem will interest you.
Christophe
