ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   OpenFile dialogbox (https://www.excelbanter.com/excel-worksheet-functions/7038-openfile-dialogbox.html)

Manu Palao

OpenFile dialogbox
 

Hi
Iīm programming a macro, and I donīt know whether it is possible to
show a dialog box asking the user to open a file (the standard windows
dialog), so that this file can be used later on within the macro.
Does anybody know it?
Thanks!


--
Manu Palao
------------------------------------------------------------------------
Manu Palao's Profile: http://www.excelforum.com/member.php...o&userid=16205
View this thread: http://www.excelforum.com/showthread...hreadid=320145


Jason Morin

Application.Dialogs(xlDialogOpen).Show

HTH
Jason
Atlanta, GA

-----Original Message-----

Hi
I=B4m programming a macro, and I don=B4t know whether it is=20

possible to
show a dialog box asking the user to open a file (the=20

standard windows
dialog), so that this file can be used later on within=20

the macro.
Does anybody know it?
Thanks!


--=20
Manu Palao
---------------------------------------------------------

---------------
Manu Palao's Profile:=20

http://www.excelforum.com/member.php?
action=3Dgetinfo&userid=3D16205
View this thread:=20

http://www.excelforum.com/showthread...eadid=3D320145

.



All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com