×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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.

Students Click Here

Copy cell data from excel and paste into portable software application

Copy cell data from excel and paste into portable software application

Copy cell data from excel and paste into portable software application

(OP)
Hi,
I need to copy column B cells' data (Part no. - starts from B3 cell) of an excel sheet and then create new row in already running IFS portable application ( keyboard shortcut to create new row - F6) then paste copied cell value (Part no.) in newly created row by simply Ctrl+V. After that hit 'Tab' key (to put cursor in next column (Qty.) of the row in IFS app). After that switching back to excel and the copy next column cell C3 value (Qty.) and then again switch to IFS app again then simply paste (Ctrl+V) in column Qty. of the row in IFS app. At last hit F12 key to save the info. entered in row in IFS app.

This is the complete process of copy data from column B & C from excel one by one and then paste into newly created row in IFS app.

I need to repeat the above process 160 times. This means there are 160 entries in column B & C and 160 new rows to be created (by F6) in IFS app.

So, please provide me the VBScript for above task. I will be be very thankful.

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! Already a Member? Login


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