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

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

Code:

---

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

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

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