TransferSpreadsheet create Parameter?

[Guest]

Apology in advance for low skill level here.....new to macro end.

Have TransferSpreadsheet macro that imports from Lotus and appends a range
of data to an exisiting table. Works fine. However, each week the file name
I need to import changes. (Ex: c:\MyDocuments\Sch1 , c:\MyDocuments\Sch2,
....) The macro is launched on the opening of particular report.

Rather than, each week, revising the file name in the macro can I not set up
a parameter or Dialog Box that would instead ask which file name I would like
to import? [Enter File Name]

And can this be done in the Access Macro set up - rather than using Visual
Basic which I'm even less familiar with?

Thank you very much for your time.

 

[Ken Snell \(MVP\)]

In the macro's File Name argument, use an expression that includes the
InputBox function:

="C:\MyDocuments\" & InputBox("Enter file name:")

 

[Guest]

Thank you so much!!!! It's working, it's fabulous! Thank you!!!

In the macro's File Name argument, use an expression that includes the
InputBox function:

="C:\MyDocuments\" & InputBox("Enter file name:")

--

Ken Snell
<MS ACCESS MVP>

Apology in advance for low skill level here.....new to macro end.

Have TransferSpreadsheet macro that imports from Lotus and appends a range
of data to an exisiting table. Works fine. However, each week the file
name
I need to import changes. (Ex: c:\MyDocuments\Sch1 ,
c:\MyDocuments\Sch2,
...) The macro is launched on the opening of particular report.

Rather than, each week, revising the file name in the macro can I not set
up
a parameter or Dialog Box that would instead ask which file name I would
like
to import? [Enter File Name]

And can this be done in the Access Macro set up - rather than using Visual
Basic which I'm even less familiar with?

Thank you very much for your time.