Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a button which runs a small script using ExportBitmapToFile to create jpg image of a chart using the following:
ActiveDocument.GetSheetObject("CH64").ExportBitmapToFile <filename.jpg>
This works perfectly if the chart is on the same sheet as the button.
However, I would like the button to be on a different sheet to the relevant chart.
Can anyone tell me what the command should be ?
Thanks
Richard
Hi,
You can get all sheetid from the below code. so you can mention get desired sheetid.
sub LoopSheet
for i = 0 to ActiveDocument.NoOfSheets - 1
set ss= ActiveDocument.GetSheet(i)
msgbox(ss.GetProperties.SheetId)
next
end sub
Hope its help,
Regards,