Re: xlsmerge - Merge worksheets from different Excel files into one Workbook

My formulas are not coming over with the data, it is just showing 0 instead. Any ideas?

Comment on Re: xlsmerge - Merge worksheets from different Excel files into one Workbook

Replies are listed 'Best First'.
Re^2: xlsmerge - Merge worksheets from different Excel files into one Workbook by Corion (Patriarch) on Nov 19, 2013 at 21:09 UTC
The script only copies values, not formulas. For copying formulas, you'll have to look at how Spreadsheet::ParseExcel offers the formulas, and then copy those instead of the values.	[reply]