Need a Macro to save a file

Hey All,

I am a novice to Macro's so please explain things as if i am 2 years old not 46

I need to create a Macro that allows the User to manually select a workbook from the network.

the Macro then needs to save that workbook with a different name in a different directory.

I have written this but have been having trouble with runtime error 1004 "excel cannont access file "trying to save a copy of the workbook


If anyone could either suggest a solution to my problem or provide alternate code to do the same thing, It would be greatly appriecated -have spent 5 hours or more trolling excel boards looking for an answer

thanks
Dean

Please Login or Register  to view this content.