msoFileDialogOpen

Opening A File With MS Office Object Library

For this one you will need to add a reference to the “MS office object library” Then you can write something like this: 1234567891011121314151617181920212223242526272829303132Sub OpenFile()    strFileName = GetFile(strStart, "Select Your File")    ‘open your file, import it, or here we are just displaying the name    Msgbox strFileName End Sub Private Function GetFile(start_here, title_bar […]

Continue Reading

How To Do A VBA CSV Import For One To Multiple Files

So you want to be able to import your csv for 1 to multiple files. Here’s how you do it. 1. up a form with a button. 2. After you click the button, you will get a File Dialog Box that will show you the csv files to choose from: Here is the code behind […]

Continue Reading