Any youtube videos may help me write a VBA macro to append text to multiple topics's notes? thx

charles c. shared this question 22 days ago
Discussion Open

hi,

from this post i knew that it's now NOT possible to paste text into multiple nodes' note:

https://community.mindmanager.com/topic/208-paste-to-multiple-topics


currently, i routinely have to do so. it uses up time so i wanna change.

i knew some programming PRINCIPLES, but don't know much.

just dig out the API, i found that.

suppose i selected a topic,

1. then "topics object's UnfilteredSubTopics Property" could tell me what topics are under the selected topic.

2. then "notes object's insert method" will allow me to add text at start (if cursor is 0) or append (if cursor is -1).


then make a loop of something like:


for cycle=0 to end

[topic.insert=text]


then will be ok.


is it like that?


or could someone write it up for a small amount of money?


thanks


Replies (4)

photo
1

i would like to use the app studio if it could do it, /w student discount, thanks

photo
1

https://www.freelancer.ca/projects/visual-basic-visual-basic-for-applications/mindjet-mindmanager-vba-macro


seems could pay for just 25USD.


i'll donate 25USD and host a project there if no response here.

thx

photo
2

I would be happy to help with this, but I cannot compete with $25 :-) I would be interested to see the results though.

Please contact Nigel Goult at Olympic about a long term trial key for App Studio.

photo
1

it's done, if someone don't mind he/she need to open the macro editor and type in the text he/she wanna populate.

i saved that USD25 for myself.

the script is working, i may fine tune it later.

thanks

photo
2

Well done. You could use the InputBox function or a dialogue to dynamically get the input text.

photo
photo
1

just tested codes,

if the macros only deal /w single topic and you select multiple topics,

it wont work like the original, build in paste note function.


https://community.mindmanager.com/topic/1847-worth-to-spend-time-learning-mms-vba-the-winwrap-basic-language#comment-4671


a thought was there, may be implement later.


thanks

photo
2

No, that's not correct. A macro can iterate over multiple topics in the selection, but that needs to be coded in the macro.

photo
1

anyway, almost accomplished. thanks

photo
1

as a flashback,

indeep the OP of the other thread is talking about MM cannot paste text into multiple topics.

while i am talking about MM cannot paste text into multiple topics' NOTE.


i just found out that.


btw, indeep using my script, one should be easily do the other way,

but i didn't need that.

photo
Leave a Comment
 
Attach a file