Macro to open file name in date format

[Chetan Chauhan]

Hi Friends,

I want my macro to open a file from a folder whose name is bfna_210710 (Name contains yesterday's date). I know the simple code which open the file with today's date. Could you fine tune the below code so that it opens the file with yesterday's date included in the file name.

Please Login or Register  to view this content.

thanks in advance

[Chetan Chauhan]

Hey ! anybody to help me on this?

[royUK]

What's VD-1?

[Chetan Chauhan]

Its value date -1 eg

Please Login or Register  to view this content.

[royUK]

Well we aren't psychic,amend the title accordingly & you might get help

Also,change the PHP Tags to Code Tags

[nareshjikbn2]

this is the solution
Sub Macro1()
'
' Macro1 Macro
'

'
Workbooks.Open Filename:="c:\NARESHBHAI\cm" & Format(Date - 1, "DDMMMYYYY") & "bhav.csv"
End Sub

[srikeers]

Can any one help, How can i find the last file named with the text and date format..
Suppose
srik_07152013
srik_07162013

If today is 07192013 i want to open the last file based on which is 07162013 how can i?

Used code, But error

Sub openthefile()
Dim i
i = 1
Workbooks.Open Filename:="\\1.2.3\abc\xyz_" & Format(Today() - i, "MMDDYYYY") & ".xls"
i = i + 1
Loop Until i = 30
End

Can any one help?

[srikeers]

Can any one help, How can i find the last file named with the text and date format..
Suppose
srik_07152013
srik_07162013

If today is 07192013 i want to open the last file based on which is 07162013 how can i?

Used code, But error

Sub openthefile()
Dim i
i = 1
Workbooks.Open Filename:="\\1.2.3\abc\xyz_" & Format(Today() - i, "MMDDYYYY") & ".xls"
i = i + 1
Loop Until i = 30
End

Can any one help?

[protonLeah]

srikeers,
Unfortunately:
1. Your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

2. Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here