Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2024, 11:16 AM
Jakov93 Jakov93 is offline Run a Macro VBA on x64 version of Microsoft Office Windows 10 Run a Macro VBA on x64 version of Microsoft Office Office 2010
Advanced Beginner
Run a Macro VBA on x64 version of Microsoft Office
 
Join Date: Jul 2021
Posts: 45
Jakov93 is on a distinguished road
Default Run a Macro VBA on x64 version of Microsoft Office

Hi,
I installed the macro of cleanup text of Greg Maxey from the following link
Cleanup Text
but after installing it, when I run it, the following message appears
104.png
So, how to fix this issue?


Thanks
Reply With Quote
  #2  
Old 02-27-2024, 02:20 PM
Guessed's Avatar
Guessed Guessed is offline Run a Macro VBA on x64 version of Microsoft Office Windows 10 Run a Macro VBA on x64 version of Microsoft Office Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Have a look at this thread
excel - How should I make my VBA code compatible with 64-bit Windows? - Stack Overflow

There are actually other declarations in older code that fail when used on more modern 64-bit systems. This page compiled by Jan Karel Pieterse lists all the code I've needed (so far) to adapt my templates Declaring API functions for 64 bit Office (and Mac Office)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 02-27-2024, 10:17 PM
Jakov93 Jakov93 is offline Run a Macro VBA on x64 version of Microsoft Office Windows 10 Run a Macro VBA on x64 version of Microsoft Office Office 2010
Advanced Beginner
Run a Macro VBA on x64 version of Microsoft Office
 
Join Date: Jul 2021
Posts: 45
Jakov93 is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
Thanks Andrew
It works perfectly
Reply With Quote
  #4  
Old 02-28-2024, 09:03 AM
gmaxey gmaxey is offline Run a Macro VBA on x64 version of Microsoft Office Windows 10 Run a Macro VBA on x64 version of Microsoft Office Office 2019
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,429
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Andrew, Jakov93


I've updated the page. Thanks for bringing the issue to my attention.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Run a Macro VBA on x64 version of Microsoft Office Can you add citations on iPad version of Microsoft Word? Udai252525 Word 2 06-17-2023 03:22 PM
Unable to install Microsoft Office 2021 desktop version on a Windows 11 PC lousk Office 1 04-09-2023 07:30 AM
My Microsoft 365 has Version 2007 Boro Office 2 08-29-2020 07:37 AM
XLM Files are not being opened in newer version of Microsoft Office 2013 KetulShah Excel 0 03-18-2014 08:23 PM
Run a Macro VBA on x64 version of Microsoft Office Will Microsoft Office 2010 Offer an Upgrade Version? benjo Office 4 06-08-2010 04:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft