How do i call a procedure

[serge_girard]

Robert,

Try this:

Code: Select all

oExcel:WorkSheets(1):UsedRange:Rows:Count

This will also count empty rows.

Serge

[mol]

So, go to line no. 65535 and decrease loop control util you reach first not empty row

[serge_girard]

Easier:

Code: Select all

 
for i = 1 to oExcel:WorkSheets(1):UsedRange:Rows:Count
  // do somethings
next
 

[mol]

I didn't know UsedRange. Thank you, Serge!

[serge_girard]

Google...internet ... !
New for me too!

Serge

[KDJ]

...
xlUp is defined in excel.ch as:

Code: Select all

#DEFINE xlUp   -4162

Where is excel.ch, I have not found.

Here is MS Excel documentation in single file (EXCEL 2013 Developer Documentation.chm): https://www.microsoft.com/en-us/downloa ... x?id=40326

[mol]

I found excel.ch few years ago, I don't remember where. I can post it from my computer

[ROBROS]

Serge,

that sounds good,I will try it tomorrow at my office, on my Linux PC I have no excel installed, though I have virtualbox installed I have no licence to install excel.
Mareks proposal for checking for the first empty row doesn't work for me, but:
The last row has a cell always containig the same string (it's a footer row) so I could check instead for this string and then exit the loop.
Or I will check backwards for the first not emtpy row. (sophisicated)
I think this method is sure better, maybe one day they change the footerrow

Btw I think for further questions which I am afraid will occur, I will open a new thread with a new topic.

Guys, you are great, thank you so much.

Robert

[ROBROS]

I found excel.ch few years ago, I don't remember where. I can post it from my computer

Marek,

that would be great.

[ROBROS]

Just to give a feeback:

Serge's suggestion is working.