I know this is probably old and dealt with, but I also found this bit of code that might be relavent to opening files that you have created in VBA, through exporting to txt or csv, etc. It allows you to not only open the output file, but it doesn't require you to use the corresponding application type (ie notepad.exe, Adobe.exe, etc) This code will allow Windows to open the file with the default application that handles that specific extension.

[VBA]Shell "cmd.exe /c Start ""Window title"" ""path to file\file.ext""", vbHide
'Double quotes to pass as a single quote, in case of spaces... [/VBA]