Forum Discussion
Solved
Obtain data from a cell with lots of paragraphs
Cool, So I have multiple questions I need help with regarding formulas and macros. ok, So I have a cell that contains paragraphs of text. Imagine I'm a teacher, and each student gave multiple par...
If you want the function to be available in all workbooks, store it in a module in an add-in or in your personal macro workbook PERSONAL.XLSB.
Is the attached version better?
If you want the function to be available in all workbooks, store it in a module in an add-in or in your personal macro workbook PERSONAL.XLSB.
Is the attached version better?
Update, I got my old macros to work.
But on your file now it shows Ambiguous name detected: ExtractParts
But on your file now it shows Ambiguous name detected: ExtractParts
- Update, so I copied it to my PERSONAL.XLSB but whenever I open a new csv file or xlsx file.
The function does not work, and throws a #NAME? issue.
Anything I need to do so this function =ExtractParts(transcriptcell,absolute_cell_Value_for_keyword) works on my csv & xslx files?- Update:
OMG, I figured out what you told me to do. finally!
from https://support.microsoft.com/en-us/office/create-custom-functions-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f
Now I have a new issue.
So I like things organized, and renamed the modules from module1,2,3,4,5 to understandable ones.
click on module > view > properties windows > rename on the bottom left side.
This, kinda made all the shortcuts for my macros break.
Basically, An exact problem this guy had -> https://stackoverflow.com/questions/59105782/how-can-i-make-my-macro-shortcut-key-work-again
kay, so I renamed it all with an extra "s", so its FormatTranscriptss, CleanTranscriptss, ExtractPartss
It's all working now.
but like, I can't get its name back to without the additional "s", and my OCD hurts.
Any solutions?
If I try, I get "This will reset your project. Shall we Proceed?"
Saying "confirm" again breaks it back to PERSONAL.XLSB!FormatTranscripts.FormatTranscripts
Which is broken, as shown in the URL link above. Sigh.
Please adviseThe names of the modules aren't really important, you can use anything you like, as long as the names are not the same as those of macros or custom functions.