General information
Title:
Assign UDF to documentFile property on an oleControl
I'd like to call my own GetFile wrapper (?) function, called Get_File() when I create my Excel OleControl object. I've tried a UDF in the PRG, and in a class method. I can call GETFILE() fine. I can assign the UDF return to a public variable in the prg, and set documentfile = myPublicVar.
I don't want to use a public, but I will if I have to. Any suggestions?
TIA
DEFINE CLASS oleexcelObject as OLEControl
oleTypeAllowed = 0
OleClass ="excel.sheet.8"
height = 170
top = 0
left = 0
DocumentFile = GetFile() && This works, but file must exist
*!* DocumentFile = this.getFile() && "Date type is invalid for this property."
PROCEDURE get_file
LOCAL cf
cf = getFile('XLS')
IF NOT FILE( cf )
RETURN ""
ENDIF
RETURN cf
ENDDEFINE
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only