The event names are slightly different for VT terminals.
Reflection VBA macro code is stored in Reflection settings files (.rd3x, .rd5x, .rdox), along with other necessary configuration details for each host session.
You can directly import the CSV with the Data connection feature, but it is going to want to pull the data in and add it to a Worksheet.
In fact there are many such dialogs, I counted 258 - how useful are these for your Excel programs? The full list can be found under Xl Built In Dialog Enumeration at msdn.microsoft.com/library/office.
My conclusion after examining them is that only half a dozen or so are worth the trouble. Some dialogs have arguments that can be used to preset values on the dialogs: Built-In Dialog Box Argument Lists. Show(Arg1:=str Filename, Arg2:=byt Update Links, Arg3:=boo Read Only, Arg4:=xlf File Format, _ Arg5:=str Password, Arg6:=str Write Reservation Password, Arg7:=boo Ignore Read Only Recommendation, _ Arg8:=int File Origin, Arg9:=str Custom Delimiter, Arg10:=boo Add, Arg11:=boo Editable, Arg12:=int File Access, _ Arg13:=boo Notify, Arg14:=int Converter) Whether to recommend to the user that the file be opened in read-only mode.
PS Look at the list of drivers in Data See below animated gif for preview: Power Query is not available for Mac OS; nor is the Excel "From Text" open file dialog on Mac OS accepting a URL (at least at version 15.33).
To create such a connection one would first have to construct a web query file (.iqy), as explained in this guide, and then import it with the "Data -Sub Macro1() ' ' Macro1 Macro ' ' With Active Sheet. Add(Connection:= _ "TEXT;\\Path\To\CSV\Folder\CSV_Data.csv" _ , Destination:=Range("$A$1")) .
Code can be added to the Create a new settings file (.rd3x, .rd5x, .rdox) for distribution to end users that will include the VBA Extensibility code necessary to dynamically import this remotely located macro code.
Open the Visual Basic Editor, click Tools The example shows how to dynamically import a single standard module into a VBA project, however, it is also possible to import user forms and VBA classes as well.Easiest way of doing it is to import the Data into Access or SQL Express, and then use the Data Connection features and functions in Excel. After the initial setup, all you would have to do is click Refresh All and it will pull the the data and recalculate the values. Using the Data Connection feature you can disable the filename prompt (there's a checkbox at the end of the wizard). At that point you can also set it to auto-refresh every X minutes. The question is "How do I reference data in an file? My way would be to cut out the file and use a Macro containing VBA and ADO that receives the data and puts it directly into a worksheet in Excel. Excel 2010 has Data Get External Data - from various data sources.