View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andibevan[_2_] Andibevan[_2_] is offline
external usenet poster
 
Posts: 128
Default Calling Macro - Will it take variables?

Hi All,

The following piece of code when included in my macro works perfectly

Application.Run "PVCS_cmdGetRevision(""C:\Program
Files\PVCS\vm\common\SampleDb\archives\Test\Test Folder 1\Test File
1.txt-arc"",""Test File 1.txt"")"

When I try to replace the file name and addresses with variables it does not
(Error = Expected function or variable) :-

Var_SelectedFile = "C:\Program
Files\PVCS\vm\common\SampleDb\archives\Test\Test Folder 1\Test File
1.txt-arc"
Var_workfile = "Test File 1.txt"

Application.Run PVCS_cmdGetRevision(Var_SelectedFile, Var_workfile)

What am I missing???

Ta

Andi