 |
Spreadsheet Basic (spBasic) - Downloads |
|
|
|
|
|
|
|
|
To install a free Fully Functional Trial copy of Spreadsheet Basic, follow these steps. First download the installation 'zip' file to a temporary directory from the link below. Download Spreadsheet Basic Ver 1.1.10
Step 1) Unzip the file to the same directory, then run 'spBasic_<version number>.exe'. Click 'Next',
Click 'Install' to install spBasic. This screen tells you to go to this web page for instructions. Ignore this since you're already here. Press 'Next'.
Click 'Finish'. The installation will create a directory 'C:\Program Files\spBasic' and the subdirectories shown below, - The two main subdirectories under the 'spBasic' directory are 'AddIns' and 'Examples'. The 'AddIn' directory contains the spBasic Add-Ins and the 'Examples' directory contains some spBasic examples contained in this website. There are also Example workbooks under each Instrument subdirectory. - There are also Statement Text Files in each Instrument AddIn directory. These text files can be used to create custom code for your particular instrument. See the Instrument Control page for more information on Statement Text Files. Step 2) Adjust the security settings - Instructions for Excel 2000-2003 Set
the security under the 'Security Level' tab. Select 'Medium' or 'Low'
security. . If you use the 'Medium' setting, Excel will ask you to enable
macros each time Excel is run. If you use this setting, make sure you
select 'Enable Macros' each time you run Excel or you will get an error
message when you run an spBasic program. If you don't want a security
message to be displayed each time you run Excel, select 'Low' security. After modifying the security settings, remember to exit Excel and restart it. The security settings are not active until Excel is closed and restarted. Step 2) Adjust the security settings - Instructions for Excel 2007 Note to Excel 2007 users: To use spBasic with Excel 2007, you must save your Excel worksheet as either a Macro-Enabled '.xlsm' file or as a Excel 97 - 2003 Format '.xls' file. Saving as a '.xlsx' file will not work since this format will not allow macros. When you create a new worksheet, the first thing to do is click on the Office Button on the upper left and choose "Save As -> Excel 97-2003 Workbook (*.xls)" or as a Macro-Enabled (*.xlsm) file and save the workbook. It's recommended that you use the Excel 97-2003 Workbook (*.xls)" format for backward compatability. To adjust the security settings in Excel 2007, click on the Office Button on the upper left to get the menu below. Press the 'Excel Options' button on the lower right to get the Options window. Press the 'Trust Center' button. Under 'Macro Settings'. Select 'Enable all macros'. You will be protected from unsafe macros if you have virus scanning software installed (if you don't, you should). Also, never download and run any workbooks that you don't trust. Under the 'Developer Macro Settings' , make sure the 'Trust access to the VBA project object model' checkbox is checked. Then press OK, then exit Excel and restart it. After modifying the security settings, remember to exit Excel and restart it. The security settings are not active until Excel is closed and restarted. The next step is to install the spBasic Add-Ins. Select the menu item "Tools -> Add-Ins" - Press the "Browse" button A new menu item called 'spBasic' should now appear on the Excel menu bar. Also, when you right-click on the spreadsheet, new spBasic menu items should be displayed starting with 'Create, Edit, or Run spBasic Programs'.. Menu Bar Mouse Right-Click Menu Note to Excel 2007 users: To use spBasic with Excel 2007, you must save your Excel worksheet as either a Macro-Enabled '.xlsm' file or as a Excel 97 - 2003 Format '.xls' file. Saving as a '.xlsx' file will not work since this format will not allow macros. When you create a new worksheet, the first thing to do is click on the Office Button on the upper left and choose "Save As -> Excel 97-2003 Workbook (*.xls)" or as a Macro-Enabled (*.xlsm) file and save the workbook. It's recommended that you use the Excel 97-2003 Workbook (*.xls)" format for backward compatability. Install the Addins into Excel 2007 - Click on the Office Button on the upper left to get the menu below. Press the 'Add-Ins' button to get the window below,
On the bottom of the window, select 'Manage: Excel Add-Ins' and press 'Go'. Press OK on the Add-In form and return to Excel. A new menu item called 'spBasic' should now appear on the Excel menu ribbon under a new 'Add-Ins' tab. Add-Ins Tab Click 'Show Developer tab in the Ribbon', then OK. The Developer tab should then be displayed in the menu ribbon.
Step 4) Start spBasic Reminder Window If you want to continue running the evaluation version of spBasic, press OK and continue. If you want to purchase spBasic, follow the instructions below. If your evaluation period has expired, you will get the message,
Press 'OK' and you should get the message, If you didn't get this message, make sure you have both the Name and Key entered exactly as given to you when you purchased the software. If you have any problems, follow the directions in the confirmation email you will receive, or contact us. If you're NOT using spBasic for instrument controls, you should now be able to run spBasic programs. If you ARE using instrument controls, you may have to install additional software. See the Instrument Controls section below. Then see 'Getting Started' on the spBasic Language page. Example programs are included in the 'C:\Program Files\spBasic\Examples\' directory. --------------------------- Instrument Controls --------------------------- If you are using spBasic for instrument controls, you have to install some additional AddIns to interface with the instruments that you are using. Repeat the above
steps to install the addins below. - 'SpbAgilentE3600A.xla' for a Power Supply. This is in the 'C:\Program Files\spBasic\Addins\Agilent\E3600PwrSupplies\AddIn\' directory. - 'SpbInstrumentCore.xla' for general instruments. This is in the 'C:\Program Files\spBasic\Addins\Instrument\AddIn\' directory. Now close Excel (exit), then restart it again. The new instrument control
statements should now appear in the 'SPB Help' menu selection under the
'Group' dropdown menu box. Then go to Additional Instrument Control
Software below. Besides intalling the addins listed above, you have to install a PC interface communication package called VISA COM. This is a standard interface for the computer's communication
connections, such as GPIB, RS-232, USB, etc. This is required for spBasic to communicate with your instrument If you are already communicating to your instruments through the PC, you may already have VISA COM installed. Check for a C:\VXIPNP\VisaCom directory. This directory should include a 'GlobMgr.dll' and a 'BasFrmIO.dll' file. If these files are there, VISA COM is probably installed. If VISA COM is not installed, you can install it as follows, - NI VISA COM - If you are using National Instruments software, you need to update the NI VISA software to Version 3.0 or later to operate with VISA COM. You can download the NI VISA software from http://www.ni.com/visa/. You may have to register with NI if you're not already registered. Select the 'Downloads' link, then 'NI-VISA', then 'Windows'.From there, select the latest version compatable with your version of Windows. Save the file to a download directory, unzip it to the same directory, then doubleclick on the 'setup.exe' file. After installation, check to see if the C:\VXIpnp\VisaCom directory exists. If it does, VISA COM is installed, but you may have to manually register the 'C:\VXIpnp\VisaCom\BasFrmIO.dll' file if it exists in this directory. Do this by clicking 'Start -> Run', then enter 'regsvr32 C:\VXIpnp\VisaCom\BasFrmIO.dll' and press OK. The message 'DllRegisterServer in C:\VXIpnp\VisaCom\BasFrmIO.dll succeeded' should be displayed. - Agilent VISA COM can be downloaded and installed from
the Agilent website http://adn.tm.agilent.com
(if the Agilent web site above has changed, seach for 'agilent visa com
library' using your search engine) This version of VISA may be required
for Agilent instruments, and can also be installed along with the NI version.
Select 'SoftwareDownloads ->Software: IOLibraries Suite'. Select 'IO
Libraries Suite x.x Product Download' and click the 'download' link under
'Download the IO Libraries Suite Software'. You may have to register with
Agilent if you're not already registered. Save the file to a download
directory, double-click on the downloaded file and follow the instructions.
Select the 'Typical' install option and continue. Launch the 'Connection
Expert' to show the interface connections on your computer. |
Live Excel Help! Free initial talk time, no charge until you're convinced that the expert can help you! |
Search for Expert Advice! |
Ask an Expert a Question! |
Copyright © 2007, Reportdata.com, LLC Contact Us