Access (or Excel) VBA StrPtr Type mismatch (64bit)

[Static]

basically this is my issue:
http://support.microsoft.com/kb/9832...rss&spid=14019

i have an FTP class module that works fine in 32 bit machines... but not in 64 bit Office/Win7

Private Function StripZ(ByVal s As String) As String
'Return all of s before the zero-terminator (if any).
    StripZ = Left$(s, lstrlen(StrPtr(s)))
End Function

highlights StrPtr and says type mismatch.

I tried the hotfix (from another location since its gone from MS) and it said it doesnt apply to my machine.. I have SP1 installed.

I tired to look at the StrPtr Definition and it says its hidden? (in the object browser)


What is StrPtr and how do i replace/fix it!
HELP!

Thanks

[Static]

well i fixed it with a few clng s lol

but now access crashes trying to open the 240mb csv lol great..... i need to download / open / check the row count on 100 files 200mb or larger

this should be fun

[Niya]

Bear in mind that all pointers are 64 bits wide in any 64 bit version of Windows.