Save workbook or worksheet value only to other xlsx file.

Add-in Express™ Support Service
That's what is more important than anything else

Save workbook or worksheet value only to other xlsx file.
 
KB LIM




Posts: 10
 Joined: 2018-01-01
Hi,

I'm trying to save the entire workbook into another XLSX file with value only (without formula).

May I know if there is already a standard function to do so?

Thanks!
Posted 30 Sep, 2020 22:20:03 Top
Andrei Smolin


Add-in Express team


Posts: 18830
 Joined: 2006-05-11
Hello,

You can create a Range object covering the complete sheet (not workbook), call Range.Copy to put the range info to the Clipboard, then construct another range covering the complete sheet of the destination workbook and call Range.PasteSpecial().

See also https://docs.microsoft.com/en-us/office/vba/api/excel.range.copy and https://docs.microsoft.com/en-us/office/vba/api/excel.range.pastespecial.


Andrei Smolin
Add-in Express Team Leader
Posted 01 Oct, 2020 02:27:14 Top