+ Reply to Thread
Results 1 to 5 of 5

Copy from Excel and Paste into Web Form - Need Help

  1. #1
    Registered User
    Join Date
    11-11-2014
    Location
    Tennessee, USA
    MS-Off Ver
    2010
    Posts
    2

    Copy from Excel and Paste into Web Form - Need Help

    Hello all!

    After considerable time spent searching online trying to find a solution to my problem I've decided to try posting here in hopes that a solution is possible. I feel like what I need should have a simple solution, but I've run out of energy trying to find someone with a similar scenario and solution. I'm hoping that someone here is kind enough to offer some help. Enough of my ranting, here's the problem:

    I have a Workbook I've made whose cells correspond with blanks I need filled in a Web Form. What I'd like is to automate copy/pasting the values in those cells to the 50 or so blanks in the Form. Copy, alt+tab, paste, tab, alt+tab, down, down, copy, alt+tab, paste, tab, alt+tab, right, up, up, repeat until the Form is filled out (with a variation here and there). Seems simple enough to me, but I've yet to find a way to accomplish the task. I tried recording a Macro to do it, but it didn't register the alt+tab as part of the process and failed. Bummer. Is it possible to do with with Excel/VBA? Any help would be /greatly/ appreciated.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy from Excel and Paste into Web Form - Need Help

    Hello whoa_its_sam,

    To help you with this problem you will need to post a copy of the workbook and the URL of the website.

    If the website requires you to login then you will need to copy the page source of the web page to be filled in and attach it to your post.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    11-11-2014
    Location
    Tennessee, USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Copy from Excel and Paste into Web Form - Need Help

    I see. I was hoping to avoid having to do that since the information is work related and can't be shared outside of work. As an alternative, would you be able to offer any direction on the kind of action required for something like this to be accomplished? Thanks again.
    -Sam

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy from Excel and Paste into Web Form - Need Help

    Hello Sam,

    Contact your IT department for help on this. If IT can not help you then maybe someone you work with knows about programming Internet Explorer and HTML programming.

  5. #5
    Registered User
    Join Date
    11-06-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    Re: Copy from Excel and Paste into Web Form - Need Help

    Hello sam,

    Is it possible to share the HTML code of the web page. so that i can help you to do this. I tried last time the same kind of sceanrio and it works fine.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy/Paste form another excel workbook overrides data validation.
    By adibakhan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 01:09 AM
  2. Macro to copy from Excel and paste into a form on IE or Firefox?
    By bshape1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2014, 07:51 PM
  3. Excel form copy and paste multiple cells
    By probio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 03:29 AM
  4. Excel vba to copy from Adobe smart form and paste into Word
    By Alice Miriam Begley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2012, 10:36 AM
  5. Replies: 1
    Last Post: 01-04-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1