How to set the voltage on a power supply? (vba/excel program

Guest
I'm trying to make a user interface for the power supply..

Would anyone know how to set the voltage on an Agilent Power supply for
a GPIB system? I know you can use POWERSUPPLY.Output "APPLy 5.00,
0.01" but I want to use a variable such that the user can select a
value in excel and then it will apply in the power supply.. as
Voltagexyz and have it as: POWERSUPPLY.Output "APPLy Voltagexyz, 0.01"
but it only accepts integers.. any suggestions?
 
Hello,

I know nothing about your function but what about something like this:

dim nVoltage as Single 'or Double

dim s as string

s = "APPLy " + Format(nVoltage,"000.00") + ", 0.01"

POWERSUPPLY.Output s

????

regards,

Henk


<v_3kaths@hotmail.com> schreef in bericht
news:1159835123.243433.310130@m7g2000cwm.googlegroups.com...
I'm trying to make a user interface for the power supply..

Would anyone know how to set the voltage on an Agilent Power supply for
a GPIB system? I know you can use POWERSUPPLY.Output "APPLy 5.00,
0.01" but I want to use a variable such that the user can select a
value in excel and then it will apply in the power supply.. as
Voltagexyz and have it as: POWERSUPPLY.Output "APPLy Voltagexyz, 0.01"
but it only accepts integers.. any suggestions?
 
Thanks Henk!!!

That is EXACTLY what I needed! You were very helpful!!


Thank you!

Henk van Winkoop wrote:
Hello,

I know nothing about your function but what about something like this:

dim nVoltage as Single 'or Double

dim s as string

s = "APPLy " + Format(nVoltage,"000.00") + ", 0.01"

POWERSUPPLY.Output s

????

regards,

Henk


v_3kaths@hotmail.com> schreef in bericht
news:1159835123.243433.310130@m7g2000cwm.googlegroups.com...
I'm trying to make a user interface for the power supply..

Would anyone know how to set the voltage on an Agilent Power supply for
a GPIB system? I know you can use POWERSUPPLY.Output "APPLy 5.00,
0.01" but I want to use a variable such that the user can select a
value in excel and then it will apply in the power supply.. as
Voltagexyz and have it as: POWERSUPPLY.Output "APPLy Voltagexyz, 0.01"
but it only accepts integers.. any suggestions?
 

Welcome to EDABoard.com

Sponsor

Back
Top