VBA TECHNIQUES FOR ADVANCED EDITING AND DATA REVIEW IN POPULAR OFFICE PROGRAMS

Zoran Milanović, Milan Srećković

Abstract


Office software has always been appealing with its rich toolbox and the ability to expand and adapt to the user-specific needs. The idea behind writing a paper is to extend existing tools for searching, marking, replacing, and comparing data (words, sentences, and punctuation) using advanced techniques, with the aim of better and more efficient viewing of large documents, spreadsheets, and presentations. One of the most commonly used techniques is to write macros in VBA (Visual Basic for Applications) code, which has also been applied to realize the stated idea and goal. Three specific examples are presented in the paper: Macro for searching and marking text by two colors, Macro for automatic replacement of words, sentences and punctuation and Macro for searching and marking the same sentences in text, with detailed instructions for their application. They allow multiple searches, annotation, replacement, and comparison of a large number of data at the same time with data from pre-created databases (newly created or already existing). The examples presented also offer a number of new possibilities and an extension of the existing idea, where, among other things, the creation of specific databases for some narrower scientific fields would enable exploration of plagiarized works, i.e. misuse of someone else's intellectual property.

Keywords


Search, bookmark, replace and compare data, macro commands

Full Text:

PDF (Serbian)

References


CyberText. (2015). Word: Macro to run multiple wildcard find and replace routines. https://cybertext.wordpress.com/2015/03/03/word-macro-to-run-multiple-wildcard-find-and-replace-routines/

Harkins, S.. (2016). Macro trick: How to highlight multiple search strings in a Word document. https://www.techrepublic.com/article/macro-trick-how-to-highlight-multiple-search-strings-in-a-word-document/

Kovačević, I. Milenković, M. (2013). Članak vredniji od knjige?! Razaranje interpretativnog suvereniteta srpskog društva. Etnoantropološki problemi, n.s. god. 8. sv. 4 str. 10 http://www.anthroserbia.org/Content/PDF/Articles/5f014898b9cd43bcb60ba93b4b7a5657.pdf

Kylefoley76. (2010). Macro for performing more than one find and replace procedure at the same time. https://answers.microsoft.com/en-us/office/forum/office_2003-word/macro-for-performing-more-than-one-find-and/bd931bf7-5ebe-4650-924c-d15c9512129c?page=1

Microsoft, (2020a). Find and replace text. https://support.office.com/en-us/article/Find-and-replace-text-and-other-data-in-a-Word-document-c6728c16-469e-43cd-afe4-7708c6c779b7

Microsoft, (2020b). Create or run a macro. https://support.office.com/en-us/article/create-or-run-a-macro-c6b99036-905c-49a6-818a-dfb98b7c3c9c

Microsoft, (2020c). Automate tasks with the Macro Recorder. https://support.office.com/en-us/article/Automate-tasks-with-the-Macro-Recorder-974ef220-f716-4e01-b015-3ea70e64937b

MS Office Forums. (2016). http://www.msofficeforums.com/word-vba/33610-how-find-duplicate-phrases-paragraphs-long-document.html

Stackoverflow. (2017a). Read Cyrillic characters to VBA variable. https://stackoverflow.com/questions/46645790/read-cyrillic-characters-to-vba-variable

Stackoverflow. (2017b). Highlight repeat sentences or phrases in a Word document. https://stackoverflow.com/questions/25457273/highlight-repeat-sentences-or-phrases-in-a-word-document

Wise, B. (2016). Word 2016 Version of a macro to perform more than one Find and Replace procedure at a time. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_mac-mso_mac2016/word-2016-version-of-a-macro-to-perform-more-than/a40e4a42-14ef-4b49-adce-4e0d3cd7615c


Refbacks

  • There are currently no refbacks.