save as desination

Hi Guys

I was recently helped with a problem and thanks to those that helped.

Below is the code that i am now currently using and wish to tweek further.

Please Login or Register  to view this content.

Question, can the " FPath = "F:\quote"" be the value of a cell within the workbook but located on another sheet.

Thanks in advance.

PS, i may not have got the hang of code tags so i need help with that as well.

Regards

Keith

Yes you can do something like this:

Please Login or Register  to view this content.

P.S. Your initial code tag was [/code] but it needs to be [code]. I corrected it.