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