Reflections Inputbox

Robertson1995

Board Regular
Joined
Apr 1, 2009
Messages
123
I am using VBA in a program call Reflections WRQ. This is a program I use to telnet into a piece of equipment at work.

In the example code below the site command is entered using an Inputbox, but I need a way to be able to enter the site # only once instead of having an Inputbox pop up every time. The site # never changes. Does anyone know of a way to do this?



Sub test ()

site = Inputbox("enter site #")

session.transmit "site" & chr$(rcCR)
session.transmit "111" & chr$(rcCR)
session.transmit "site" & chr$(rcCR)

end sub
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You may have figured this out, but just in case some one else need the information:

try placing the line with the input box outside of the sub routine

---------------------------------------------------
site = Inputbox("enter site #")

Sub test ()

session.transmit "site" & chr$(rcCR)
session.transmit "111" & chr$(rcCR)
session.transmit "site" & chr$(rcCR)

end sub
---------------------------------------------------
 
Upvote 0

Forum statistics

Threads
1,225,611
Messages
6,185,996
Members
453,334
Latest member
Prakash Jha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top