Hi - I am using an Excel Workbook in the Microsoft Office 365 platform.
I am creating Microsoft Office Script to automate a process.
I would like to set a variable in the script to a value in the Excel Workbook from a specific sheet and cell.
Example:
In the Microsoft Office Script I have the variable "RowCounter01"
In my Workbook I have Sheet ("RDate") and in the Sheet a specific cell with a value (cell "J1").
How do I code the automated script to set the RowCounter01 variable to the value in RDate, cell J1 ?
If the value in J1 is 123 then RowCounter01 would be set to 123.
Any assistance is appreciated - thank you - jerryr125
I am creating Microsoft Office Script to automate a process.
I would like to set a variable in the script to a value in the Excel Workbook from a specific sheet and cell.
Example:
In the Microsoft Office Script I have the variable "RowCounter01"
In my Workbook I have Sheet ("RDate") and in the Sheet a specific cell with a value (cell "J1").
How do I code the automated script to set the RowCounter01 variable to the value in RDate, cell J1 ?
If the value in J1 is 123 then RowCounter01 would be set to 123.
Any assistance is appreciated - thank you - jerryr125