Automate daily change in Saved import option

[akashneelh]

Hi,

Please suggest how to change saved import path option daily .

Suppose, my current import path is

D:\Assam\BI_Dump_ASM\2012\Nov'12\1-17-2013\DailyActBalance.csv

I need to automate it daily like
D:\Assam\BI_Dump_ASM\2012\Nov'12\1-18-2013\DailyActBalance.csv
D:\Assam\BI_Dump_ASM\2012\Nov'12\1-19-2013\DailyActBalance.csv

 

[DavidAtWork]

Assuming you want to use today's date a starting point then you path could be:
importPath = "D:\Assam\BI_Dump_ASM\" & Year(Date()) & "\" & Format(Date(),"MMM") & "'" & Right(Year(Date()),2) & "\" & Format(Date(),"MM-DD-YYYY") & "\DailyActBalance.csv"
David