Here's the question: is there a way to retrieve the range name created by the Import External Data feature?
Now, here's a little background:
I am creating a spreadsheet that will let me retrieve my bank credit card transactions in CSV format and then output a QIF file that I can import into Quicken (they eliminated this feature last month and want me to pay money each month to keep using it).
I am using the "Import External Data" feature. When I open the workbook, it asks to refresh the data, and I then navigate to this month's CSV download, open it, and Excel puts the data in a worksheet tab all by itself.
CSV_Download
<tbody>
</tbody>Excel 2003
Here is the question: Excel automatically assigns a range name to this imported data. The range name is simply the name of the CSV file. While I am using macros to create the QIF file, at this point I'd prefer to find a way to use this range name in formulas without having to enter it.
Now, here's a little background:
I am creating a spreadsheet that will let me retrieve my bank credit card transactions in CSV format and then output a QIF file that I can import into Quicken (they eliminated this feature last month and want me to pay money each month to keep using it).
I am using the "Import External Data" feature. When I open the workbook, it asks to refresh the data, and I then navigate to this month's CSV download, open it, and Excel puts the data in a worksheet tab all by itself.
CSV_Download
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Posted Date | Reference Number | Payee | Address | Amount |
2 | 5/9/2019 | 24427339128710032062810 | LUCKY #703 CARMEL CA | CARMEL CA | -15.81 |
3 | 5/8/2019 | 24431069128898000148724 | COSTCO WHSE #0131 SEASIDE CA | SEASIDE CA | -160.91 |
4 | 5/8/2019 | 24316059127548764002359 | SHELL OIL 57444694509 CARMEL CA | CARMEL CA | -50.95 |
5 | 5/8/2019 | 24431069127975019550404 | SAFEWAY #2669 CARMEL CA | CARMEL CA | -4.85 |
6 | 5/7/2019 | 24906419126072653887328 | Netflix.com netflix.com CA | netflix.com CA | -21.6 |
7 | 5/7/2019 | 24427339126710011809472 | LUCKY #703 CARMEL CA | CARMEL CA | -34.15 |
8 | 5/6/2019 | 24257959125030010155608 | Griggs Nursery Carmel CA | Carmel CA | -12 |
<tbody>
</tbody>
Here is the question: Excel automatically assigns a range name to this imported data. The range name is simply the name of the CSV file. While I am using macros to create the QIF file, at this point I'd prefer to find a way to use this range name in formulas without having to enter it.