Macro SAVE AS not working

[Mattyevs1000]

Hi

I have this macro that when activated, displays the SAVE AS box and fills the file name with the contents of a cell. However, when you press SAVE - nothing happens.

Please Login or Register  to view this content.

Thanks in advance!

[sintek]

Hi Mattyevs1000

Please take a moment to read our forum rules...here
Your post does not comply with Rule # 2
2. Programming code must be enclosed in code tags to improve readability. (A, Z)

Please Login or Register  to view this content.

So...Edit your post...Highlight the code and press the # button

We cannot assist until this has been done...

[Eastw00d]

The GetSaveAsFilename dialog box, is not a save function, it is used to get the string you want to save as, you will still have to use a save-as line to complete the action.
Just record a "save-as" action by hand and you will see the difference.

Cheers
Erwin

[Mattyevs1000]

Thanks Edwin however I am struggling as I do not understand the codes - I am very much a novice!

[sintek]

Please Login or Register  to view this content.

[Eastw00d]

Are you still using Excel 2003? As the code that you have in your initial post is designed for newer versions.

Cheers
Erwin

[Mattyevs1000]

Thanks Erwin, worked a treat. No I am using 2016.

One last question, how can that code be adapted to add a file path location that is contained in CELL AX5? Thank you!

[sintek]

If you have the filename in AQ5 and the folder path in AX5 when why "GetSaveAs"

Why not just...

Please Login or Register  to view this content.

[Eastw00d]

@ Mattyevs1000,
So please update your MS Office version in your profile

Cheers
Erwin