Home | Contents | Submitted spreadsheets | How to copy your component into Excel
Download Excelsior | Demonstrations and background reading | Excel science-fiction generator
Why modularise? | "Before" and "after" cartoons | Press | Sponsors | Contact | Jocelyn Ireson-Paine

Ireson-Paine Spreadsheet Parts Repository
How to copy your component into Excel

When you submit the form to customise a component, our server returns your version as a link to an "ETF file". To copy this into an Excel spreadsheet, we supply this VBA program.

This program is held in a spreadsheet of its own. It's a small program, and you'll be able to inspect it by looking at Module 1, if you want to satisfy yourself that it won't do evil things to your computer. (Open it in Excel, then go to Tools, then Macro, then Visual Basic Editor, and the module should be displayed in a new window. If not, select Module1 from the list of modules the VBA editor shows in its left-hand panel.)

To use this program, first download the ETF file for your component. Also, find the spreadsheet you want to copy it into.

You now need to run the copying program. If you open it in Excel, it should display one sheet, which has a "Go" button near the top-left corner. Press this. A file dialogue will pop up, inviting you to select a target spreadsheet. Choose the spreadsheet you want to copy into. Another file dialogue will pop up, inviting you to select an ETF file. Choose one. The copier will then pop up an "about to copy" message, and proceed, leaving the target spreadsheet open when it has finished. You will then be able to look at the new formulae in it.

We have a demonstration which you can try, without needing to use one of your own spreadsheets. Please see our demonstrations page.