Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2023, 12:59 AM
claus1 claus1 is offline Trying to determine which macro adds a bunch of extraneous names to files... Windows 10 Trying to determine which macro adds a bunch of extraneous names to files... Office 2019
Novice
Trying to determine which macro adds a bunch of extraneous names to files...
 
Join Date: Oct 2023
Posts: 1
claus1 is on a distinguished road
Default Trying to determine which macro adds a bunch of extraneous names to files...

My company (B4 accounting) provides a variety of legacy (typically internally made by employees within each group, not professionally developed) macros and newer (3rd party) toolbars for our workflow. An ongoing and recurring issue is that workbooks tend to get bloated with a bunch of random names (both hidden and visible), causing unnecessarily large file sizes and the continuous need to remove 50k+ names from a file. This is compounded by the fact that teams of people are working across files, where everyone is also using their own personal suite of macros.

My question is how I'd go about pinpointing which macro is dumping all of these names into files? Some are also in Korean or Chinese, and some are referencing other projects. With limited VBA experience, I would guess that some macro has some sort of template file embedded within it, and these names get carried over when certain macros are used. The kicker is that half the macros are password protected, so I'm unable to look into the underlying code.
Reply With Quote
  #2  
Old 10-23-2023, 09:44 AM
Logit Logit is offline Trying to determine which macro adds a bunch of extraneous names to files... Windows 10 Trying to determine which macro adds a bunch of extraneous names to files... Office 2007
Expert
 
Join Date: Jan 2017
Posts: 525
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

From your description of the problem ... you will need management from the C-Suites to issue a proclamation how things will change and then for them to enforce those changes. There isn't anything you will be able to do on your own.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to determine which macro adds a bunch of extraneous names to files... Macro to print to pdf files showing pupil names Richystab Excel Programming 13 12-17-2020 03:16 PM
Trying to determine which macro adds a bunch of extraneous names to files... Need to import a bunch of .png files from a folder djlee PowerPoint 22 01-18-2015 02:38 AM
Trying to determine which macro adds a bunch of extraneous names to files... Macro to determine if word or excel application is being used Catty Word VBA 2 04-01-2014 08:13 PM
Macro to determine attached template zippyaus Word VBA 0 03-02-2010 02:05 AM
Extraneous record in Word Mail Merge aldo13 Mail Merge 0 01-23-2006 01:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 PM.


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