L
Leslie
Please excuse any terminological errors.
Some time ago, using the "import data" function, 2 VBA modules and 1 VBA
class module, I set up a workbook which, on opening, would update one of the
columns of one of its worksheets from an earlier-downloaded daily .csv file,
do
all recalculations necessary after the updating and then present me with the
"save as" dialog box, inviting me to save the workbook with a name including
the day's date.
Today, the supplier of the daily .csv file changed the file's contents to
add permanently an extra column. That had the effect that, when I opened my
workbook today after downloading the .csv file, two columns from the .csv
file were imported into one of my worksheets, instead of just the one I
wanted. I therefore changed my data importing rules to skip the extra
column. That, however, has had the effect that, after the recalculation
caused by the importing of the 1 column, I'm no longer presented with the
"save as" dialog box. I can't understand why that should be so, especially
since I haven't edited in any way the 2 VBA modules and the 1 class module.
I'd be very grateful if someone would tell me why that has happened and how
to correct it. If thought necessary, I could post the VBA modules and class
module.
Some time ago, using the "import data" function, 2 VBA modules and 1 VBA
class module, I set up a workbook which, on opening, would update one of the
columns of one of its worksheets from an earlier-downloaded daily .csv file,
do
all recalculations necessary after the updating and then present me with the
"save as" dialog box, inviting me to save the workbook with a name including
the day's date.
Today, the supplier of the daily .csv file changed the file's contents to
add permanently an extra column. That had the effect that, when I opened my
workbook today after downloading the .csv file, two columns from the .csv
file were imported into one of my worksheets, instead of just the one I
wanted. I therefore changed my data importing rules to skip the extra
column. That, however, has had the effect that, after the recalculation
caused by the importing of the 1 column, I'm no longer presented with the
"save as" dialog box. I can't understand why that should be so, especially
since I haven't edited in any way the 2 VBA modules and the 1 class module.
I'd be very grateful if someone would tell me why that has happened and how
to correct it. If thought necessary, I could post the VBA modules and class
module.