VBScript to open a dialog to select a filepath

There is another solution I found interesting from MS TechNet less customization but gets what you wanted to achieve. This returns the full path of the selected file.

Set wShell=CreateObject("WScript.Shell")
Set oExec=wShell.Exec("mshta.exe ""about:<input type=file id=FILE><script>FILE.click();new ActiveXObject('Scripting.FileSystemObject').GetStandardStream(1).WriteLine(FILE.value);close();resizeTo(0,0);</script>""")
sFileSelected = oExec.StdOut.ReadLine
wscript.echo sFileSelected

Related Posts:

  1. What does <> mean?
  2. How to find a value in an excel column by vba code Cells.Find
  3. Check if a string contains another string
  4. Does VBA have Dictionary Structure?
  5. “Sub or Function not defined” when trying to run a VBA script in Outlook
  6. What is the function of FormulaR1C1?
  7. What exactly is the function of Application.CutCopyMode property in Excel
  8. VBA Excel – Insert row below with same format including borders and frames
  9. Deleting a file in VBA
  10. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  11. How to comment and uncomment blocks of code in the Office VBA Editor
  12. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  13. Pass arguments to Constructor in VBA
  14. How to install Date Picker form control in Excel 2016
  15. How to install Date Picker form control in Excel 2016
  16. How to fill color in a cell in VBA?
  17. Refreshing all the pivot tables in my excel workbook with a macro
  18. VBA: Run time error ’91’?
  19. Compare Dates in VBA
  20. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  21. ‘Cannot find DAO350.dll’ file error VB6
  22. Average in VBA in Excel
  23. VBA Excel “Compile error: Object Required”
  24. Choosing paper size (NOT DEFAULT sizes) in excel vba
  25. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  26. Paste Special error 1004 PasteSpecial method of Range class failed
  27. VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
  28. Cannot run the macro… the macro may not be available in this workbook
  29. How to resolve “The requested URL was rejected. Please consult with your administrator.”
  30. ActiveX component can’t create object
  31. What does the “On Error Resume Next” statement do?
  32. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  33. How to import files in python using sys.path.append?
  34. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  35. Object Required Error in excel VBA
  36. What are .NumberFormat Options In Excel VBA?
  37. Better way to find last used row
  38. VBA, if a string contains a certain letter
  39. Excel VBA Macro: User Defined Type Not Defined
  40. lists and arrays in VBA
  41. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  42. Select method of Range class failed via VBA
  43. Does VBA contain a comment block syntax?
  44. Why does “Paste Method of Worksheet class failed” occasionally occur?
  45. Anaconda / Python: Change Anaconda Prompt User Path
  46. How can I convert a VBScript to an executable (EXE) file?
  47. How to return a result from a VBA function
  48. How to clear memory to prevent “out of memory error” in excel vba?
  49. Use VBA to Clear Immediate Window?
  50. VBA: Else without If Error
  51. Recommended IDE for VBA
  52. ByRef argument type mismatch in Excel VBA
  53. Extract a part of the filepath (a directory) in Python
  54. Run Command Line & Command From VBS
  55. How to set delay in vbscript
  56. VBA: Convert Text to Number
  57. VBA Error: “Compile error: Expected End Sub”
  58. Scraping data from website using vba
  59. Error: “Could Not Find Installable ISAM”
  60. How do I debug a stand-alone VBScript script?
  61. Loop without Do error
  62. Resolving File paths – ‘File not found’ error in Eclipse
  63. Row count where data exists
  64. VBA array sort function?
  65. Test or check if sheet exists
  66. How to detect if user select cancel InputBox VBA Excel
  67. macro run-time error ‘9’: subscript out of range
  68. How to Clear Office Clipboard with VBA
  69. Why does my VBA code throw an “Invalid outside procedure” error?
  70. What is the difference between \ and \\ in file path
  71. VBScript to send email without running Outlook
  72. VBScript to send email without running Outlook
  73. Desktop: The system cannot find the specified path
  74. Excel Solver Password: what is it and where can it be acquired/bought?
  75. Using Excel VBA to run SQL query
  76. Compile error: Next without For || VBA
  77. Is there a way to crack the password on an Excel VBA Project?

Leave a Comment