Export Each Excel Row as Separate JPG Files

[mehidy1437]

It seems very old post, but my requirement exactly is same, I just want the output in image format like as jpg.
when I open the jpg file the output file has nothing in it.

Can someone help on this?

Please Login or Register  to view this content.

[saravnepali]

This code will convert the selected range to image

[bakerman2]

@saravnepali

Your Filename has invalid characters so your code goes into debug upon Save.

[mehidy1437]

This code will convert the selected range to image

Thanks for your response, but I'm not looking for this.

[saravnepali]

What do you want, isn't it you need output as a JPG file ?????

[mehidy1437]

I want each row to be a separate image with the header row/1st row.
Also out put should be in a folder, not in the same xl sheet.

[saravnepali]

Which folder - this can be just simply changed on the same code.

[bakerman2]

Post an example file with your exact layout.

[saravnepali]

Check this

Change the folder name to suit

[saravnepali]

@saravnepali

Your Filename has invalid characters so your code goes into debug upon Save.

bakerman,

Tried to copy the VBA code to notepad and then paste the code in the browser.

Still shows the error

[mehidy1437]

Check this

Change the folder name to suit

Thanks, its nice now.
Is it possible to add the 1st row header with each row?
Like as
1st row+2nd row one image,
1st row+3rd row is another image & go on..

[saravnepali]

See attached variation

I have hidden the unwanted rows

Please note that if you have large number of rows, it might slow the system down.

[bakerman2]

My 2 cents.

Just change fPATHout to the correct foldername.

Please Login or Register  to view this content.

[mehidy1437]

My 2 cents.

Just change fPATHout to the correct foldername.

Please Login or Register  to view this content.

Need to adjust image size as per the column & row height.
Present output is as below.

Attachment 652769

[bakerman2]

Invalid attachment.

Also please don't quote when answering to a post directly above. It's just clutter.

[Rick Rothstein]

Cross posted here...

https://www.mrexcel.com/board/thread...2#post-5380411

where I provided a working solution but the OP outlined a problem in Message #16 (at that other forum) which I am not sure he has delineated here.



I am not sure if this duplicates anything posted here so far, but for the record, here is the solution I provided in that other forum...

Please Login or Register  to view this content.

[mehidy1437]

@Rick Rothstein

Hello dear, hope your are fine.

If you noticed the first /beginning post of the thread, then you would not make this comments, you should realized that I have made a comments in another thread (very old) & from there this thread has been started. I didn't make this thread myself, it created automatically or by the system--> "Last edited by JBeaucaire; 12-01-2019 at 03:18 PM." see this point.

After making the comments in that old thread, I haven't got any reply & then I post in MrXL & got your help, I appreciate that time & even I do now.
But question is , why I continue this thread when I have your solution, right?

Its because, I have given you my feedback on your code that when I run your code , its always missing some row. So I thought let, see if I got another solution to avoid this problem here, as it has been going on.

Hope its clear enough.

Lastly, thanks again.