2 Questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Orlando - 24 Aug 2007 00:54 GMT

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

Reply to this Message

Barb Reinhardt - 24 Aug 2007 01:34 GMT

I'll answer the second question. I think I'd use a
Worksheet_SelectionChange event for this and put the data you want in a
location that you access with the event.

> Hi guys, is possible to create a commandButton to browse files, like windows
> bowser to load txt files on the excel worksheet?
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Tom Ogilvy - 24 Aug 2007 14:00 GMT

for a double click as requested, wouldn't it be better to use the
BeforeDoubleClick event?

http://www.cpearson.com/excel/events.htm
for an overview of events if the OP is not familiar.

Signature

Regards,
Tom Ogilvy

> I'll answer the second question. I think I'd use a
> Worksheet_SelectionChange event for this and put the data you want in a
[quoted text clipped - 11 lines]
> >
> > Thanks

Reply to this Message

Bob Phillips - 24 Aug 2007 09:03 GMT

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

Signature

HTH

Bob

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

> Hi guys, is possible to create a commandButton to browse files, like
> windows
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message