First, my apologies for the long question. I’m a bit frustrated.
The Environment: TOAD for SQL Server via an RDP server. Scripts work great and the scheduler runs like a top.
The Issue: I currently have several reports that run via the scheduler. Once they run I still have to come in and format them. I looked through the tutorials and found the one that describes the use of .xlsm macros so I tried that one. Worked well. Had a few ‘logistical’ issues. First, the template has to be in the folder where you export it to. The second issue is that you can’t rename the file (all you can do is append the date/time to it). This is a bad resolution for me. First I ‘stage’ these files for analasys before I upload them to a SharePoint. Second, the RDP Server doesn’t allow access to the network file I stage them at (just the local share I have on the RDP server) which makes it impossible for my backup to get to. Third, the files need to be saved under a different name than the macro template.
What I’d like to do: Have the report run. Have the file formatted. Then save the finished file to the network share that my team has access to.
Yes - it currently will send the file to the network share. xp_exec has been disabled.