Accessing Name Manager Entries Dynamically

%3CLINGO-SUB%20id%3D%22lingo-sub-2831127%22%20slang%3D%22en-US%22%3EAccessing%20Name%20Manager%20Entries%20Dynamically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2831127%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20performing%20a%20data%20query%20where%20inbound%20TXT%20data%20is%20treated%20to%20a%20%22Create%20Name%22%20macro%20successfully.%3C%2FP%3E%3CP%3EInitially%20the%20data%20inbound%20was%20small%2C%20so%20the%20number%20of%20Names%20was%20small.%20However%2C%20I%20now%20have%20more%20data%20inbound%20such%20that%20there%20is%20a%20need%20to%20create%20a%20table%20of%20Names%20that%20resembles%20the%20data%20as%20seen%20in%20the%20Name%20Manager%2C%20but%20not%20exactly.%20For%20instance%2C%20I%20am%20not%20at%20all%20concerned%20with%20TABLE%20names.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20short%2C%20I%20would%20like%20to%20take%20Name%20Manager%20and%20table%20it%20dynamically%20as%20it%20updates.%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anyone%20know%20of%20a%20way%20to%20do%20this%20with%20or%20without%26nbsp%3BPowerQuery%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2831127%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2831756%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20Name%20Manager%20Entries%20Dynamically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2831756%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1181078%22%20target%3D%22_blank%22%3E%40edawcj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20talk%20about%20big%20data%20that%20you%20need%20help%20organizing%20and%20yet%20you're%20not%20sharing%20it%20or%20a%20sample%20of%20it.%20If%20you%20can't%20organize%20that%20data%20when%20you%20have%20the%20ability%20to%20look%20at%20it%20and%20test%20it.%20How%20can%20you%20expect%20someone%20to%20help%20you%20come%20up%20with%20a%20solution%20without%20that%20data%20set%3F%26nbsp%3B%20It%20does%20not%20matter%20how%20much%20that%20individual%20is%20a%20super%20genius%2C%20the%20only%20way%20that%20individual%20can%20help%20you%20is%20if%20they%20have%20a%20photographic%20memory....%20but%20then%20again%20you%20don't%20even%20have%20a%20screen%20shot....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2832203%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20Name%20Manager%20Entries%20Dynamically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832203%22%20slang%3D%22en-US%22%3EYeah%2C%20so...not%20really%20looking%20for%20help%20to%20manage%20my%20not-so-big%20data%2C%20just%20looking%20for%20a%20way%20to%20access%20Name%20Manager%20outside%20the%20actual%20Name%20Manager%20GUI.%20I%20could%20screen%20shot%20the%20Name%20Manager%2C%20but...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2832208%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20Name%20Manager%20Entries%20Dynamically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832208%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20incorporate%20the%20table%20creation%20with%20your%20macro%20going%20forward%2C%20but%20the%20existing%20ones%20you'll%20probably%20have%20to%20painstakingly%20define%20them%20manually%20unless%20you%20can%20create%20vba%20code%20to%20do%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I'm performing a data query where inbound TXT data is treated to a "Create Name" macro successfully.


Initially the data inbound was small, so the number of Names was small. However, I now have more data inbound such that there is a need to create a table of Names that resembles the data as seen in the Name Manager, but not exactly. For instance, I am not at all concerned with TABLE names present in the Name Manager.

 

In short, I would like to take Name Manager and table it dynamically as it updates.

Does anyone know of a way to do this with or without PowerQuery?

 

5 Replies

@edawcj 

 

You talk about big data that you need help organizing and yet you're not sharing it or a sample of it. If you can't organize that data when you have the ability to look at it and test it. How can you expect someone to help you come up with a solution without that data set?  It does not matter how much that individual is a super genius, the only way that individual can help you is if they have a photographic memory.... but then again you don't even have a screen shot....

Yeah, so...not really looking for help to manage my not-so-big data, just looking for a way to access Name Manager outside the actual Name Manager GUI. I could screen shot the Name Manager, but...

@edawcj 

 

You could incorporate the table creation with your macro going forward, but the existing ones you'll probably have to painstakingly define them manually unless you can create vba code to do it.

yup - sort of leaning that way. The added bonus to the VBA route is that the Names can be set to 'hidden'.

@edawcj 

 

it would be nice if uncle MS would add that feature to be able to access it as a list