Help. I have a linked OLE .xls in my report. I'm need to change the .xls the link points to at run time dependent on who the user is. In my VB code:
objOLE.SetOleLocation App.Path & "/TimToDo.xls"
objOLE is a OLE Object in the report.
I keep getting a "Permission Denied" msg. (the .xls & report are not open any place else).
I posted this before but got no responses. Since then, I found out this is a known bug. However, the workaround says to use the SetOleLocation in the section_format routine, but how do I do that at run time from a VB app? Code, anyone? (getting very Desperate!!!!)
objOLE.SetOleLocation App.Path & "/TimToDo.xls"
objOLE is a OLE Object in the report.
I keep getting a "Permission Denied" msg. (the .xls & report are not open any place else).
I posted this before but got no responses. Since then, I found out this is a known bug. However, the workaround says to use the SetOleLocation in the section_format routine, but how do I do that at run time from a VB app? Code, anyone? (getting very Desperate!!!!)