View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Calling Macro - Will it take variables?

'could you use:
Call PVCS_cmdGetRevision(Var_SelectedFile, Var_workfile)
'or
PVCS_cmdGetRevision Var_SelectedFile, Var_workfile




"Andibevan" wrote:

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