VBA: SaveFileDialog and copy file

6 Posts
3 Users
0 Likes
29 Views
(@j.becker@pcvue.de)
Posts: 0
New Member Guest
 

Hello guys,

after running an export (data export), I would like to save the export to another place. In fact, the access is over RDP, so I would like to save the export-files to the host-where I am running the rdp-session.

I was thinking about VBA and an SaveFileDialog and then copy the files to the choosen place.

I don´t know, what references to add. Does anybody have an idea?

 
Posted : 05/08/2015 1:38 pm
n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

you can open the savefiledialog using the windows API
Example here: http://access.mvps.org/access/api/api0001.htm

Nico

 
Posted : 05/08/2015 2:28 pm
(@admin_doc72)
Posts: 493
Member Admin
 

Regarding the question of how to transfer files between a remote desktop session and the host system you could maybe help yourself by using a Windows Powershell script:

http://stackoverflow.com/a/13879551/4712825

 
Posted : 06/08/2015 11:35 am
(@j.becker@pcvue.de)
Posts: 0
New Member Guest
 

Thank you guys,

the solution will be probably a Web Portal for WebVue (referencing the folders and files to virtual directories) and the clipboard for RDP.

So for that I have another question:

Do you think it is possible to open the explorer in a defined place (over PcVue animation e.g. U:/Share/exports/)and lock the user in that folder. So the user can can only navigate through the sub-folders and back.
In the same time if the user opens again the explorer from another place in PcVue (e.g. U:/Share/documents/Trafo01/) the user should be locked now in the new place and should have only have the possibility to navigate through the sub-folders and back.

😉 😉 😉 😉

:silly:

Hope it was understandable enough.

Thank you in advance

 
Posted : 07/08/2015 5:38 pm
n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

I think the only way is to use the Windows user rights...

 
Posted : 10/08/2015 4:30 pm
(@admin_doc72)
Posts: 493
Member Admin
 

Do you think it is possible to open the explorer in a defined place (over PcVue animation e.g. U:/Share/exports/)and lock the user in that folder.

Is there a Windows equivalent to chroot?

 
Posted : 10/08/2015 5:46 pm