Auto Saving Via Macro To Specific File?

Hi Guys

Is It Possible To Auto Save To A File Via A Macro?

What I Want To Do Is To Auto Save Directly To A Folder On Our System Via A Macro.
The Problem Is That Firstly It Will Need To Look Up A Cell ( D8 ) To Find Out The Job Number
Then It Will Have To Find The Folder On Our System ( Its On Desktop Under Job File Folder ) Then Comes The Hard Bit It Will Need To Locate That Job Number ( Cell D8 ) To Look Up The Relevant Folder To Put It In. All The Job Files Are Labelled Up Eg.( J2663 - Parry ) Then In That Folder Is A Sub Folder Called Docs Which It Needs To Be Saved In

Regards

hi guys

anyone know if this is possible either way?

hi guys

ive tried running a macro but as soon as i get to the job file folder its not like i can do anything else what with them all being different

anyone any ideas please?

maybe some code?

Stumped Everyone Even At Oz

Cant Be Possible Must Be The Only Option

Thanks To All You Guys Who Looked Anyway

Hi Steve,

You might want to try posting this question in the Excel Programming folder with a link back to here. Many people with VBA experience tend to spend most of their time in that folder.

ChemistB