Language - Visual Basic for Applications - Revision history

Mparadis: /* Use Our Examples */

2018-07-31T18:00:23Z

Use Our Examples

← Older revision		Revision as of 18:00, 31 July 2018
Line 29:		Line 29:
	===Use Our Examples===		===Use Our Examples===

	First, ~~please~~ download and unpack the [{{SERVER}}/downloads/phidget21/examples/com/VBA.zip VBA Examples]. Here you will find an example called HelloWorld which is a simple, high-level example which will work with any Phidget device. You will also find specific, in-depth examples for some of our other devices. {{FindYourDevice}}		First, open the command prompt in administrator mode and type the following command:

			<code>
			regsvr32 "C:\Progarm Files\Phidgets\Phidget21COM.dll"
			</code>

			If you installed the Phidgets libraries in a different location, you'll have to modify the command.

			Then, download and unpack the [{{SERVER}}/downloads/phidget21/examples/com/VBA.zip VBA Examples]. Here you will find an example called HelloWorld which is a simple, high-level example which will work with any Phidget device. You will also find specific, in-depth examples for some of our other devices. {{FindYourDevice}}

	The easiest example to start with is the HelloWorld example. Find it in the unpacked examples folder:		The easiest example to start with is the HelloWorld example. Find it in the unpacked examples folder:

Mparadis at 15:46, 7 June 2017

2017-06-07T15:46:35Z

← Older revision		Revision as of 15:46, 7 June 2017
Line 11:		Line 11:
	{{APIQuickDownloads\|{{SERVER}}/documentation/COM_API_Manual.pdf .COM}}\|		{{APIQuickDownloads\|{{SERVER}}/documentation/COM_API_Manual.pdf .COM}}\|
	''Note: Example code is programmed to run in Microsoft Excel.''		''Note: Example code is programmed to run in Microsoft Excel.''
	{{ExampleQuickDownloads\|{{SERVER}}/downloads/examples/VBA.zip\|}}\|		{{ExampleQuickDownloads\|{{SERVER}}/downloads/phidget21/examples/com/VBA.zip\|}}\|
	{{WindowsQuickDownloads}}}}		{{WindowsQuickDownloads}}}}

Line 29:		Line 29:
	===Use Our Examples===		===Use Our Examples===

	First, please download and unpack the [{{SERVER}}/downloads/examples/VBA.zip VBA Examples]. Here you will find an example called HelloWorld which is a simple, high-level example which will work with any Phidget device. You will also find specific, in-depth examples for some of our other devices. {{FindYourDevice}}		First, please download and unpack the [{{SERVER}}/downloads/phidget21/examples/com/VBA.zip VBA Examples]. Here you will find an example called HelloWorld which is a simple, high-level example which will work with any Phidget device. You will also find specific, in-depth examples for some of our other devices. {{FindYourDevice}}

	The easiest example to start with is the HelloWorld example. Find it in the unpacked examples folder:		The easiest example to start with is the HelloWorld example. Find it in the unpacked examples folder:

Burley: /* Windows (2000/XP/Vista/7) */

2013-04-02T18:34:59Z

Windows (2000/XP/Vista/7)

← Older revision		Revision as of 18:34, 2 April 2013
Line 21:		Line 21:
	Support for VBA is only on [[#Windows(2000/XP/Vista/7)\|Windows 2000 / XP / Vista / 7]].		Support for VBA is only on [[#Windows(2000/XP/Vista/7)\|Windows 2000 / XP / Vista / 7]].

	==Windows (~~2000/~~XP/Vista/7)==		==Windows (XP/Vista/7/8)==

	For a description of the Phidget library files, please see the main [[OS - Windows\|Windows page]].		For a description of the Phidget library files, please see the main [[OS - Windows\|Windows page]].

Mparadis: /* Quick Downloads */

2013-02-28T16:35:07Z

Quick Downloads

← Older revision		Revision as of 16:35, 28 February 2013
Line 7:		Line 7:

	==Quick Downloads==		==Quick Downloads==

	{{QuickDownloads\|Visual Basic for Applications\|		{{QuickDownloads\|Visual Basic for Applications\|
	{{APIQuickDownloads\|{{SERVER}}/documentation/COM_API_Manual.pdf .COM}}\|		{{APIQuickDownloads\|{{SERVER}}/documentation/COM_API_Manual.pdf .COM}}\|
			''Note: Example code is programmed to run in Microsoft Excel.''
	{{ExampleQuickDownloads\|{{SERVER}}/downloads/examples/VBA.zip\|}}\|		{{ExampleQuickDownloads\|{{SERVER}}/downloads/examples/VBA.zip\|}}\|
	{{WindowsQuickDownloads}}}}		{{WindowsQuickDownloads}}}}

Cora at 20:16, 28 June 2012

2012-06-28T20:16:41Z

← Older revision		Revision as of 20:16, 28 June 2012
Line 8:		Line 8:
	==Quick Downloads==		==Quick Downloads==
	{{QuickDownloads\|Visual Basic for Applications\|		{{QuickDownloads\|Visual Basic for Applications\|
	{{APIQuickDownloads\|~~http://www.phidgets.com~~/documentation/COM_API_Manual.pdf .COM}}\|		{{APIQuickDownloads\|{{SERVER}}/documentation/COM_API_Manual.pdf .COM}}\|
	{{ExampleQuickDownloads\|~~http://www.phidgets.com~~/downloads/examples/VBA.zip\|}}\|		{{ExampleQuickDownloads\|{{SERVER}}/downloads/examples/VBA.zip\|}}\|
	{{WindowsQuickDownloads}}}}		{{WindowsQuickDownloads}}}}

Line 27:		Line 27:
	===Use Our Examples===		===Use Our Examples===

	First, please download and unpack the [~~http://www.phidgets.com~~/downloads/examples/VBA.zip VBA Examples]. Here you will find an example called HelloWorld which is a simple, high-level example which will work with any Phidget device. You will also find specific, in-depth examples for some of our other devices. {{FindYourDevice}}		First, please download and unpack the [{{SERVER}}/downloads/examples/VBA.zip VBA Examples]. Here you will find an example called HelloWorld which is a simple, high-level example which will work with any Phidget device. You will also find specific, in-depth examples for some of our other devices. {{FindYourDevice}}

	The easiest example to start with is the HelloWorld example. Find it in the unpacked examples folder:		The easiest example to start with is the HelloWorld example. Find it in the unpacked examples folder:
Line 56:		Line 56:
	</syntaxhighlight></div>		</syntaxhighlight></div>

	The object name for any type of Phidget is listed in the API manual. Each Phidget (Spatial, Temperature Sensor, Motor Controller, Interface Kit) has a different software object named similarly to its own name. If you are not sure what the software object for your device is, find your Phidget on our [~~http://www.phidgets.com~~ webpage], and then check the API documentation for it. Every type of Phidget also inherits functionality from the Phidget base class.		The object name for any type of Phidget is listed in the API manual. Each Phidget (Spatial, Temperature Sensor, Motor Controller, Interface Kit) has a different software object named similarly to its own name. If you are not sure what the software object for your device is, find your Phidget on our [{{SERVER}} webpage], and then check the API documentation for it. Every type of Phidget also inherits functionality from the Phidget base class.

	You can now play around with the examples and basic code, and when you are ready to begin writing your project you can go through our instructional section on what [[#Follow The Examples\|code is in the examples]].		You can now play around with the examples and basic code, and when you are ready to begin writing your project you can go through our instructional section on what [[#Follow The Examples\|code is in the examples]].
Line 66:		Line 66:
	Your main reference for writing VBA code will be our .COM API information, with syntax for all of our functions:		Your main reference for writing VBA code will be our .COM API information, with syntax for all of our functions:

	{{UsingAPhidgetInCodeGeneral\|both of which are available in VBA\|[~~http://www.phidgets.com~~/documentation/COM_API_Manual.pdf .COM API]}}		{{UsingAPhidgetInCodeGeneral\|both of which are available in VBA\|[{{SERVER}}/documentation/COM_API_Manual.pdf .COM API]}}

	===Code Snippets===		===Code Snippets===

Cora at 20:51, 25 May 2012

2012-05-25T20:51:41Z

← Older revision		Revision as of 20:51, 25 May 2012
Line 136:		Line 136:
	{{MoreHowTos}}		{{MoreHowTos}}

	==~~Building your Project~~==		==Common Problems and Solutions/Workarounds==
	~~Describe the different ways a project could be built using this language.~~

	~~==Common Problems and Solutions/Workarounds==~~		None at this time.
	~~Here you can put various frequent problems and our recommended solutions~~.

Cora: /* Follow The Examples */

2012-05-25T20:51:12Z

Follow The Examples

Show changes

Cora: /* Write Your Own Code */

2012-05-25T20:41:40Z

Write Your Own Code

← Older revision		Revision as of 20:41, 25 May 2012
Line 56:		Line 56:
	</syntaxhighlight></div>		</syntaxhighlight></div>

	The object name for any type of Phidget is listed in the API manual. Each Phidget (Spatial, Temperature Sensor, Motor Controller, Interface Kit) has a different software object named similarly to its own name. ~~{{FindYourDevice}}~~ Every type of Phidget also inherits functionality from the Phidget base class.		The object name for any type of Phidget is listed in the API manual. Each Phidget (Spatial, Temperature Sensor, Motor Controller, Interface Kit) has a different software object named similarly to its own name. If you are not sure what the software object for your device is, find your Phidget on our [http://www.phidgets.com webpage], and then check the API documentation for it. Every type of Phidget also inherits functionality from the Phidget base class.

	You can now play around with the examples and basic code, and when you are ready to begin writing your project you can go through our instructional section on what [[#Follow The Examples\|code is in the examples]].		You can now play around with the examples and basic code, and when you are ready to begin writing your project you can go through our instructional section on what [[#Follow The Examples\|code is in the examples]].

Cora: /* Introduction */

2012-05-25T20:40:19Z

Introduction

← Older revision		Revision as of 20:40, 25 May 2012
Line 4:		Line 4:
	==Introduction==		==Introduction==

	{{LanguageSupport\|Visual Basic for Applications\|the complete Phidget API, including events\|Accelerometer (not Spatial), Encoder, InterfaceKit, RFID, TemperatureSensor and Servo.\|Microsoft Office on Windows.\|}}		{{LanguageSupport\|Visual Basic for Applications\|the complete Phidget API, including events\|Accelerometer (not Spatial), Encoder, InterfaceKit, RFID, TemperatureSensor and Servo.\|Microsoft Office on Windows\|}}

	==Quick Downloads==		==Quick Downloads==

Cora at 20:40, 25 May 2012

2012-05-25T20:40:08Z

@@ Line 43: / Line 43: @@
 ===Write Your Own Code===
 To begin, launch Excel with a new workbook for our project. Launch the VBA editor (Tools | Macro | Visual Basic Editor) and open “ThisWorkbook” in the navigator.
 Before you can use the Phidget, you must include the library in your project.