As shown in figure how to use VBA to this column cell in each row a batch is saved as a JPG images

CodePudding user response:

Excel VBA is equivalent to your computer automatically at ordinary times the content of the manual operation into a complete way,
Archived into image formats, Excel itself did not bring this functionality,
If you want to achieve only himself drew, use a picturebox,
Draw a rattle his cell, and then write the content of cells,
Keep the picturebox into JPG again

CodePudding user response:

Actually, do you find, you choose in excel grid CTRL + c, and then to QQ or WeChat CTRL + v to get the result is that a picture?
Try to walk from the train of thought, the use of the clipboard object and picture processing, perhaps moments,

CodePudding user response:

For Excel VBA (export the cell contents as the picture) is a common and practical function,