View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DORI
 
Posts: n/a
Default Converting Excel worksheet to JPEG, PDF or TIFF pressing a cell/bu

I have several spreedsheets that users enter some data and then the results
appear on 'Report'!A1:N28 spreedsheet. Is it possible to click on (let say)
an
actionbutton on the "Report" sheet to automatically save the cells A1:N28 as
JPEG or PDF or TIFF formats in a folder called "OB Reports"? I also have some
"objects" and "check boxes" located on top of cells A1:N28.
I understand that the VBA is the way to do it but I am new to VBA. Could any
of those genii out there help me with some simple instructions how to do this?
Thank you so much in advance.
Dori