1004 error - excel cannot find C: etc

[stevebrodie]

Hi All,

I have a macro that opens a file from a server (using dll from Remedy Action request system). User clicks a button to import data and sort, then clicks a further button to email report out to collegues. This works on all the PC's in the office (running 2007 or 2010) EXCEPT for one ! The user gets the following message;

Microsoft Excel cannot access the file
'C:\progra~\micros~2\office14\'. There are several possible reasons: etc,etc

I have checked the excel folder is in the right place, he has access rights to the C Drive and i am using the With OutMail command in VBA.

The only thing different with his pc is that he had his profile reset so has two 'My Documents' Folders - one on his C Drive and the other stored in the usual place C:\Documents and Settings\*PROFILE*\My Documents . I have renamed the folder on his C drive to My Documents1 but still get same error message - do i need to change something else or restart his laptop?

He needs to send out this report nightly to higher management, so any help would be very much appreciated.

Best Regards

Steve

 

[jim may]

I have used this User Defined Function to get the system to find this type of thing in the past,,, Maybe you could use it (in some way).. Good luck..

Public Function MyDocsPath() As String
    MyDocsPath = Environ$("USERPROFILE") & "\Documents\"
End Function