Hi, I have one .xlsm file , I need to copy its data to another fresh workbook while retaining the same format and values.
Is there any macro method? or keystrokes way
Hi, I have one .xlsm file , I need to copy its data to another fresh workbook while retaining the same format and values.
Is there any macro method? or keystrokes way
Hey @ABHI_S,
Read the .xlsm file with using Exel Application scope read range and give it an output variable then wite the same data to the Workbook using Workbook write range.
I hope this will help you.
Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.