Kenny22
03-14-2012, 08:01 AM
Hi All,
Im hoping someone can help me out with this. I have spent hours trying to figure this. Im a newbie to VBA in gerneral.
What im trying to do is have a button whereby the user can insert thier data into the spreadsheet and then simply click it and a Screen capture occurs, saving it as an image.
I have reviewed the following post and code by "Zack Barresse" and this is exactly what i need.
(http://www.vbaexpress.com/kb/getarticle.php?kb_id=1075)
However, im operating a 64-bit system and this code isnt working for me. When i try run the code on my computer its mentions a "PtrSafe" ?
Any help would be appreciated.
Thanks in advance :)
Im hoping someone can help me out with this. I have spent hours trying to figure this. Im a newbie to VBA in gerneral.
What im trying to do is have a button whereby the user can insert thier data into the spreadsheet and then simply click it and a Screen capture occurs, saving it as an image.
I have reviewed the following post and code by "Zack Barresse" and this is exactly what i need.
(http://www.vbaexpress.com/kb/getarticle.php?kb_id=1075)
However, im operating a 64-bit system and this code isnt working for me. When i try run the code on my computer its mentions a "PtrSafe" ?
Any help would be appreciated.
Thanks in advance :)