Looking for a little help to do the following:
I have a file called template.xls that I need to copy to a location on a server. The template file is at //mars/shared/iedept/webportal/template.xls and I will need to copy this file to //mars/shared/clientreviewdocs/##/$$$-template.xls.
## = a publisher code that is in the Access DB field [criteria]![pubcode] and $$$ = a magazine code that is in the Access DB field [criteria]![magcode]. The tricky part (for me anyway) is that some times the ## folder doesn't exists, so it may have to be created. I will also want to delete the //mars/shared/clientreviewdocs/##/$$$-template.xls if it exists before I copy the new file to that location.
Thanks for the help.
Josh
I have a file called template.xls that I need to copy to a location on a server. The template file is at //mars/shared/iedept/webportal/template.xls and I will need to copy this file to //mars/shared/clientreviewdocs/##/$$$-template.xls.
## = a publisher code that is in the Access DB field [criteria]![pubcode] and $$$ = a magazine code that is in the Access DB field [criteria]![magcode]. The tricky part (for me anyway) is that some times the ## folder doesn't exists, so it may have to be created. I will also want to delete the //mars/shared/clientreviewdocs/##/$$$-template.xls if it exists before I copy the new file to that location.
Thanks for the help.
Josh