Excel VBA macro which run SQL to CSV file and to Excel file. With this excel macro, you can run SQL to any text file (need to be either csv or tsv format), and get the result to the excel sheet or can ...

Background Video: Creating a Morningstar Portfolio Use the Morningstar Export feature (see screen shot above) to export the custom portfolio view to Excel. Run the makeOFX_file macro in Excel. It will ...

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...