Save file as a cell value

[shadow85]

I need a macro when i click the "Save" button it will save the excel sheet in certain path i specify with a cell value as the attached excel in "C4" , Copy paste formula as value including the table .

Appreciate your help .

[mccrimmon]

Hi,

Your explanation is not very clear to me.

Are you saying that you want a button added to your form so that when you press Save, the file is saved with the name of whatever is in Cell C4 to a path that is built into the code?

Thanks

[shadow85]

No , i don't want to make a "Save" button .
I want to use the built in "Save" button when i click it , it will save the file in certain path and name i specify followed by the "No." in Cell "C4" .
Is it possible to do that ?

[mccrimmon]

Change the strFileLocation string to your file path and this should work fine.

Please Login or Register  to view this content.

[shadow85]

It doesn't work ...

[john55]

hi,
as an option, try the code provided by mccrimmon with a small change, save it as "xls"

Please Login or Register  to view this content.