INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Putstring doesnt insert next to text

Putstring doesnt insert next to text

(OP)
Hi all,

I'm kinda new to this so i'm not sure how to make this work.

So basically, I'm trying to run this report once a week for the following week, so the dates need to change to match.

After i recorded up to the part where i need to enter the command to run the report, i'm trying to make it insert date with format mmddyy after the command string ...IGF-. So i tried and insert the Putstring command below. However, instead of inserting the string after ..IGF, it inserted the dates right at the beginning, after 15C.

Can anyone help shed some light on this?

Below is the what i have.

' This section of code contains the recorded events
Sess0.Screen.Sendkeys("15C<Enter>")
Sess0.Screen.Sendkeys("<Down><Down><Down><Down><Down><Down><Down><Down>1<Enter>")
Sess0.Screen.Sendkeys("IRQ-FLO.IGF-.")
Sess0.Screen.Putstring format(date+7,"mmddyy")

System.TimeoutValue = OldSystemTimeout
End Sub

Much appreciated.

RE: Putstring doesnt insert next to text

Hi,

SendKeys is usually for commands to control screen navigation and processing commands.

If you want to put text on the screen, I'd use the PutString() method (check HELP) using the optional row & column arguments.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Putstring doesnt insert next to text

(OP)
Hi,

Thanks for your suggestions. I'm a total newbie here. The Sendkeys were entered using the 'Record macro' function.

So basically, I need the steps to be followed in order. I.e. enter 15C -> Enter -> Go down to required selection -> put 1 -> type in IRQ-FLO.IGF-. -> type in dates (mmddyy)

I recorded the steps up to the ...IGF bit but then when i added the putstring method, it enters the strings in the first step above, right next to 15C.

I think my question is somewhat similar to thread99-1656965: Today's Date macro

Could you please help?

TT.

RE: Putstring doesnt insert next to text

Notice that the example PutString, that you referenced, did have arguments: 1,2 placing that string at row 1, column 2.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close