Error 1004 Method 'ThisWorkbook' of object application failed

[vba317]

I am trying to use vba to refresh my excel table. I am getting error 1004. My workbook has three tabs if this makes a difference. Any help would be appreciated.

In its own module
Public goXL As Excel.Application   

[Yellow] goXL.ThisWorkbook.RefreshAll [/Yellow]

 

[SkipVought]

hi,

Are you running this code IN ThisWorkbook or not?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[vba317]

No, I am runniing it on an access form.

Tom

 

[PHV]

Use goXL.CurrentWorkbook instead, as ThisWorbook has no mraning outside an excel VBA project.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vba317]

goXL.CurrentWorkbook didnt work
goXL.ActiveWorkbook.RefreshAll worked

Thank you for pointing me in the right direction.

Tom

 

[PHV]

OOps, sorry for the typo.