Using String Variablein Report Object Reference

  • Thread starter Thread starter Alan Z. Scharf
  • Start date Start date
A

Alan Z. Scharf

I wnat to use a string variable, strReportName, in the reference below
instead of the hardcoded current actual report name of 'rptGraph'.


Reports!rptGraphs![PerfGraph].Object.Application.Chart.Axes(1).TickLabelSpac
ing = 2

Can someone give an example of the syntax for that?

Thanks.

Alan
 
Perhaps the following option will work for you.

Reports("rptGraphs")!PerfGraph.Object.Application.Chart.Axes(1).TickLabelSpac
 
John,

Thanks very much.

That may well work with a string variable in first paren.

I wasn't aware of that alternative format.

Regards,

Alan


John Spencer said:
Perhaps the following option will work for you.

Reports("rptGraphs")!PerfGraph.Object.Application.Chart.Axes(1).TickLabelSpa
c


Alan Z. Scharf said:
I wnat to use a string variable, strReportName, in the reference below
instead of the hardcoded current actual report name of 'rptGraph'.


Reports!rptGraphs![PerfGraph].Object.Application.Chart.Axes(1).TickLabelSpac
ing = 2

Can someone give an example of the syntax for that?

Thanks.

Alan
Click to expand...
Click to expand...
 
Back
Top