How to import the data window display of pictures to EXCEL

CodePudding user response:

Use OLE
After image saved as first picture file
Add to EXCEL
EXCEL VBA syntax
Excel_ole. Application. ActiveSheet. Shapes. AddPicture (Filename, LinkToFile SaveWithDocument, Left, Top, Width, Height)

CodePudding user response:

By PB itself is not achieve the saveas, with ole connected to excel, and then put in the picture is copied to the clipboard, and then paste in the excel, all can use the code to implement (with Vba in excel to do this, if not clear, can be manually recording a macro, look at the code, and then imitate the in PB).