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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Submit a macro using BCA

Status
Not open for further replies.
legend8

legend8

MIS
Jan 30, 2001
36
CA
Hi there,
I've created a macro in a report and perform the following:
- Refresh the dataprovider
- use 'Call ConvertTo' function to export the data to Excel and then save it to a local directory in the reporting server (eg. c:\rptxls\mydata.xls).
I submitted the above report thru Broadcast Agent and it ran sucessfully but the file is not created in the directory

Please help.

Legend8
 
Sort by date Sort by votes
I think I got that fixed. I forgot to set the permission to 'Full Control'.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Vik12
  • Locked
  • Question
Edit conditions in data provider using VBA
Replies
0
Views
156
Vik12
Vik12
RB3
  • Locked
  • Question
Searching for Fields With a Question Mark Character Contained Within Any Position Using WildCard
Replies
0
Views
67
RB3
RB3
PWD
  • Locked
  • Question
Sub-Sections Within A Report
Replies
1
Views
76
PWD
PWD
pgmr777
  • Locked
  • Question
Import a 4.0 biar into 4.1
Replies
2
Views
108
hilfy
hilfy
PWD
  • Locked
  • Question
Detail Variable Syntax - If A = "n" And B = "z" "True" 1
Replies
3
Views
104
PWD
PWD

Part and Inventory Search

Sponsor

Back
Top