Folks...
I didn't receive a reply, so I've re-worded my question, opening it up for other solutions, besides what I was attempting.
I have a series of Excel files (path/filename stored in a table - tblOutlines) that I need to step through. Each file has several worksheets, and each worksheet has a summary area. The summary areas are all named ranges with a recognizable name(Summary_xx). I need to be able to loop through these files and sheets/ranges to extract the values and transfer them into Access. This process will be initiated by the user. Each range is a 3x6 block of cells with the data in predictable locations, and I need to extract the specific values from these cells and transfer them into a table (tblSummary).
Does anyone have any suggestions? I've tried several methods, and though the basic logic is easy enough, each one seems to hit a number of errors. I know there must be an easier approach than what I'm trying, so I'm hoping someone who taps into Excel files in their programs can help me out.
Thanks!
-Gerry Seymour
I didn't receive a reply, so I've re-worded my question, opening it up for other solutions, besides what I was attempting.
I have a series of Excel files (path/filename stored in a table - tblOutlines) that I need to step through. Each file has several worksheets, and each worksheet has a summary area. The summary areas are all named ranges with a recognizable name(Summary_xx). I need to be able to loop through these files and sheets/ranges to extract the values and transfer them into Access. This process will be initiated by the user. Each range is a 3x6 block of cells with the data in predictable locations, and I need to extract the specific values from these cells and transfer them into a table (tblSummary).
Does anyone have any suggestions? I've tried several methods, and though the basic logic is easy enough, each one seems to hit a number of errors. I know there must be an easier approach than what I'm trying, so I'm hoping someone who taps into Excel files in their programs can help me out.
Thanks!
-Gerry Seymour