Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Download Excel file via RDP

  • 20-09-2011 05:30PM
    #1
    Seth Brundle
    Moderators, Politics Moderators Posts: 43,057 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?


Comments

  • #2
    Seth Brundle
    Moderators, Politics Moderators Posts: 43,057 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.


  • #3
    Fysh
    Moderators, Arts Moderators, Regional Abroad Moderators Posts: 11,172 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