Jan Karel Pieterse
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Jan Karel Pieterse
-
If you're new to Office script, here are some example scripts: Excel Office Script Examples (jkp-ads.com)
-
If you need to get started with Office script, here is an explanation of the bare bones requirements to start using it: https://jkp-ads.com/Articles/Excel-office-script-basics.asp
-
It can replace some VBA programming, but not all. Office Script lacks several important options, for example: No multi-document awareness No prompting the user for information No events And at the moment, it only runs in Excel on-line