Create a file

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

learning_codes

Hi,

I received an error saying "Failure creating file".

I would appreciate if you can advise me what did I do wrong.

strSport = "=" & Chr(34) & Me.cbo_Sport.Value & Chr(34)

DoCmd.TransferSpreadsheet acExport, 8, "Data", "Sport Report" & strDiv
& ".xls", True, ""

Your help would be much appreciated
 
On Mon, 8 Jun 2009 16:58:16 -0700 (PDT), "(e-mail address removed)"

Curious: You are showing us how you set strSport, but then you don't
use it in the next line of code.
What is the value of strDiv?

-Tom.
Microsoft Access MVP
 
On Mon, 8 Jun 2009 16:58:16 -0700 (PDT), "(e-mail address removed)"


Curious: You are showing us how you set strSport, but then you don't
use it in the next line of code.
What is the value of strDiv?

-Tom.
Microsoft Access MVP









- Show quoted text -
Click to expand...

oops.. should be strSport instead of strDiv
 
Back
Top