When I copy a HTML table which includes a picture on each row and paste it into Excel the picture changes to an Autoshape.
I'm not sure why but the Autoshapes are not visible. I would like to format the shape as a picture.
Your suggestions are appreciated.
Picture vs Autoshape
-
- GoldLounger
- Posts: 2574
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Picture vs Autoshape
Regards,
John
John
-
- Administrator
- Posts: 76686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Picture vs Autoshape
Do you have an example table that we can use to test (for example in the form of a link)?
Regards,
Hans
Hans
-
- GoldLounger
- Posts: 2574
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: Picture vs Autoshape
Hans,
The challenge was opening the HTML file from a compressed file (RAR). Once I extracted the files from the RAR file I was able to copy the table contents, paste into Excel without the pictures converting to an auto shape.
The challenge was opening the HTML file from a compressed file (RAR). Once I extracted the files from the RAR file I was able to copy the table contents, paste into Excel without the pictures converting to an auto shape.
Regards,
John
John
-
- Administrator
- Posts: 76686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands