Check exist namerange from excel in Access vba 1

[heroddaji]

Hi, i have a difficult problem

I have to check in a list of excel file, that if the excel file has a namerange, then i will import data from that excel's namerange to access data by vba code..... Quite hard for me.

For ex, I have a list of excel file name FILE 1 ... to FILE 10. and in each file, there will be a namerange WEEK1 in FILE1, then WEEK2 in FILE 2... but may be not(may be FILE3 doesn't have WEEK3). so i have to check.

Hope some expert can help me...

 

[bubba100]

With EXFile being the Excel object and
Dim n
Dim DefNme as String
For Each n In EXFile.ActiveWorkbook.Names
DefNme = n.Name
Next n
This is a way to loop through all the defined names in the Excel workbook.

 

[heroddaji]

thx u , i will give it a try