Support
To load Refinate into Excel 2007 or newer for the first time, your macro security setting must be set no higher than "Disable all macros (with notification)". When you load Refinate into Excel and then click "Show signature details", you will see Refinate's digitally signed certificate ("AnalogDigital Engineering, LLC"). If you prefer to bypass this question each time you run Refinate, then click the "Trust all from publisher" button and Refinate's certificate will be confirmed silently without asking. An alternative to choosing "Trust all" is to assign Refinate's installed folder as a trusted location. A trusted certificate or a trusted location can be removed later (see links below about security settings). Otherwise, when loading Refinate, click "Enable Macros" and you will be asked each time you run it. You can also add Refinate to Excel's list of "Add-ins" to have it load automatically each time you open Excel. To open Refinate's floating window in Excel 2007, click the Refinate icon under the "Add-Ins" tab or use Ctrl+W.
Click a link below to read Microsoft Excel 2007 details about security settings:
- Change macro security settings
- Create, remove, or change a trusted location
Download the most current User Manual (Rev. 1.009, Mar 11, 2011) Refinate3_UserManual.pdf
The top demo is the same as shown on the home page. The other demos are only shown here.
Refinate: GUI Text Parser & Verify BOM, Netlists, much more.
Compare Information in Excel (Compare BOM)
Ultimate GUI Text Parser & Compare Info (Netlists)
History
3.0.16 Mar 19 2011
3.0.12 Feb 18, 2011
3.0.08 Oct 31, 2010
3.0.12 Feb 18, 2011
3.0.08 Oct 31, 2010
More improvements and enhancements to the Text Converter/Importer to simplify and achieve consistent performance when applying more complex command sequences. User Manual updates. A change was made to the Cut operation. "Fixed Hard" can be used to insert text at end of line. The Subtract_Button now subtracts multiple area selections from Refinate's Window content. A message is presented when Justify Left or Justify Right is used on a selection with merged cells instead of causing a fault. Pasting multiple columns works consistently using PasteSafeToCursor. Query finds single digits after hyphens. Remedied: ReduceRowsToOne wasn't performing if "Dups:Mrk,Sumry" was selected even though disabled. Other misc.
Improvements and enhancements to the Text Converter/Importer: Changes done concerning the following areas: the command "FixedWidth Soft" properly accounts for multiple consecutive empty fields; and Space(s) count greater than 1 can be specified as the Text Event and it will be handled accordingly; addressed the handling of inserted and replaced text within Fixed Width Soft regions; text cutting; increased the amount of visible command lines within the procedure list while previewing the result; now parsing commands can be inserted above the first parsing command in the Standard Line procedure list. The User Manual has been updated to include more description -- particularly pertaining to the Text Converter/ Importer.
Remedied an error that prevented final cosmetic formatting of comparison reports generated on new worksheets. The Reduce_Rows_To_One output report will now be formatted to wrap. A minor change to the Help file concerning "Fixed Width Hard".
Improvements and enhancements to the Text Converter/Importer: Changes done concerning the following areas: the command "FixedWidth Soft" properly accounts for multiple consecutive empty fields; and Space(s) count greater than 1 can be specified as the Text Event and it will be handled accordingly; addressed the handling of inserted and replaced text within Fixed Width Soft regions; text cutting; increased the amount of visible command lines within the procedure list while previewing the result; now parsing commands can be inserted above the first parsing command in the Standard Line procedure list. The User Manual has been updated to include more description -- particularly pertaining to the Text Converter/ Importer.
Remedied an error that prevented final cosmetic formatting of comparison reports generated on new worksheets. The Reduce_Rows_To_One output report will now be formatted to wrap. A minor change to the Help file concerning "Fixed Width Hard".