Out put file

[wasim_sono]

Dear All

I need to generate an excell file as user click a label. I used the following code but got a compile error. the code is given below

Private Sub Label61_Click()
DoCmd.OutputTo Table, IncTransaction, ExcelWorkbook(*.xlsx), d:/fuel&incentive/Inc.xlsx, Yes, , 0, print
'DoCmd.Quit
End Sub

This is working in macro but in VBA it gives error.
Need help

Thanks.

Wasim

[SoftwareMatters]

What is the error?

What are you trying to output to Excel?

[wasim_sono]

I got a compile error. I can show you the error but here is no option to attach a file. If you give me an email address then I can send you a copy.

Thanks.

[wasim_sono]

I got a compile error. The screen shot is attached for reference.


Thanks.

[pbaldy]

You either need to click on Post Reply or Go Advanced to get the option to attach a file. At a guess, I'd say to look at VBA help at OutputTo. Off the top of my head, I don't recall Table being a valid argument, and arguments such as the table name and path have to be strings (enclosed in quotes), like "IncTransaction".