First of all,
when asking a question from the group, you should start a new discussion thread.
repsonding to the GroupInfo email makes it look like you're giving advice on how to run a discussion group or commenting on the rules for the group.
(which I usually delete)
As far as your problem being "because you're running 32-bit excel on a 64-bit operating system":
I don't think that's the issue.
I've been doing this for quite some time and have nearly 100,000 lines of VBA code running without seeing this type of error.
I copied your declaration into one of my code modules
(in a "standard" module, outside of a macro)
and ran another macro, and it didn't give me a compilation error.
I don't know what you're doing with this sub, or what parameters need to be supplied, so I cannot test it.
However, I DID see an article that implied that you need to use a different syntax depending on your version:
The Microsoft article suggests using something like:
#If VBA7 Then
Private Declare PtrSafe Sub hmemcpy Lib "KERNEL32" Alias "RtlMoveMemory" (hpvDest As Any, hpvSource As Any, ByVal cbCopy As Long)
#Else
Private Declare Sub hmemcpy Lib "KERNEL32" Alias "RtlMoveMemory" (hpvDest As Any, hpvSource As Any, ByVal cbCopy As Long)
#End If
Private Declare PtrSafe Sub hmemcpy Lib "KERNEL32" Alias "RtlMoveMemory" (hpvDest As Any, hpvSource As Any, ByVal cbCopy As Long)
#Else
Private Declare Sub hmemcpy Lib "KERNEL32" Alias "RtlMoveMemory" (hpvDest As Any, hpvSource As Any, ByVal cbCopy As Long)
#End If
hope this helps.
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
From: "gabizata@yahoo.com.br [ExcelVBA]" <ExcelVBA@yahoogroups.com>
To: ExcelVBA@yahoogroups.com
Sent: Sunday, August 3, 2014 9:58 PM
Subject: [ExcelVBA] Re: File - GroupInfo.txt
Guys, I need some help with excel because I`m trying to use an old version (32bits) and my windows runs 64, then a problem "compilation error" appears to correct or complete this sentence "Declare Sub hmemcpy Lib "KERNEL32" Alias "RtlMoveMemory" (hpvDest As Any, hpvSource As Any, ByVal cbCopy As Long)"...
any suggestions?
__._,_.___
Posted by: Paul Schreiner <schreiner_paul@att.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (92) |
Yahoo Groups
New - View Group Photos by Time or Location
Enjoy your group's photos beautifully arranged by date or place
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar