Differences

This shows you the differences between two versions of the page.

--- excel_xml_export_xlam_add-in [2012/04/18 15:55] – 173.239.151.234
+++ excel_xml_export_xlam_add-in [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-======Excel xlam add-in for XML Export======
-====Email text for Add-In for Excel 2007====
-I've attached an excel 2007/2010 Add-In that you can use to export the data from excel into xml files that Speed-Quote can read.  Here are the instructions:
-Unzip the files that are attached to this email and save it somewhere that you will remember.  It contains the Add-In (*.xlam), as well as a sample Excel file that you had sent me earlier.
-__To Register the Add-In with Excel__
-  - Open Excel
-  - Click the Microsoft Office Button in the top-left corner and then click Excel Options.
-  - Click the Add-Ins category on the left hand side of the window.
-  - In the Manage box, select Excel Add-ins, and then click Go.
-  - In the Add-Ins box that pops up, click Browse and find the SQ-Colorific.xlam file that you had previously unzipped.  Select the file and click OK. Make sure that SQ-Colorific is checked in the Add-Ins popup box and then press OK.
-  - If everything has gone correctly you should now see a "Speed Quote" tab at the end of your Excel Ribbon Control (top of the screen).
-__To Use the Excel Add-In__
-  - The Speed Quote tab will contain 2 buttons, "Export SQ XML - Ben" & "Export SQ XML - Bryce".
-  - Open a excel data file formatted the same as the ones you sent me.
-  - Select all of the rows that contain data by clicking and/or shift-clicking on the row numbers. Do not select the first header row.
-  - Click the appropriate button in the Speed Quote tab.  (e.g. if you opened an excel file in the same format as Ben's file, press the "Export SQ XML - Ben" button)
-  - Excel will ask you for the name of the SpeedQuote Database to import the products into.  I have defaulted it to "Colorific".  This is the name of the database as it appears in Speed-Quote
-  - Excel will ask you for a filename to save the xml into.
-  - Excel will export the data to that filename and popup a box that says "Export Complete" when finished.
-__Importing the XML files into Speed-Quote__
-  - Start Speed-Quote & goto the Master Entry Sheet
-  - Open the "Database Management" screen using the icon that looks like a file cabinet.
-  - Click anywhere on the white section and select "Load Database -> Import Master Data from XML -> All Products".
-  - Speed-Quote will ask for an xml file to load.  Select one of the xml files you exported out of Excel and press OK.
-These may seem like a lot of instructions, but once you've done it a few times it will become very simple.