Export each row as separate image of a selected range in VBA

[mehidy1437]

Hi Guys,
I want to export each row of my selection range as separate image in VBA.
Image name will be from the first column data.
Like as, S1001.jpg, S1002.jpg & go on.

Is it possible?
If yes, give me some idea with the code.

 

[jkpieterse]

See this file which uses a combination of a chart with embedded on the chart a picture which points to a dynamic range name. The macro just changes the number in cell F1 and exports the chart: ExportRangePicsUsingChart.xlsm

 

[mehidy1437]

When I open the file , f1 contain 1 by default.
When I run the module f1 value changes to 10 & nothing else happen.

More over I want to export all images in a folder like "images" at my desktop.
Please advise.

 

[jkpieterse]

The images are saved in your current folder, which is probably your documents folder. I assumed you woule be able to change the code so it uses the folder you want.

 

[mehidy1437]

You are right, images save in documents folder.
But the images are blank without any data in it.

 

[jkpieterse]

Apologies, please download the file again, it should now work (it does for me)

 

[mehidy1437]

Sorry dear, its still not working.
Also I didn't find any changes between the current file & earlier file.
Could you please recheck?

 

[jkpieterse]

How extremely annoying. If I set things up as they should be all is well. If I then save and close and reopen, Excel has wrecked the workbook in question. I give up.

 

[jkpieterse]

I've sent a bug report to MSFT about this.

 

[mehidy1437]

No problem, thanks for your help.
Hope someone else will come up with a solution.