Can you share the file?There's really no other way I can even GUESS what might
be wrong.
Is the macro looking in the correct cell for a path?Is there a value in the
cell?Is the path spelled correctly? using the correct syntax?does the path
exist?
Since it works for ME, there's really no way to g
Dear Paul,
thanks for the reply.
I am also working on the option number 3, which you have suggested.
where is you see, I am assigning a value of path to a veriable "P" and the
using "ChDir = P"
where value of P is taking from a excel cell.
Kindly suggest what may be going wrong in it.
On Thu,
In Macro1, you specify the full pathname:Workbooks.Open Filename:= _
"D:\Phillipins\Automation\Raw Data\CUSTOMIZED REPORT.xlsx"
in the others, you are not defining the path.In the first you ARE using:ChDir
"D:\Phillipins\Automation\Raw Data"but don't need it in Macro1
since you're not incl
