How to paste data from a data entry web page form ??

KLund1

Board Regular
Joined
Oct 27, 2005
Messages
64
I have a need to use data that is entered into boxes on a web page form.
If I copy and paste the web page form to a blank Excel 2000 sheet, I can see the data. I can click on a cells of data. But if I move off the data area to an empty part of the sheet and move the cursor with the arrow keys, the cursor move under the data. I can not make a simple formula to add the data. It is like when you put a picture, or chart in Excel, the cursor move under it. I have also tried Data/Import External data/New Web Quary/then several combinations of radio buttons I do not fully understand. But either get nothing of the same thing as a regular paste.
I really wish I could attache the sheet so you can see what I see.
I hope I was clear.
Suggestions?
Thanks!
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
To share a workbook, upload it to a hosting site like Drop Box and paste a link here.
Can I have access to the web page for testing purposes?
 
Upvote 0
Your table is made up of lots of individual objects. Try the code below to convert it into a regular table.

Code:
Sub KLund()
Dim o
For Each o In ActiveSheet.OLEObjects
    If o.progID Like "Forms.HTML:Text*" Then
        o.TopLeftCell.MergeArea.Value = o.Object.Value
        o.Delete
    End If
Next
End Sub
 
Upvote 0
Worf That is perfect !!!!!!!!!!
Just what I needed. You really know your Excel !!!
Many many thanks!!!!
KL
 
Upvote 0

Forum statistics

Threads
1,212,929
Messages
6,110,743
Members
448,295
Latest member
Uzair Tahir Khan

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