Using variable name in transferSpreadSheet Method

[Westeral]

I am attempting to use variable names in the transferSpread sheet method
instead of just putting in the name. I want to create a spreadsheet name
based on the concatenation of several fields on a form to generate a unique
name for the spreadsheet each time it is generated (area name, begin date
field, and end date field). These spreadsheets are to be sent to a central
state location where they will be imported into a central database. I wanted
a way to create a unique name for the file from each area. Is this even
possible or should I just use some other method to accomplish this? Thanks.
(I will be on vacation all next week so I won't see any response until
6/8/09).

 

[Ken Snell [MVP]]

See my website for various examples of TransferSpreadsheet with ACCESS.
http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm

As for concatenating values from controls of a form:

Forms!NameOfForm!NameOfControl1 & Forms!NameOfForm!NameOfControl2 &
Forms!NameOfForm!NameOfControl3

 

[Westeral]

Thanks, that will help me out in creating the name I want. How do I add the
concatenated name I created to the transferspreadsheet command? Right now
the name of the file I want created is in quotes (ie "c:\temp\test.xls"). How
do I insert my variable (concatenated name) in place of the test.xls?

 

[tina]

to build on Ken's example:

"c:\temp\" & Forms!NameOfForm!NameOfControl1 &
Forms!NameOfForm!NameOfControl2 &
Forms!NameOfForm!NameOfControl3 & ".xls"

hth

 

[Westeral]

Thanks much. I see what I was doing wrong now. I was close but now this will
be me there and this does exactly what I need.

 

[tina]

you're welcome

Thanks much. I see what I was doing wrong now. I was close but now this will
be me there and this does exactly what I need.