Is there anyway to specify what directory my macro copies. I am using a macro to copy a sheet, e-mail it, then delete the sheet. I've ran into a problem now in that when my macro copies the sheet it copies it to a directory where my delete macro won't work.
I thought it should stay in the directory where the file I had open was in but for some reason my copies end up in an NT folder.
My delete macro has the code to look into a specific folder:D:docs
Can I change the code of the copy to:
Sheet(1).Copy ("D:docs")
Or will I need to change my delete macro to search for the file?
Thanks,
I thought it should stay in the directory where the file I had open was in but for some reason my copies end up in an NT folder.
My delete macro has the code to look into a specific folder:D:docs
Can I change the code of the copy to:
Sheet(1).Copy ("D:docs")
Or will I need to change my delete macro to search for the file?
Thanks,