Every Saturday I need to save 7 files, each having a file name with the dates of the upcoming week (our work week starts on a Saturday). Is there a "Save As" type macro I can create - something like Current Date, Current Date+1, Current Date+2, etc...?
Hi, Wheelie686,
maybe this sniplet may give you an idea of how to solve the problem:
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
This saves the files as (e.g.) 30 Oct 2012.xls but you can change the format to suit and precede with a constant if you need.Please Login or Register to view this content.
Thank you brynbaker. That somewhat does what I want but two issues I would not have expected.
1. It will not let me save where I want, it defaults to a hidden Excel directory on my PC.
2. The name I want to use is (for today for example) is Aliant Intraday Report Avaya 2012-10-27 but it came out Alia0t I0tra27a301 Report Ava301a 2012-10-27. It's like it has problems with the letters N, D and Y. I can't say I've ever seen that before lol.
Hi, Wheelie686,
Is this place a given folder or do you want to choose it from time to time?It will not let me save where I want, it defaults to a hidden Excel directory on my PC.
Please Login or Register to view this content.Please Login or Register to view this content.Sure, as in the format function these are laid out for Months, Days, and Years. As you didnīt the post probably you included the whole of the variable into the format string?It's like it has problems with the letters N, D and Y.
Ciao,
Holger
HaHoBe - I would actually like to pick where I want to save it even though I'll probably end up putting it in the same place every week.
The code I have now is:
Please Login or Register to view this content.
Hi, Wheelie686,
there you are- if you use the whole name inside the format you have to mask the characters so that VBA will not replace them. Iīd preferred to split things up into two parts - the name and the date part (no worry for VBA changing characters there).
Copy and insert the following function into your module:
And alter your code to readPlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
That worked for the macro that will save Saturday's report but yet when I copy it to create the following days' reports, knowing I have to add + 1,2,etc.. then it doesn't run. The two should be nearly identical, with the excetion of the + 1.
Please Login or Register to view this content.Please Login or Register to view this content.
Hi, Wheelie686,
try this (sorry but I did just realize that the counter was identical to the values which where used):
There will be the question to overwrite if the file already exists - I already had created the first files and had them replaced.Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks