JOOLE objects

[dinodigital]

I was hoping to get some help with displaying the openFileDialog from within brio using a joole object. I have narrowed it down to this code:

var ComDlg = new JOOLEObject("MSComDlg.CommonDialog");
ComDlg.MaxFileSize = 1024;
ComDlg.DialogTitle = "Please select a file type and file"
ComDlg.Filter = "All Files|*.*"
ComDlg.ShowOpen();

var filename_string = ComDlg.FileName;

Console.Write(filename_string);

and once the user has selected the file, I need to be able to capture the filename/path for use in the brio document. For some reason I've been told that this example should work, but it doesn't. No dialog box pops up at all.

Could someone please shed some light on what else needs to be delcared for this to work. I'm guessing it has something to do with MSComDlg.CommonDialog and making sure it is referenced correctly.

Any help is greatly appreciated.

thanks