Using Access VBA in Excel !

[leonxxvii]

Hello All, I am new to VBA and programming in general I’ve got an application that runs great in Access but I like to run the same code in Excel when I copy it over I get run- time error 483. It appears that the problem is with Application.echo I know echo is not available in excel, so I was wondering if any body knew what I could use instead.
Any help would be greatly appreciated.
The code is as follow:

Application.Echo True, "P**** batch - " & sRutin

 

[Ed2020]

Have a look at Application.Interactive, Application.DisplayAlerts and Application.ScreenUpdating.

Ed Metcalfe.

Please do not feed the trolls.....

 

[leonxxvii]

Thank you Ed2020, Screenupdating was the 1st thing that came to my mind so, I have tried that already but unfortunately it didn’t work now I am going to try the code with Application.Interactive and Application.DisplayAlerts

 

[leonxxvii]

Thanks Ed , some one sugested I use Application.DisplayStatusBar
Application.StatusBar
and it worked like a charm.
I really appriciate your effort, thanks a bunch.