Long story short I have a program written that once the user clicks submit, an email is generated a sent attaching the excel file they were creating. This is all done in the background as they will be working on a form. I have the program saving a local copy of the .xls file to their WINDOWS\TEMP folder so the email can later attach it. The problem that I'm running in to is that for some people's machines here at work, it isn't saving then generating an error when it later tried to attach a file that isn't there. There's no error regarding saving the file, it just doesn't actually do it. It works perfectly for some people, just not others.
Any help would be greatly appreciated, I haven't been able to make any headway on this problem.
Code:
PSday = Day(Date)
PSmonth = Month(Date)
PSyear = Year(Date)
PSyear = Right(PSyear, Len(PSyear) - 2)
PSpath = "C:\WINDOWS\Temp"
PSfilename = "PSCodeRequest_" & PSmonth & PSday & PSyear
PSfinal = PSpath & "\" & PSfilename
ChDir (PSpath)
ActiveSheet.SaveAs Filename:=PSfilename & ".xls", FileFormat:=56
PSfinal = PSfinal & ".xls"Any help would be greatly appreciated, I haven't been able to make any headway on this problem.
