Our Company has some Quattro Pro 8.0 and some Excel users. I have built a macro to import budget worksheets from our AS400 into Excel, parse them appropriately, insert subtotals and grand totals and export to Quattro. The problem is Excel only supports exporting to Quattro for DOS so my subtotal and grand total formulas are lost. Does anyone know of an addin that will allow file conversion to a Windows version of Quattro?
If not how do I write a macro to find all the sum formulas in a range and add them together. Remember that if I have to use this method I can't use Excel's subtotal function. The only valid function I can export to Quattro for DOS is the Sum formula or your basic cell1+cell2+cell3 etc. formula. Also each department's budget worksheet is different so the number and location of the subtotals will vary. I have better than 40 budget worksheets to create so anything I can do to automate makes a big difference.
Thanks in advance
If not how do I write a macro to find all the sum formulas in a range and add them together. Remember that if I have to use this method I can't use Excel's subtotal function. The only valid function I can export to Quattro for DOS is the Sum formula or your basic cell1+cell2+cell3 etc. formula. Also each department's budget worksheet is different so the number and location of the subtotals will vary. I have better than 40 budget worksheets to create so anything I can do to automate makes a big difference.
Thanks in advance