Macro to Export from Excel to .jpg

[davo3286]

I have a Macro that works brilliantly to export from Excel to .jpg but I have 2 questions:

1. Does anyone know what I can add to allow me to chose where the .jpg file saves? At the moment it saves to my computers default location.

2. Is there a way of making the exported .jpg higher quality?

Here is the code I currently use:

Please Login or Register  to view this content.

Thanks

[xlnitwit]

This will allow you to pick a location. I think it's about as good as you'll get with this method and jpg files- if you change the type to BMP, you'd get better quality but a much larger file

Please Login or Register  to view this content.

[davo3286]

Much appreciated!... I've given it a go and it's working perfectly!