Macro to open SAVE AS from current file location

[Mattyevs1000]

Hi

I was hoping for some to create a macro that will open a SAVE AS box and automatically populate the text with cells AD5, AD6 & AD7

Many thanks in advance

[mgs73]

Is there a reason you need to see the SaveAs box? Something like this would achieve the same outcome:

Please Login or Register  to view this content.

[Mattyevs1000]

Thank you, although it doesn't open the save as box. I'd like this to happen to allow users to choose the location.

Thanks again

[mgs73]

Ok, then try this:

Please Login or Register  to view this content.

[Mattyevs1000]

Thanks Mgs73.

The Save as box pops up but the filename is blank - any ideas?

Cheers!

[mgs73]

Do the Ranges AD5, AD6, and AD7 have values in them? I'm guessing they're blank. Perhaps you'll need to specify what worksheet they are on? E.g.

Please Login or Register  to view this content.

[Mattyevs1000]

You were correct, sorry!

Thank you very much