vba error

[davide128]

I'm trying to extract a swf(flash) file from a word doc and getting this "compile error" method or data member not found.. The VBA is choking at this point . any ideas?

tmpFileName = Application.GetOpenFilename("MS Office File (*.doc;*.xls), *.doc;*.xls", , "Open MS Office file")

 

[Ruddles]

Ah, good, yes, I'm pleased. You can use a similar method for 'borrowing' other stuff from Excel like its mathematical functions - things like that.