Hello, thanks in advance for your support. I'm dealing with a pretty simple scenario but I'm stuck and I need some advice/help....
We have an old (but free&efficient) software that recovers data from any RS232 lab equipment to excel. This software always opens a new blank workbook based in the original excel template, no matter if we have defined other template as the default for new documents. I don't know how it manages to to this, but avoids the use of the default template we've set up in excel, and opens a new document based in the stock template of excel.
Once opened the new workbook, it copies the data that the equipment sends through the RS232 port, starting in the a1 cell of the first worksheet.
We're trying to program a macro to insert a worksheet with formulas in the workbook opened by the software. This worksheet with formulas is stored in other workbook (called "Formulas"). When we copy the worksheet, the formulas keep the references of the "Formulas" workbook, so they can't process the data obtained from the equipment, as they are in the newly opened workbook.
Hope I've explained myself properly, any help will be greatly appreciated,