Workbooks property
For the life of me I can not remember how to add a variable name to a file
path.
I have converted a file from text to xls and have saved it as myfile - date
in mmddyy
I have tried workbooks("myfile-"&date).close savechanges:=false.
but it does not like that.
|