Using variable name in transferSpreadSheet Method

  • Thread starter Thread starter Westeral
  • Start date Start date
W

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).
 
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?
 
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?
 
to build on Ken's example:

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

hth
 
to build on Ken's example:

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

hth
 
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.
 
Back
Top