Macro works on my pc not on anyone elses suspect adobe problem

[Tazthemonkey]

Hi,

I'm running winxp excel 2010 adobe 9, everyone else is on newer pc's mine is not upgraded due to this problem.

Range"A1" is an order number manually inputed

Macro is

[Sub CopyPDFATD()
Dim src As String, dst As String, fl As String
src = "I:\Website Technical Data\Installation Instructions Master Directory\Adventure Trail - Timber\Adventure Trail - Timber (Timber in Ground)"
dst = "O:\Installation\Installation Instructions\Installation Instruction Input\COPIES For Installers\" & Range("A1").Text
fl = "INST Log Walk ATD_iss06.pdf"
On Error Resume Next
FileCopy src & "\" & fl, dst & "\" & fl
End Sub]

Thanks in advance Terry

 

[bobhc]

Are all the other users using the same named directory's as the macro states

 

[Tazthemonkey]

yes, was me signed onto another pc same rights etc.

 

[Chihiro]

The code has nothing to do with Adobe. It's just code to move PDF file from one location to another.

There are 3 variables in code.

src
dst
fl

Check and make sure each variable is present and matching.

Especially make sure that destination folder (dst) exists, since it's only variable that's not hard coded in the macro. If it does not exist, it will cause error. However, since the code has On Error Resume Next. It's ignoring error and doing nothing.