Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Download Excel file via RDP

  • 20-09-2011 05:30PM
    #1
    Seth Brundle
    Moderators, Politics Moderators, Paid Member Posts: 44,138 Mod ✭✭✭✭


    I planning on moving an MS Access application that creates Excel reports onto a Blacknight VPS.
    This VPS can be accessed via remote desktop which will be fine for viewing the MS Access app but I would like to know if it is possible to download the excel reports somehow (for non-tech users).
    I could do one of the following:
    * save the reports to the wwwroot folder and get the users to copy the url into their browser
    * email the reports to the users
    * create an ftp shortcut to the remote server

    However, is there a simpler method that will "force" the file to save or open onto the users PC?

    Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/ .



Comments

  • #2
    Seth Brundle
    Moderators, Politics Moderators, Paid Member Posts: 44,138 Mod ✭✭✭✭Seth Brundle


    I think I've just found the solution.
    It's possible to allow access to the local PC when connecting.
    Have to figure out some way of finding the C drive on the local pc within my code but hopefully all would be ok then.

    Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/ .



  • #3
    Fysh
    Moderators, Arts Moderators, Regional Abroad Moderators, Paid Member Posts: 11,203 Mod ✭✭✭✭Fysh


    Your best bet might be to set a login script to run for the relevant users which creates a directory on their local machine and copies the reports there. That or put a batch file on their desktop that they can run manually to copy the files over.


Advertisement