How to open windows explorer with VBA in W10

1

Good morning everyone,

First of all, I am new to Stackoverflow and, although I have been investigating different threads, I have not been able to find a solution. To put a little bit in situation, I am developing an application from the Movicon software of Progea (development of SCADAs) for my company in Windows 10.

THE QUESTION : The issue is that in one of the synoptics, I have a 'Browse' button to execute a VBA script that should open a windows explorer and extract the path of a file. txt that I select. Could you tell me what method (a small example I will also thank you to death) could you use, please?

As an additional info, I have already tried the following methods:

  • Application.FileDialog: this opens a browser but I understand that it is designed to work from an Office script, since it opens Access when the script is executed.

  • MSComDlg.CommonDialog: although after adding the library of 'MSComDlg', I did not find the extension 'CommonDialog' ... apparently, the 'CommonDialog' is not available in W10.

  • Shell.Application: there was no way to automatically detect anything after writing 'Shell.' so I understand that I do not have it available for whatever reason. Comment that I have included the library strip to my script.

Anyway, I hope that some of you can throw a cable with this asuntillo and apologize if I said some barbarity but I take very little in this programming.

Greetings ] 1

    
asked by Ruben 16.11.2017 в 09:48
source

0 answers