calling a macro

[#1]

i dont know how to write vb script

i want to write a macro

purpose of this macro is calling external doc 1 for sheet 1 and calling external doc 2 for sheet 2

please help me out

[#2]

Why not open a qvw with the standard actions

in the target QVW you can set a trigger on open, which selects a sheet

[deepakk]

hi,

YOu need not write a macro to acheive this.

Add a button go to the Action tab in properties..

Then Go to

Action --->External --- Launch

You will find four parameters.

Application : You need to provide the path of the Software through which you want to open the file

eg: If you want to open an Excel file the you need to give the path Excel.exe

Filename : Provide the filename eg: Test.xls

Ignore parameters

Working Directory : You need to provide the path of the file which you want to open.

I hope this helps you out.