Calling a function

[DeanP]

I am trying to call a function from a sub routine but cannot do it. Error: argument not optional. I've researched in a lot of places to find a solution but I don't really understand the answers people give.

The function I'm using checks whether a file already exists:

Function FileExist(FilePath As String) As Boolean

I want to call this function from another macro. Using "Call FileExist" doesn't work, what will?

[JKwan]

Try:


dim ReturnCode
ReturnCode = FileExist("c:\test.txt")
msgbox ReturCode

[Paul_Hossler]

I am trying to call a function from a sub routine but cannot do it. Error: argument not optional. I've researched in a lot of places to find a solution but I don't really understand the answers people give.

The function I'm using checks whether a file already exists:

Function FileExist(FilePath As String) As Boolean

I want to call this function from another macro. Using "Call FileExist" doesn't work, what will?


In the definition


Function FileExist(FilePath As String) As Boolean

FilePath is the 'Argument'. 'Not Optional' means that it is required

Since it is supposed to determine if a file exists, you have to tell it which file you want to check



If FileExists ("C:\Users\MyName\Documents\Report.xlsx") Then
' do if true
Else
' do if not there
End IF

[J FelixBosco]

Dim doesFileExist as Boolean
doesFileExist=FileExist("C:\SomeFileName.txt")

[DeanP]

Thank you all for your help!