next »

[Steve Boll]

In WinRunner we used a statment - table = create_browse_file_dialog("*.xls")

This will open a file open dialog box for file selection.  You can change drives and directories in this dialog to find the file you want to use.  Is this functionality found in QTP?

[Steve Boll]

   So it looks like this is not doable in VBscript.   

[Aaron Silverman]

Can you elaborate on what you want to do with the file and where you open the file browser?  QTP can interact with the UI of many programs and navigate/open files.  This goes beyond the scope of its Web functionality though.

[Tomer Salem]

hi,

try that:

Set var_CreateInstance = DotNetFactory.CreateInstance("System.Windows.Forms.OpenFileDialog", "System.Windows.Forms")
var_CreateInstance.Filter = "Excel Files (*.xls)|*.XLS"
var_CreateInstance.ShowDialog

MsgBox var_CreateInstance.FileName

hope it helped.
Tomer.

[Steve Boll]

Tomer, I tried your approach and QTP hangs in a running state when executing the ShowDialog statement. 

[Tomer Salem]

hi,

what do you mean by "hangs", it is waiting to your (xls) file selection.
once you select one (and press Enter\Open), you will get it's full path at the message box.

I hope that it what you meant, I tried it, and it worked fine to me.

hope it helped,
Tomer.

[Steve Boll]

Thanks Tomer, works like a charm.  I was not looking under the QTP main window for the dialog box.