TransferSpreadsheet create Parameter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
In the macro's File Name argument, use an expression that includes the
InputBox function:

="C:\MyDocuments\" & InputBox("Enter file name:")
 
Thank you so much!!!! It's working, it's fabulous! Thank you!!!

Ken Snell (MVP) said:
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>

KarinB said:
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.
Click to expand...
Click to expand...
 
Back
Top