Make VBA open a browser window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frans Verhaar - 22 Jun 2006 19:54 GMT

Hi,

I have this code in VBA that calls a query table from a certain csv file.
However, the name of this csv file is not constant.
Therefore I would rather like VBA to open a browser screen that shows all
csv files in a specific folder, where the user can just double click the
file that is needed as a source for the query table.

How can I let VBA open a browser window and show me all available CSV files?

Thanks,
Frans

Reply to this Message

Piotr Lipski - 22 Jun 2006 20:18 GMT

> Hi,
>
[quoted text clipped - 5 lines]
>
> How can I let VBA open a browser window and show me all available CSV files?

With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.Filters.Add "csv files", "*.csv"
.Show
If .SelectedItems.Count > 0 Then MsgBox .SelectedItems.Item(1)
End With

Signature

Reply to this Message

Frans Verhaar - 23 Jun 2006 06:57 GMT

Thanks, that works.

>> Hi,
>>
[quoted text clipped - 13 lines]
> If .SelectedItems.Count > 0 Then MsgBox .SelectedItems.Item(1)
> End With

Reply to this Message

Frans Verhaar - 24 Jun 2006 11:46 GMT

Thanks a lot Piotr. It works fine!
Regards,
Frans

>> Hi,
>>
[quoted text clipped - 13 lines]
> If .SelectedItems.Count > 0 Then MsgBox .SelectedItems.Item(1)
> End With

Reply to this Message