Hi there all VBA folks,
I have a VBA program that creates a new folder once a year. Instead of having to change the folder name in the macro every year I input it as such that is highlighted in red. It throws a syntex error. Any thoughts on how I could do it any different so it doesn't throw an error.
Workbooks.Open Filename:="Workbooks.Open Filename:="L:\GH Linen Orders\Yearly Reports\" & YEAR(DATE) & ".xls", UpdateLinks:=True
If you would need more code let me know.
Thanks VBA gurus!
LeapingLizard
Bookmarks