Thread: Add variablesm to the DoCMD
View Single Post
  #1 (permalink)  
Old July 9th, 2009, 04:50 PM
baNTON baNTON is offline
Registered User
Points: 38, Level: 1
Points: 38, Level: 1 Points: 38, Level: 1 Points: 38, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: Monroe, CT, USA.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Add variables to the DoCMD
I am new to some of VBA. I want to take the following statement and make
PR_WINTER a variable
"N:\ROI_08\Reports\ROILIVE" & Format(Date, "MMDDYY") a variable
DoCmd.TransferSpreadsheet acExport, 8, "PR_WINTER", "N:\ROI_08\Reports\ROILIVE" & Format(Date, "MMDDYY"), True, ""

I can't seem to find this information anywhere in all my books.
Any help would be appreciated.
Thanks
Bill
Last edited by baNTON : July 10th, 2009 at 09:23 AM.
Reply With Quote