Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Use the GetOpenFileName which Displays the standard Open dialog box and gets
a file name from the user without actually opening any files. Change .txt to the picture extension you are using such as .jpg fileToOpen = Application _ .GetOpenFilename("Text Files (*.txt), *.txt") If fileToOpen < False Then MsgBox "Open " & fileToOpen End If "gwbdirect" wrote: Want to crteate a macro that goes to exploerer and allows me to choose any photo by clicking on it. Not a specific photo but different ones each time I run the macro. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locate data macro | Excel Discussion (Misc queries) | |||
Using a macro to locate a user given value | Excel Programming | |||
Locate and Format Row Macro | Excel Programming | |||
locate picture location using macro | Excel Programming | |||
Crrection Help for a macro to locate max value cell | Excel Programming |