I have some code to upload some files into a folder. Once I press a button , I get the file picker with a folder path already in it.
The problem is that people started to use excel 2007 and now my code is not workig because of the change in excel 2007 and up.
I found the below code for excel 2007:
Dim f As Object Set f = Application.FileDialog(3) f.AllowMultiSelect = True f.Show MsgBox "file choosen = " & f.SelectedItems.Count
How can I adjust the below to work in 2007? (I have some code that will check first the version of excel, and then depending on that, it will use one code or the other).
Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) fd.InitialFileName = "C:\Files\Current Evidence" fd.Show