The new version of application.run is now: call
E.g.
instead of application.run(remove popup1)
It's not Call remove popup1

ooops... I wrote "not call remove popup1"
It should've been
now
call remove popup1

Many thanks for your response

Sorry but i am still not getting it. I need to replace for example

application.run ("edate", date, 2)

tried call "edate", date, 2 - not working

worksheetfunction.EDate (date,2) obviously works but i have code writen in Excel 2003 which uses excel date functyions extensively through application.run. Need to know the best way of replacing it.

vivek

Ok, I have to ask... and please be clear/succinct.
you wrote:
"
application.run ("edate", date, 2)

tried call "edate", date, 2 - not working
"
With Call "edate" you do not need to write the two double quotes.

E.g.
try
Call edate

that's it.
nothing else.

Thanks again Steve but,

In Excel2003, I used

application.run("edate", date,2)

If i use the below

Call edate(date,2)

it does not work.

Sorry if i am being dense!

Ah....
You didn't tell me 2003 before.
That I cannot help you with. If you looked more closely at the title of this specific component of the forum, you'd see it was for 2007. I.e., Excel 2007 VBA Programmers Reference.
My troubles have been with 2007.
My understanding of 2003 is that all of the VBA code from Office 97, through 2003 is identical.
Therefore, the application.run should work.

Have you tried the MSDN newsgroups?

http://msdn.microsoft.com/newsgroups...xp=&sloc=en-us

I use them for most of my stuff.

I'd only come here to post because we got the book, and there was a faceid macro I tried. I was having trouble getting the macro to work the way it was written, so I came here to ask why.
Sunday and I got it worked out, and that was the last I posted here--until I got the subscription note that you came in looking for help.

Sorry Steve,

I think i have not been clear. What I meant was in Excel 2003, I have always used

application.run("edate", date, 2) and it works.

However in Excel 2007 this does not work. I have tried replacing it by

1)Call "edate", date, 2
and
2)Call edate, date,2

and both do not work.

I will check up the msdn site. Will let you know if it gets sorted.

Thanks ton for ur time mate:)

Ok, I see now.
You've used

application.run ("edate", date, 2)

under 2003, and it works fine.

under 2007, the following is required.

Call edate

That's it. nothing else.
Do not add the quotes, do not add the-- date, 2-- or anything else.

What you're doing is calling to activate another macro that's already been defined elsewhere.
The ("edate", date, 2) is actually calling specific items under the "edate" macro. by doing call edate, date, 2, you're redefining, or re-stating what's already been stated/defined under your edate macro. So, somewhere in one of your macro modules, you defined a macro.
You named the macro edate.
is it a private/public function, or is it a Sub macro?
If you're macro is a function, then you will need to define the second, and 3rd elements-- date, 2-- somewhere else, and that I do not know about. I haven't attempted that yet.