Q1

From help

Dim lngCount As Long

' Open the file dialog
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = True
.Show

' Display paths of each file selected
For lngCount = 1 To .SelectedItems.Count
MsgBox .SelectedItems(lngCount)
Next lngCount

End With


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Orlando" wrote in message
...
Hi guys, is possible to create a commandButton to browse files, like
windows
bowser to load txt files on the excel worksheet?

the second question is I have sumary worksheet that take the data from
another worksheet, both are in the same Excel file, I would like to know
if
clicking double click over the cell with the total I can open a pop window
with the detail information that make the total.

I would appreciate any information.

Thanks