Solved

amend vba to reflect -1 day

Posted on 2014-01-09
4
191 Views
Last Modified: 2014-01-09
Hi Expert's excel 2007

how would I amend so the date on the saved file is less one day from current date..


, InStrRev(ActiveWorkbook.Name, ".") - 1) ActiveWorkbook.SaveAs Filename:="\\jjjdje.com\file2\" & WbkName & "_" & Format(Date, "dd mmm yy") & ".xslm
0
Comment
Question by:route217
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
Nick Denny earned 500 total points
ID: 39768500
, InStrRev(ActiveWorkbook.Name, ".") - 1) ActiveWorkbook.SaveAs Filename:="\\jjjdje.com\file2\" & WbkName & "_" & Format(Date -1, "dd mmm yy") & ".xlsm

and its still xlsm

Cheers
0
 

Author Comment

by:route217
ID: 39768515
Cheers nick
0
 
LVL 13

Expert Comment

by:Ashok
ID: 39768548
Replace Format(Date, "dd mmm yy")

with
TEXT(TODAY()-1, "dd mmm yy")
0
 

Author Comment

by:route217
ID: 39768684
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Make a Cell act like a Date 7 39
Getting error in connectionstring with Excel. 30 32
Excel calculate based on 'x' in column 2 25
how to add loop into this VBA 3 29
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question