SysCmd(acSysCmdInitMeter) in Excel?

[zollo9999]

Hi

In Access, I've used the SysCmd object to create a Progress meter in the status line.

Is it possible to do the same thing in Excel?

The code below is not recognized in XL.

'varReturn = syscmd(acsyscmdinitmeter, "Progress", intRowEnd - intRowStart)

In my XL code, I added a reference to the access library, but it didn't help.

thanks
pb




Zollo9999 A+
(Very Part-Time Programmer)

 

[ploeryan]

Hello

I know this is not exactly what you are after but give it a go...

http://j-walk.com/ss/excel/tips/tip34.htm

Have fun

[Afro2]

 

[zollo9999]

Thanks
thats an excellent solution.
I'll give it a go next week.

Zollo9999 A+
(Very Part-Time Programmer)