Create a file

[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

 

[Tom van Stiphout]

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

 

[learning_codes]

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 -

oops.. should be strSport instead of strDiv