I need to copy .xlsm file data to new empty work book ..help

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.



This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.