Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking for Changes in File's Cell Layout
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I switch from Office 2007 layout to the old 2003 layout? | Excel Discussion (Misc queries) | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
In Cell Layout | Excel Worksheet Functions | |||
File's last modified date | Excel Programming | |||
Assessing File's Properties | Excel Programming |