Custom Routine Template File


Well-known Member
Dec 21, 2009
I'm in the process of developing a solution using Power Query and/or VBA.

For the purpose of taking any set of data (from a List Object) and converting this for interface into a financial ledger (automated journal creation).

This will involve using userforms and list/comboboxes to:

  • Map the Table columns to the interface file column names
  • identify the columns with values/amount
  • identify columns that will drive the coding

For this I'm happy I have a plan and can see it through, I'm posting for ideas about how to translate the above into a template file so that the user doesn't have to go through the same steps for the same data on a weekly/monthly basis, instead they will load the template file and all options will automatically be assigned.

My intial thoughts are that the three steps above and selections made will be stored in 3 different arrays.
These results will then be saved into one txt file for retrieval at a later date.

Is there a format that would best suit this (JSON, XML)???

Thanks for any input,
Last edited:

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics