Every month we download a very large Excel file containing data that we
import into our system, and I have some code that pulls data from certain
specific cells in the monthly file. Unfortunately, this monthly file is not
in a database format, but the specific data items are in exactly the same
cell locations each month (for example, the P/E ratio for the S&P500 is in
cell XXX). To make sure that none of the data items in the monthly file have
shifted, for example, from cell AK51 to cell AK52, my code does a simple
check on a few test cells to make sure that their titles haven't changed and
gives me a warning if anything has changed. But this method misses a lot of
possible changes, since it's a huge file. Can anyone suggest a better way?

Hi,

One possible method, provided the data file that you import is being
produced by another program, is to request that a specific named range should
be given to each cell you are interested in. Then you write the code to get
the info from each of the named ranges.

Alok

"Stratuser" wrote:

Every month we download a very large Excel file containing data that we
import into our system, and I have some code that pulls data from certain
specific cells in the monthly file. Unfortunately, this monthly file is not
in a database format, but the specific data items are in exactly the same
cell locations each month (for example, the P/E ratio for the S&P500 is in
cell XXX). To make sure that none of the data items in the monthly file have
shifted, for example, from cell AK51 to cell AK52, my code does a simple
check on a few test cells to make sure that their titles haven't changed and
gives me a warning if anything has changed. But this method misses a lot of
possible changes, since it's a huge file. Can anyone suggest a better way?

Unfortunately, i have no control over the vendor that makes the download
Excel file available, so asking them to assign range names to the data items
I need won't work. Good idea, though.

"Alok" wrote:

Hi,

One possible method, provided the data file that you import is being
produced by another program, is to request that a specific named range should
be given to each cell you are interested in. Then you write the code to get
the info from each of the named ranges.

Alok

"Stratuser" wrote:

Every month we download a very large Excel file containing data that we
import into our system, and I have some code that pulls data from certain
specific cells in the monthly file. Unfortunately, this monthly file is not
in a database format, but the specific data items are in exactly the same
cell locations each month (for example, the P/E ratio for the S&P500 is in
cell XXX). To make sure that none of the data items in the monthly file have
shifted, for example, from cell AK51 to cell AK52, my code does a simple
check on a few test cells to make sure that their titles haven't changed and
gives me a warning if anything has changed. But this method misses a lot of
possible changes, since it's a huge file. Can anyone suggest a better way?