muddled_modron
New Member
- Joined
- Mar 29, 2022
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Version: MS Office 2016
I want to create an excel vba script for my office that can do data entry on chrome or edge websites, but I've never worked with other programs outside of excel using VBA (aside from keylogging with sendkeys but I'd like to avoid this since I want to give this to my coworkers)
I have a few concerns before jumping down the rabbit hole:
How many hours will it take to learn? (I've "tinkered" on and off with Excel VBA for about 2 years and have done a fullstack bootcamp, so i have some scripting experience)
What do I need to learn before I can have an excel to chrome script robust enough to complete data entry?
Will I have to know JS to execute more complex things like "wait for popup window to open" or "wait for page to load"?
Can I do this without installing other programs or downloading outside references? (getting approval for downloads is a nightmare)
Your insights are greatly appreciated.
I want to create an excel vba script for my office that can do data entry on chrome or edge websites, but I've never worked with other programs outside of excel using VBA (aside from keylogging with sendkeys but I'd like to avoid this since I want to give this to my coworkers)
I have a few concerns before jumping down the rabbit hole:
How many hours will it take to learn? (I've "tinkered" on and off with Excel VBA for about 2 years and have done a fullstack bootcamp, so i have some scripting experience)
What do I need to learn before I can have an excel to chrome script robust enough to complete data entry?
Will I have to know JS to execute more complex things like "wait for popup window to open" or "wait for page to load"?
Can I do this without installing other programs or downloading outside references? (getting approval for downloads is a nightmare)
Your insights are greatly appreciated.