Redirecting Pathway in Macro

**Zan03** · 03-23-2010, 11:14 AM

Hi All,

Just wondering if anyone can help me...

The following macro works just fine when i set the path to - GetDesktop, but doesn't seem to work when i make a change...

I need the macro to be directed to "\\werver\www\live\PARK\" as that is where the quotes live...

Please find macro below:

Please Login or Register  to view this content.

Thanks, i'll appreciate any suggestions...

Zanna

**JeanRage** · 03-23-2010, 01:24 PM

Hi,

For your info, VBA requires the path to be fully explicit ...with the drive and all the subdirectories ...

HTH

**royUK** · 03-23-2010, 02:23 PM

You don't need the GetDesktop if the files are not on the desktop,you need the directory letter,C,J or whatever i.e the full path.For example

C:\TestMacro, tip right click on a file in that directory & select Properties,you willsee the location listed. Then change the code tosomething like this

Please Login or Register  to view this content.

**Zan03** · 03-23-2010, 05:04 PM

Thank you for your responces!

**royUK** · 03-23-2010, 06:50 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save