I am new in Excel VBA and macros and I am facing some difficulties in coding. I am working in a daily data that are placed in a folder everyday, I need a code to import the file of yesterday's date whenever I run the macro. Any suggestions?
I am new in Excel VBA and macros and I am facing some difficulties in coding. I am working in a daily data that are placed in a folder everyday, I need a code to import the file of yesterday's date whenever I run the macro. Any suggestions?
It takes a bit more code if you skip Weekends/Holidays and suchDim YesterdayName as string YesterdayName = Format(Date-1, "FormatString") & ".xlsm"
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ