mickyflash
Board Regular
- Joined
- Jan 29, 2009
- Messages
- 77
Hello Guys
I currently update 10 spreadsheets weekly, within each there are 5 worksheets that I convert into pictures, - (There are more than 5 worksheets within each spreadsheet, but I only generate pictures for 5)
I currently do this copying a range and pasting into (currently) to IrfanView, saving the image with the same name as the worksheet and moving on to next..
This method is becoming very tedious as I generate 50 pics a week, which ultimately get uploaded to my pro-boards forum. The following week the process starts again as the old pictures are now out of date
is there a way automating any or all of this procedure with VBA/Macro?
The only alternative that I can think of is to uploading the whole spreadsheet to a host and embedded it into my forum, but this has been very unsuccessful as the worksheets are all linked to each other and have lots of hidden columns etc
Thanks in advance
Mick
I currently update 10 spreadsheets weekly, within each there are 5 worksheets that I convert into pictures, - (There are more than 5 worksheets within each spreadsheet, but I only generate pictures for 5)
I currently do this copying a range and pasting into (currently) to IrfanView, saving the image with the same name as the worksheet and moving on to next..
This method is becoming very tedious as I generate 50 pics a week, which ultimately get uploaded to my pro-boards forum. The following week the process starts again as the old pictures are now out of date
is there a way automating any or all of this procedure with VBA/Macro?
The only alternative that I can think of is to uploading the whole spreadsheet to a host and embedded it into my forum, but this has been very unsuccessful as the worksheets are all linked to each other and have lots of hidden columns etc
Thanks in advance
Mick