Is there anything like a Browse function available, where
a file can be selected from a Windows Open dialog? I
would like to create a macro that selects an Excel file
to import from such a dialog.

Using a macro based on the TransferSpreadsheet action
with the following FileName argument:
= InputBox("Enter the filename:")
works great (suggested by Ken Snell), but requires typing
the path and filename.

Thanks.

John

Hi,
Here's the standard solution:
http://www.mvps.org/access/api/api0001.htm

--
HTH
Dan Artuso, Access MVP


"John Hipskind" <(E-Mail Removed)> wrote in message news:07f101c378c7$62c55370$(E-Mail Removed)...
> Is there anything like a Browse function available, where
> a file can be selected from a Windows Open dialog? I
> would like to create a macro that selects an Excel file
> to import from such a dialog.
>
> Using a macro based on the TransferSpreadsheet action
> with the following FileName argument:
> = InputBox("Enter the filename:")
> works great (suggested by Ken Snell), but requires typing
> the path and filename.
>
> Thanks.
>
> John
>
>
>
>