Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
question regarding external data range
Excel 2003 on XP Pro
Every day I receive a text file with a single record (space delimited). I have written a macro to load that record into the next row of the worksheet, using Get External Data. All that is working fine, but in doing initial testing and debugging of the macro, I noticed that every time I bring in a new record, it creates a new external data range. I really don't need these defined data ranges, I just need the values loaded in. Really just a housekeeping issue ... several months from now, when I have 100+ rows of data, do I really want to have 100+ different external data ranges defined? Or am I obsessing about a non-issue? Is there some way to clean-up/delete the range definitions without deleting the data (cell values) itself? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing External Data Question | Excel Worksheet Functions | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
insert entire row for new data, external data range doesnt work | Excel Programming | |||
How can I check if data in an external data range is changed afte. | Excel Worksheet Functions | |||
import external data via macro/vba question | Excel Programming |