View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bjørn Holm Bjørn Holm is offline
external usenet poster
 
Posts: 3
Default Correct syntax for use Replace command via DDE?

Hi.
I am trying to run the Find/Replace command in Excel remotely via DDE.
What is the correct syntax for doing this?

I have tried this:

[Cells.Replace What:="@what", Replacement:="@with", LookAt:=xlPart,
SearchOrder:=xlByRows, MatchCase:=False]

but with no luck.
Is there a list of correct syntaxes for Excel VBA-commands run via DDE
anywhere? I have searched on the web without finding anything.

regards,
Bjørn Holm
Nordak as
Norway