noslenwerd
01-15-2020, 11:41 AM
With the help of many on this board, over the course of the last month I create a pretty elaborate process using Excel/Word VBA for my org at work. I put over 40 hours into it, and was slated to save my 24 peers around 30 hours of work on a monthly basis (720 hours total monthly for those keeping score).
The process did the following:
Collects/formats data entered into Excel365
Creates a list of cells that are populated which is scrubbed and prepared for transmission to Word.
Based on checkboxes selected in Excel365, list out the local folder of over 100 topics used in our customer reviews
Opens an instance of Word. Populates data using find/replace
Looks at file locations (ie: C:\Worksheet\topic1.html) listed in the Word365 Document, and imports the content in the local html files.
Uses Word VBA to apply styling to the html data (ie: <b>bold</b> would then show as bold).
Saves a new instance of that Word Document as CompanyName.docx
The problem is I got the dreaded alert below while trying to install the process on a co-workers machine. I am not sure I will be able to use macros with our corporate policy. Which as a side-note is a bit odd to me because the process worked on my machines that have the same settings.
https://www.mrexcel.com/board/attachments/alert-jpg.4065/?hash=405b8d36f488d9350fcb3a7e16a87b8f
So what next? I do have a background in computer science, but haven't programmed in over a decade. My main question is:
What program language is similar to VBA, that will be able to execute a similar process for what I have listed above? I am willing to create an actual executable program, that does the following:
Open and instance of word, and populate a large variety of data that can be stylized (including hyperlinks, images, styling of text etc).
Collect data entered for a particular customer.
The new process can circumvent the need for Excel, but I do need to allow the end user to view this data in Word.
Any advise on where to go from here would be incredibly appreciated.
This has been cross posted at Mr Excel (https://www.mrexcel.com/board/threads/excel-to-word-vba-macros-blocked-by-enterprise-admin-what-path-to-go-down-now.1120751/).
The process did the following:
Collects/formats data entered into Excel365
Creates a list of cells that are populated which is scrubbed and prepared for transmission to Word.
Based on checkboxes selected in Excel365, list out the local folder of over 100 topics used in our customer reviews
Opens an instance of Word. Populates data using find/replace
Looks at file locations (ie: C:\Worksheet\topic1.html) listed in the Word365 Document, and imports the content in the local html files.
Uses Word VBA to apply styling to the html data (ie: <b>bold</b> would then show as bold).
Saves a new instance of that Word Document as CompanyName.docx
The problem is I got the dreaded alert below while trying to install the process on a co-workers machine. I am not sure I will be able to use macros with our corporate policy. Which as a side-note is a bit odd to me because the process worked on my machines that have the same settings.
https://www.mrexcel.com/board/attachments/alert-jpg.4065/?hash=405b8d36f488d9350fcb3a7e16a87b8f
So what next? I do have a background in computer science, but haven't programmed in over a decade. My main question is:
What program language is similar to VBA, that will be able to execute a similar process for what I have listed above? I am willing to create an actual executable program, that does the following:
Open and instance of word, and populate a large variety of data that can be stylized (including hyperlinks, images, styling of text etc).
Collect data entered for a particular customer.
The new process can circumvent the need for Excel, but I do need to allow the end user to view this data in Word.
Any advise on where to go from here would be incredibly appreciated.
This has been cross posted at Mr Excel (https://www.mrexcel.com/board/threads/excel-to-word-vba-macros-blocked-by-enterprise-admin-what-path-to-go-down-now.1120751/).