RP - Add contents of cell A1 in all workbooks within a folder
No, it should be a folder object as the function expects an object, not a
folder name.
--
HTH
RP
"Myrna Larson" wrote in message
...
Now I'm confused. Strings aren't "objects", are they? The following code
gave
me a compiler "argument type mismatch" error
Sub Test1()
Dim x As String
x = "abc"
y = Fn(x)
End Sub
Function Fn(obj As Object)
Debug.Print obj.Name
End Function
On Mon, 4 Oct 2004 16:28:18 -0400, "Tom Ogilvy" wrote:
Would that be because you declare
Function FileCountOK(pzFolder as Object)
to require the folder (as string) passed as an argument?
If FilecountOK("C:\Myfolder") then
|