View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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