How to copy curtain data fields from excel to access table via VBA

[Adnan]

Hi All,

I have an ms Excel spreadsheet with multiple sheets (Sheet1, Sheet2,
Sheet3) that I would like to extract curtain fields from (i.e.: cells A25 and
B12 in Sheet1, and B12 and B25 in Sheet2 etc…) and copy to a tblMain in
Continuous order.

I tried with DoCmd.TransferSpreadsheet but this would copy mass data instead
of curtains cells/ranges throughout the multiple sheets.

Can this be done and how?

Any help/tip provided is much appreciated,
Adnan

 

[vvariety]

Hi All,

   I have an ms Excel spreadsheet with multiple sheets (Sheet1, Sheet2,
Sheet3) that I would like to extract curtain fields from (i.e.: cells A25and
B12 in Sheet1, and B12 and B25 in Sheet2 etc…) and copy to a tblMain in
Continuous order.

I tried with DoCmd.TransferSpreadsheet but this would copy mass data instead
of curtains cells/ranges throughout the multiple sheets.

Can this be done and how?

Any help/tip provided is much appreciated,
Adnan

Have you tried naming your range? and using that named range within
your code?

 

[Adnan]

I have not, but even if I do that it is not going to do me any good because I
get these workbooks from clients and by default they are not named ranges.