I didn’t read your answer thoroughly enough. I see that you have told me how to date stamp it. Thank you.
Caroline King | Business Analyst | Downer
, Auckland, 2104, New Zealand
Private Bag 93325, Otahuhu, New Zealand
From: GregDavis11009 [mailto:bounce-GregDavis11009@toadworld.com]
Sent: Tuesday, 18 March 2014 03:47
Subject: RE: [Toad Data Point - Discussion Forum] Toad DataPoint 3.4 Task Automation
RE: Toad DataPoint 3.4 Task Automation
Reply by GregDavis11009
Make sure the overwrite checkbox is unchecked. You need to use the advanced button on the select to file so you can export to just the 1 tab. Now here is where you may have a problem. You need to clear the worksheet unless your data is always the same number of rows (there is a checkbox for that on the advanced tab). Clearing the worksheet will remove your formulas. So if you need to clear the worksheet you need to move your formulas to another worksheet with the formulas still pointing to the Data tab. You can set your spreadsheet to auto refresh on opening but I have had limited success with that method. I prefer using the automation to open Excel with an .xlsm macro file in the argument line. The macro file can open your spreadsheet with today’s date appended to the file name and then refresh the pivots as well as dynamically set the pivot range if you like and even build your formulas if you want them on the same sheet. You will need to name the macro Auto_Open() so it launches on opening and include a Application.Quit statement at the end so Excel closes and returns control to the automation job.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum
Flag this post as spam/abuse.
This message is for the named person’s use only. It may contain confidential, proprietary or legally privileged information. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. No confidentiality or privilege is waived or lost by any such mis-transmission or error.
Downer reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Downer includes Downer New Zealand Limited and Downer EDI Engineering Limited and their related and associated companies.
This email has been filtered by SMX. For more information visit smxemail.com