Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
better way to copy data from an embedded html box
i have some fields from a browser window pasted into excel. the become
shapes when pasted into excel. i give the shapes names starting with box 1 to box ?, depending on what's been pasted into excel. when one shape is selected, it shows the following the the formula bar: embed("forms.html:text.1",""). right now i have some code that will copy the data from the field: With ws.Shapes("Box " & i) Selection.Verb Verb:=xlPrimary SendKeys "^A", True SendKeys "^C", True end with this worked fine until my client got a new pc. i run windows 7 and don't have an issue, but they have an acer. it also resets the keyboard indicators so i'm wondering if there is a better way to get the text from the shape? -- Gary Keramidas Excel 2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tough one - image and embedded html document | Excel Programming | |||
Copy embedded chart with updated data request | Excel Programming | |||
Copy data from an HTML file and paste into excel using a macro | Excel Programming | |||
Delete embedded HTML | Excel Discussion (Misc queries) | |||
copy html data to spreadsheet | Excel Programming |