K
Kirk P.
I've created an unbound OLE object, and I've specified the file to link to,
which is:
\\FNPCPGO07\Home\PHLK96\Monthly Financials\PivTbl for Monthly Financials.xls
Problem is, I need to get more specific in this link. I'm pointing to the
right file, but how do I point to the Excel object called Chart 75 in a
worksheet named 'YTD Variance Graph' in the file named PivTbl for Monthly
Financials.xls? Is it even possible to do this?
which is:
\\FNPCPGO07\Home\PHLK96\Monthly Financials\PivTbl for Monthly Financials.xls
Problem is, I need to get more specific in this link. I'm pointing to the
right file, but how do I point to the Excel object called Chart 75 in a
worksheet named 'YTD Variance Graph' in the file named PivTbl for Monthly
Financials.xls? Is it even possible to do this?