Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loss of automated step
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hardship letter explaining devastating loss property loss financi | Excel Discussion (Misc queries) | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Need step by step to add invoice numbering to excel template | New Users to Excel | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |