+ Reply to Thread
Results 1 to 4 of 4

Type from excel to webpage.

  1. #1
    Registered User
    Join Date
    07-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Type from excel to webpage.

    Hi

    I want to know how to create a macro so that data from excel is typed into a particular web page. I have a specific web page where i want all the fields to be typed from an excel sheet. Is there any way I can create a macro for the same in excel and have it pasted in the webpage ??

  2. #2
    Registered User
    Join Date
    06-18-2015
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    13

    Re: Type from excel to webpage.

    Hello,

    please try this. Change the website and the field values and names/ids.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Re: Type from excel to webpage.

    I am unable to get the threads in place. Have attached the excel sheet and the the web page in an attachment that i want to link via macro so that the data is copied over from the excel to the webpage. Rather I want it to be appearing as it is being typed. Please help......
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-18-2015
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    13

    Cool Re: Type from excel to webpage.

    Hello again,

    excuse me I was busy yesterday.
    I created a macro that auto fills the fields. I had no time so the code is incomplete. You have to copy/paste the code for all the fields of the five pages. You will find the ids from page source.
    The logic is in the Class1 file. Then hit start and a browser will open.

    Please tell me if this is what you need. If you have any questions, feel free to ask me.

    See the attached file.

    Demo Excel Sheet.xlsm
    Last edited by theoxskyl; 07-07-2015 at 03:11 AM.

+ 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. Vba code for using webpage ( Tracking Goods c/ment on webpage)
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2013, 06:03 AM
  2. [SOLVED] Load webpage on TOPMAN website, extract prices from webpage into Spreadsheet
    By AKK9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 11:49 AM
  3. Macro to Open webpage, then save webpage as txt file.
    By jasocke2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2012, 04:25 AM
  4. [SOLVED] Excel will not let me type any characters....I can type in Word.
    By deholly in forum Excel General
    Replies: 1
    Last Post: 03-17-2006, 06:40 AM
  5. [SOLVED] Excel will not let me type any characters....I can type in Word.
    By deholly in forum Excel General
    Replies: 0
    Last Post: 03-17-2006, 06:25 AM

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