Hello,
I have a macro that I run on a file each morning that formats it, saves it to my network drive(I, emails a copy, then closes. But I am unable to get it to save to the correct folder in the network drive. It will save in the I: but not in a subfolder. If I try to save to my desktop, it does not save it.
This is the section of the macro that does the saving:
Range("A1").Select
Path = "I:"
fname = Format(Date, "mm-dd-yyyy") & "__WPOT_IP_Report"
ActiveWorkbook.SaveAs Filename:=Path & fname, FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False

When I enter the path to the folder(daily report) I want to save, it saves it to the I drive with the name of the folder at the beginning of the file name. Example: "Daily Report_10-03-2013_WPOT_IP_Report". I also tried saving to my desktop "C:\Users\pricer\Desktop" but it just dissapears.

Can you tell from what I have in my macro what might be causing this?