VBA Code for Saving Excel file as "Values and formatting" without formulas, and "under specific cell names"

[hari14]

I am new to this Forum and I Need some help with VBA codes.
I am completely new to VBA and Macros. All i know now is to insert ActiveXcontrols and enter the code.

Please help me withe the following. I would like to have a code with Private Sub CommandButton1_Click()
I have an Excel file with a lot of formulas and protected cells.

All I want is to save a copy of Excel file as "Values & Number formatting" Only in Desktop under a specific cell Name from Cells H4, H5 & D4.

Thank you very much in advance!!


PS: Please give me a code in this Format.
Private Sub CommandButton1_Click()
End Sub



Thanks

 

[Upex]

Re: VBA Code for Saving Excel file as "Values anf formatting" without formulas, and "under specific cell names"

No to sure if you can convert everything at time of save hari, will be interested if you can, others will be better placed to answer.

However if not, you could use the macro recorder to record the action of selecting the whole sheet (as in ctrl a and a again, rather than just active range), copy and paste special (values and numbers), repeat for all sheets as needed etc, then save as.

This would achieve the same thing, and you can tweak code for the save name etc as needed.

Can't give you code, I'm on a tablet, but the macro recorder is your friend.

 

[hari14]

Re: VBA Code for Saving Excel file as "Values anf formatting" without formulas, and "under specific cell names"

Thanks Upex.

I will try this.
Unfortunately, recordning macro does not work as per the requirement mentioned above.

Hope someone can help me out.
Thanks

 

[hari14]

Re: VBA Code for Saving Excel file as "Values anf formatting" without formulas, and "under specific cell names"

Hey Guys, I am still hoping that someone can help me out
Thank you!!