XLCubed101

You already might know the XL3Toolbar buttons . XL3Toolbar:REFRESH              XL3Toolbar:PRINT              XL3Toolbar:SUBMITCHANGES            XL3Toolbar:SAVETOEXCELFIXED            XL3Toolbar:SAVETOEXCELLIVE            XL3Toolbar:SAVETOREPOSITORY            XL3Toolbar:PRINTSHEET            XL3Toolbar:PRINTWB              XL3Toolbar:CLOSETAB              XL3Toolbar:SAVETOEXCELFIXEDSHEET I found a (currently) undocumented one: XL3Toolbar:SAVETOPOWERPOINT It does exactly as the name suggests, it opens the save / export to PowerPoint dialog. The XL3Toolbar: are very handy if you use picture links . Till Next Time

If you have multiple reports calling a master report like this : You can XL3WebReportLink to jump to the master report. Do you know that you can use this also to see which report is calling the master report and use this info to jump back. Add the following (WEB) parameter to your master report: CallingReportName CallingReportAdress CallingReportWorksheet From your linking report create a link using XL3WebReportLink including these parameters: =XL3WebReportLink( "Master Report.xml";"<<Master Report Name>>";0; "CallingReportName";"<<Linking Report Namer>>"; "CallingReportAdress";"Linking Report.xml"; "CallingReportWorksheet";"Sheet1"; "XL3ActiveWorksheetname";"Sheet1";"closecopies";TRUE) On your master report you now can make a back link like: =XL3WebReportLink(