executing a public function

**DKasler** · Jan 18th, 2005, 03:27 PM

How do i execute a public funtion at runtime?

VB Code:

Public Function FG_SaveAsExcel(FG As MSFlexGrid, sFileName As String, Optional sHeader As String = "", Optional sFooter As String = "")

Thats the function I want to run.

**dglienna** · Jan 18th, 2005, 03:34 PM

It doesn't have a return value, so it should be a subroutine.
Just use a CALL statement to call the subroutine, with the parameters.

Code:

CALL FG_SaveAsExcel(flxGrid, "filename", "Header")

**RobDog888** · Jan 18th, 2005, 03:40 PM

Or without the Call, same difference.

VB Code:

FG_SaveAsExcel flxGrid, "filename", "Header"

Thread: executing a public function