File Open (VBA Office 2K)

Topic

New Reply

Good afternoon folks
Some time back I stumbled across a snippet of code that someone posted which was the equivalent of using File/Open from the menu bar in Word or Excel. Like Word the code presented a graphic of the folder tree; allowing the user to browse. If someone recalls the post and can pointy me to it, i will be most grateful.

Reply | Quote

Replies

If you want to let the user select a folder, you may mean post 271140.

If you want to let the user open a file, you can use Application.Dialogs(wdDialogFileOpen).Show in Word, or Application.Dialogs(xlDialogOpen).Show in Excel.

Reply | Quote

Thank you Hans, you have anticipated my eveery need.

Reply | Quote

Thank you Hans, you have anticipated my eveery need.

Reply | Quote

If you want to let the user select a folder, you may mean post 271140.

If you want to let the user open a file, you can use Application.Dialogs(wdDialogFileOpen).Show in Word, or Application.Dialogs(xlDialogOpen).Show in Excel.

Reply | Quote