Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hardship letter explaining devastating loss property loss financi carol Excel Discussion (Misc queries) 1 June 12th 09 02:13 PM
Creating a Drop Down List with Step by Step Instructions for 2007 remarkable Excel Worksheet Functions 2 March 22nd 09 04:36 AM
Need step by step to add invoice numbering to excel template rmt New Users to Excel 4 July 6th 08 11:45 PM
What is the step-by-step procedure for making a data list? Bobgolfs56 Excel Discussion (Misc queries) 1 April 23rd 05 02:19 PM
I need step by step instructions to create a macro for 10 imbedde. diana Excel Worksheet Functions 3 January 31st 05 01:56 AM


All times are GMT +1. The time now is 03:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"