Running a module from Switchboard?

[STaL1N]

my code is as follows

Public Function MergeReportData()
Dim strPath1 As String
Dim strPath2 As String
    strPath1 = "P:\Apps\32BitWin\Office2000\PFiles\MSOffice\Office\WINWORD.EXE"
    strPath2 = "N:\MyWork\ASComp\ASCoursework\rawCompanyOverOneYear.doc"

Shell strPath1 & " " & strPath2, vbNormalFocus
End Function

I have chosen the run code option in switchboard items and i typed in "MergeReportData" as the function name, however when i click the switchboard command button an error occurs
"There was an error executing the command"

does anybody have any ideas?

 

[scriverb]

Let's execute the code without the switchboard and debug it there first. Create a form with a command button that makes a function call to this function. See if it works or you get the same error.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[STaL1N]

its ok i got a workaround. my switchboard now runs a macro which in turn runs the code!

thanks anyway!