How can Excel VBA open file using default application

by

This works for me in Excel & Word

Sub runit()
   Dim Shex As Object
   Set Shex = CreateObject("Shell.Application")
   tgtfile = "C:\Nax\dud.txt"
   Shex.Open (tgtfile)
End Sub

or … as per Expenzor’s comment below

CreateObject("Shell.Application").Open("C:\Nax\dud.txt")

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. How to error handle 1004 Error with WorksheetFunction.VLookup?
  3. Create a new sheet for each unique agent and move all data to each sheet
  4. Set Auto Filtering multiple wildcards
  5. How to make Excel VBA variables available to multiple macros?
  6. Use of symbol # (hash) in VBA Macro
  7. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  8. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  9. Excel VBA looping through multiple worksheets
  10. When one should use Set [e.g for SpecialCells return value]?
  11. Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
  12. Is there a faster CountIF
  13. Excel VBA How to detect if something was pasted in a Worksheet
  14. Getting error Procedure too large in VBA Macros (Excel)
  15. How to add data validation to a cell using VBA
  16. How to do late binding in VBA?
  17. How to break long string to multiple lines
  18. How to copy a chart from Excel to PowerPoint?
  19. Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
  20. vba paste not working
  21. Return a range from A1 to the true last used cell
  22. mac excel vba loop : from list & then export as pdf
  23. Can Advanced Filter criteria be in the VBA rather than a range?
  24. In Excel VBA, what is the way to check if the web page is fully loaded?
  25. Excel Useform: How to hide application but have icon in the taskbar
  26. Reading Web Pages using Excel VBA
  27. Excel VBA: auto click and open file from website
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment