Mr. Excel,
I've got a boatload (254) of .xlsx files that I regularly update and re-post to a Share Point website through my VBA code. Before I update them I need to save them in a new, date code (mmyy) folder.
This doesn't work...
Sub StashOldMonth(NewDate)
MkDir "http://my.omnicare.com/private/teams/accounting/" & NewDate
End Sub
Your thoughts? Thanks in advance.
Dan Ferguson
dan.ferguson@omnicare.com
I've got a boatload (254) of .xlsx files that I regularly update and re-post to a Share Point website through my VBA code. Before I update them I need to save them in a new, date code (mmyy) folder.
This doesn't work...
Sub StashOldMonth(NewDate)
MkDir "http://my.omnicare.com/private/teams/accounting/" & NewDate
End Sub
Your thoughts? Thanks in advance.
Dan Ferguson
dan.ferguson@omnicare.com