►
From YouTube: Excel Office Scripts: Application basics and environment
Description
Checkout the document referred in the video: https://github.com/sumurthy/officescripts-projects/blob/main/Getting%20Started/README.MD
Contents
0:00 Intro
0:25 Access and availability
2:15 Core features
4:44 Code editor features
10:15 Editor short-cuts
A
Hi
in
this
video
I'm
going
to
walk
through
some
of
the
basics
of
office
scripts,
which
is
a
new
feature
in
excel
for
web.
That
allows
end
users
to
automate
their
tasks
by
recording
the
scripts
by
recording
their
actions
into
scripts
and
playing
it
back
or
editing
the
scripts
to
customize
your
your
automation
needs
so
first
of
all
office
scripts
is
a
feature
that's
controlled
through
an
admin
setting
so
over.
Here
I
have
a
separate
account.
A
A
So
that's
one
of
the
restrictions
that
office
scripts
is
only
for
users
who
have
at
least
e3
license
and
then
by
default.
This
is
turned
on
and
in
addition,
there
are
a
couple
of
other
settings
that
the
admin
can
turn
or
on
or
off,
which
is
the
ability
to
share
scripts
among
the
organization
users.
The
second
is
to
allow
access
to
office
scripts
as
part
of
the
power
automation,
which
is
a
way
to
which
is
a
way
for
our
users
to
automate
their
workflows
in
an
offline
mode.
But
so
those
are
the
few
other
settings.
A
Now
I
in
here
on
the
page,
I've
given
a
link
to
the
official
documentation
page
and
as
part
of
that
there
is
another
section
called
troubleshooting
basics,
and
in
here
there
is
a
section
dedicated
to
why
you
may
or
may
not
see
the
automate
tab.
So
if
you
don't
see
it
even
with
the
admin
settings
turned
on,
do
check
that
out.
There
are
a
few
couple
of
browser
settings
that
might
prevent
you
from
accessing
it
all
right.
A
So
all
right!
So
next,
let's
talk
about
the
the
core
features
of
office
scripts.
So
the
first
one
is
the
record
actions.
It
opens
a
task
pane
and
any
changes
that
you
make
here
gets
recorded
and
you
can
stop
recording
when
you're
done
and
see
the
output
and
the
output
is
produced
in
the
form
of
a
typescript
language.
A
A
It
allows
the
user
as
they're,
interacting
with
the
script,
to
be
familiar
with
the
type
of
variables
they're
dealing
with
what
the
shape
of
an
object
or
what
type
a
function
might
be
returning.
So
it
makes
it
really
easy
to
make
modifications
avoid
errors
that
otherwise
might
be
hard
to
debug
or
discover,
and
the
key
benefit
the
typescript
brings
is
that
as
you're
authoring
making
changes,
you
can
detect
such
errors,
so
it
cuts
down
your
development
time
to
be
proficient
in
office
scripts.
I
think
some
basic
understanding
of
javascript
is
required.
A
The
code
editor
does
provide
a
easy
way
to
interact
with
it
and
the
the
record.
The
recorder,
outputs
and
the
script
with
kind
of
comments
like
this,
so
it's
easy
to
follow
along,
but
as
you
begin
to
make
changes
just
knowing
what
changes
you're
making
just
having
really
basic
understanding
of
javascript
would
help
you
don't
really
need
to
be
an
expert
as
such,
because
you
can
kind
of
slowly
build
on
top
of
your
core
skills
and
then
learn
along
the
way.
A
So
I
you
know
don't
be
put
off
by
the
fact
that
you
may
not
know
javascript
just
sort
of
begin
to
interact
with
it
and
you
know
just
use
some
of
the
website
that
I
mentioned
here
and
there's
tons
of
resources.
Online
javascript
is
by
far
the
most
popular
language.
So
it's
quite
easy
to
get
started
out
with.
A
So
I'm
not
going
to
spend
a
lot
of
time
on
the
recorder,
because
it's
quite
easy,
as
you
can
see,
to
record
and
see
the
script
which
is
the
output
and
then
you
know
just
simply
run
the
script
when
you
run
the
script.
It
just
runs
right
here
and
then
it
does
its
thing
and
you
can
also,
if
you
have
any
kind
of
display
statements.
For
instance,
let's
say
I
want
to
display
it
done.
A
It
comes
out
in
the
form
of
an
output
pane
here
once
it's
completes
running,
and
this
is
one
way
to
kind
of
you
know
debug
information
or
if
you
want
to
just
showcase
some
some
output
to
the
user.
That's
one
way
of
doing
it,
and
so
let's
go
into
a
little
bit
more
details
about
the
code,
editor
itself.
A
So
when
I
launch
the
code
editor,
it
shows
me
all
the
scripts
that
I
own
or
I
have
created
or
recorded
and
edited,
and
each
of
these
scripts
carry
a
name
by
default.
You
get
like
script
some
number,
but
you
can
always
make
change
like
you
can
go
in
here
and
make
give
it
a
new
name
and
the
script
themselves
are
not
part
of
the
excel
file.
So
that
is
a
key
thing
to
remember.
The
files
themselves
are
stored
in
a
folder
in
your
onedrive,
for
business
is
a
user.
A
So
it's
under
my
files,
documents,
office,
scripts
folder
and
this
one-to-one
relation
between
the
file
that
you
see
here
that
has
a
custom
extension
called
osts
and
the
scripts
that
you
see
in
the
editor
as
an
end
user,
someone
who's
interacting
with
office
scripts
using
office
scripts.
You
don't
really
need
to
worry
about
where
the
scripts
are
stored
and
how
they're
managed
the
code
editor
does
everything
for
you.
A
You
only
need
to
know
that
the
files
are
not
stored
in
excel
file.
So
that's
sort
of
a
key
difference
compared
to
how
vba
macros
are
which
which
is
actually
stored.
Part
of
the
workbook
itself
so
and
the
files
themselves
are
really
type
skip
files
on
the
on
your
onedrive.
A
They
carry
a
special
extension
because
it
contains
some
additional
metadata
that
office
scripts
requires,
but
you
don't
need
to
deal
with
this
file
directly
on
the
on
the
drive
you
can
just
directly
edit
and
save
and
manage
all
through
the
the
code
editor
all
right.
So
next
thing
is
so
when
you
go
into
edit
one
of
these
scripts,
you
will
see
that
the
the
code
editor
offers
sort
of
full
editing
capabilities.
A
What
I
mean
by
that
is,
you
can
edit
you
can
navigate
around
you,
can
search
and
replace
and
because
each
script
is
like
one
full
file.
There
isn't
anything
else
that
you
need
to
think
about
in
terms
of
hey.
Is
this
calling
another
script
or
another
file,
so
all
is
contained
in
a
single
file
and
the
editor
makes
it
easy
for
you
to
navigate
around
the
one
cool
thing
feature,
because
it's
this
typescript
language?
It
offers
something
called
intellisense
or
it's
really
kind
of
fancy
name
for
chord
completion.
A
If
I
have,
if
I
have
a
variable
and
that's
defined
as
a
type
for
instance,
here
I
have
a
workbook
which
is
an
argument
into
the
main
function.
It's
defined
as
a
workbook
object,
which
is
really
the
top
level
object
within
the
object
model.
A
I
can
just
type
that
variable
and
then
press
dot
here,
and
it
comes
up
with
all
the
other
methods
that
that
function
that
object
offers.
So
let's
say
I
want
to
add
a
table.
I
pick
that
and
then
I
can
open
parenthesis
and
see
hey
to
add
a
table.
You
need
an
address
variable
which
is
of
type
string
and
it
r
you
can
also
use
range
and
it
takes
a
second
parameter
called
hash
headers,
which
is
of
type
boolean.
A
So
all
of
this
is
driven
through
through
the
intelligence,
and
you
can
discover
your
way
around
by
simply
just
learning
how
to
read
this
intellisense
you'll
also
find
some
helpful
description
here.
Another
way
to
learn
more
about
like
a
method.
So,
as
you
type
along
the
intellisense
keeps
the.
A
As
you
can
see
the
the
it's
underlined,
the
current
argument
that
I'm
typing,
so
let's
say
you
know
a1
through
c4
and
then,
when
I
press
the
comma
for
the
next
argument,
it
highlights
hey.
Your
next
argument
is
of
type
asset,
as
I
type
boolean.
So
let's
say
I
press
the
like
something
incorrect
argument.
It
highlights
saying
hey:
this
is
an
invalid
argument.
A
It
expects
an
argument
of
type
boolean
but
you're,
giving
me
something
that's
different,
so
so
this
is
sort
of
what
I
mentioned
earlier
about
typing
that
typescript
offers
and,
and
it
helps
with
development
time
work.
So
I
I
can
correct
myself
and
I
don't
really
need
to
wait
till
I
run
to
discover
that.
Oh
I
passed
the
wrong
argument.
It
actually
helps
as
you're
developing
the
you
know
that
I've
given
links
to
two
files
here,
one
is
for
mac
os
another
one
for
windows.
A
It
includes
some
of
the
shortcut
keys
that
I
find
you
know
it
hit.
It
has
like
a
compilation
of
all
the
shortcut
keys
that
the
editor
offers
and-
and
it
looks
like
this-
you
can
use
this
to
kind
of
familiarize
yourself
with
the
basic
interaction
with
the
editor,
the
things
like
basic
editing,
navigation
search
and
replace
the
multi-cursor
selections.
I
think
these
four
sections
will
help
you
navigate
yourself
around.
A
I'm
going
to
show
a
couple
that
I
use
the
most
beginning
with
you
know,
search
and
replace.
I
mean
sorry
just
search.
Okay,
do
control
f
and
I
can
find
a
variable
and
then
I
can
use
these
to
go
back
and
forth
in
the
file.
A
You
can
also
replace
your
string
and
then
just
replace
directly
within
here.
The
other
thing
I
use
is
the
commenting
feature
so
on
a
single
line
or
a
multi
line
like
this.
I
can
do
a
command
or
control
in
windows,
control
forward,
slash.
You
know
you
can
toggle
back
and
forth.
So
that's
that's
quite
helpful.
A
Another
one
I
use
is
to
select
all
variables
or
all
all
the
arguments.
Sorry
all
the
names
and
make
a
change
directly.
So,
let's
say
target
table
name
is
a
variable
name.
A
As
long
as
the
cursor
is
on,
or
I've
selected
it
I
can
do
control
uppercase
l
and
it
will
select
all
the
instance
of
that
throughout
the
script,
and
I
can
make
change
directly
here.
Let's
say
instead
of
target
table
name.
I
just
want
to
call
it
target
table
and
you'll
see
that
it's
making
changes
in
in
both
places-
and
I
can
just
hit
escape
and
come
out
of
that
multicurser
selection
mode.
A
So
I
find
that
useful.
The
right
click
also
offers
some
some
core
features
that
you
can
also
use
and
yeah.
So
I
think
the
more
you
interact
you'll
become
familiar
and
then
you'll
start
referencing.
This
shortcut,
keys
and
you'll
have
your
own
sort
of
favorite
set
that
you
will
end
up
using
quite
often
and
then
through
that
you
can
cut
down
your
time
as
you,
edit
and
navigate
around
all
right.
So
I
think
I've
covered
most
of
the
basic
aspects.
A
A
So
hopefully
this
will
help
you
kind
of
get
started
and
and
if
you
have
any
other
questions
or
want
to
see
some
other
demonstration,
please
do
leave
a
comment
in
the
video
and
that
will
help
me
understand.
Where
sort
of
you
know
the
next
opportunity
areas
for
me
to
work
on
all
right
thanks
for
watching
and
hope,
you
hope
you
try
it
out.
Thank
you.