Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SetOLELocation gets Permission Denied

Status
Not open for further replies.
TimLarkin

TimLarkin

Programmer
Mar 8, 2001
159
US
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).

Ideas?
 
Status
Not open for further replies.

Similar threads

awaria
  • Locked
  • Question
Do not have permission to delete published report
Replies
4
Views
134
Madawc
Madawc
KarenBo
  • Locked
  • Question
Wide Cross-tab in subreport gets truncated in pdf export
Replies
0
Views
90
KarenBo
KarenBo
dellguy
  • Locked
  • Question
CRS XI subreport triggered by drilldown gets login error in Infoview
Replies
0
Views
46
dellguy
dellguy
beckybear3
  • Locked
  • Question
Error 20544 Access Denied with Crystal ActiveX control in VB6
Replies
0
Views
72
beckybear3
beckybear3
CRilliterate
  • Locked
  • Question
Blank field gets omitted 1
Replies
2
Views
55
CRilliterate
CRilliterate

Part and Inventory Search

Sponsor

Back
Top