VBA Code to Return Excel sheet row number

[mhatam]

Hi all,

can anyone please let me know of code to return the row number of created Excel sheet of my MS Access based on the value from Access query? I was thinking of DLookup but seems that's only applicable for within MS Access not to import info from external Excel workbook

any guidance is highly appreciated.

thanks
MH

[CJ_London]

if you have a uniqueID column without gaps and the excel data is sorted on that column and you know which row the excel table starts on you could use the dcount function. Assuming the header is on the first row

rownum=dcount("*","myExcelTbl","uniqueID<" & uniqueID)+1

but you really have not explained the what and the why. What are you going to do with it once identified and why? There may be better ways of achieving what you want,

[ranman256]

You dont have to import the xl data, but you can just reference it.
Link the excel sheet as an external table (no import)
then you can still do the Dlookup, or Dcount.