Automate

I got my script with multiple Excel sheets working!!!!  Now, I want to take the template from a working production file, and use it for my template since it has all the fields on the Excel sheet needed.  I opened my script, then opened the template I wanted, unassigned the old script and associations from the hidden WS tab from the template.   Now, when I want to change the mapping in the script to the new template it won't let me.  How, can I change the script mapping to new?  See attached, and thanks!

------------------------------
Eric Sandberg | Sr Financial Systems Analyst
Walt Disney Company - Studio Entertainment | 818-544-9898
------------------------------

Hi Eric,

Please go to the Expert view in the script, click on the loop to open the loop properties screen and select the new Excel sheets you want to use for the master sheet and line item sheet. After you do this, you should be able to remap it to the new workbook.

Thanks,

------------------------------
Maria Simpson | Solutions Engineer
Winshuttle North America | 4255276647
------------------------------

Original Message:
Sent: 12-11-2019 20:53
From: Eric Sandberg
Subject: Updating Loop Command to Another Worksheet in Script

I got my script with multiple Excel sheets working!!!!  Now, I want to take the template from a working production file, and use it for my template since it has all the fields on the Excel sheet needed.  I opened my script, then opened the template I wanted, unassigned the old script and associations from the hidden WS tab from the template.   Now, when I want to change the mapping in the script to the new template it won't let me.  How, can I change the script mapping to new?  See attached, and thanks!

------------------------------
Eric Sandberg | Sr Financial Systems Analyst
Walt Disney Company - Studio Entertainment | 818-544-9898
------------------------------

I was able to update the loop command, and now that part works.  However, ​the rest of the mapping cells are off.  I updated some 300 of them by pasting the sheet to each row, but now I still have over a thousand lines to update.  Any ideas to mass update each line of my script???



------------------------------
Eric Sandberg | Sr Financial Systems Analyst
Walt Disney Company - Studio Entertainment | 818-544-9898
------------------------------

Original Message:
Sent: 12-17-2019 11:12
From: Maria Simpson
Subject: Updating Loop Command to Another Worksheet in Script

Hi Eric,

Please go to the Expert view in the script, click on the loop to open the loop properties screen and select the new Excel sheets you want to use for the master sheet and line item sheet. After you do this, you should be able to remap it to the new workbook.

Thanks,

------------------------------
Maria Simpson | Solutions Engineer
Winshuttle North America | 4255276647

Original Message:
Sent: 12-11-2019 20:53
From: Eric Sandberg
Subject: Updating Loop Command to Another Worksheet in Script

I got my script with multiple Excel sheets working!!!!  Now, I want to take the template from a working production file, and use it for my template since it has all the fields on the Excel sheet needed.  I opened my script, then opened the template I wanted, unassigned the old script and associations from the hidden WS tab from the template.   Now, when I want to change the mapping in the script to the new template it won't let me.  How, can I change the script mapping to new?  See attached, and thanks!

------------------------------
Eric Sandberg | Sr Financial Systems Analyst
Walt Disney Company - Studio Entertainment | 818-544-9898
------------------------------

Hi Eric,

I'm glad you were able to switch to the other workbook. You can still highlight several rows and map like you normally would (drag and drop), but if they're not in order, like my example below for column A, B, C, D, etc., then you will need to map each one individually. 


------------------------------
Maria Simpson | Solutions Engineer
Winshuttle North America | 4255276647
------------------------------

Original Message:
Sent: 12-18-2019 14:27
From: Eric Sandberg
Subject: Updating Loop Command to Another Worksheet in Script

I was able to update the loop command, and now that part works.  However, ​the rest of the mapping cells are off.  I updated some 300 of them by pasting the sheet to each row, but now I still have over a thousand lines to update.  Any ideas to mass update each line of my script???

------------------------------
Eric Sandberg | Sr Financial Systems Analyst
Walt Disney Company - Studio Entertainment | 818-544-9898

Original Message:
Sent: 12-17-2019 11:12
From: Maria Simpson
Subject: Updating Loop Command to Another Worksheet in Script

Hi Eric,

Please go to the Expert view in the script, click on the loop to open the loop properties screen and select the new Excel sheets you want to use for the master sheet and line item sheet. After you do this, you should be able to remap it to the new workbook.

Thanks,

------------------------------
Maria Simpson | Solutions Engineer
Winshuttle North America | 4255276647

Original Message:
Sent: 12-11-2019 20:53
From: Eric Sandberg
Subject: Updating Loop Command to Another Worksheet in Script

I got my script with multiple Excel sheets working!!!!  Now, I want to take the template from a working production file, and use it for my template since it has all the fields on the Excel sheet needed.  I opened my script, then opened the template I wanted, unassigned the old script and associations from the hidden WS tab from the template.   Now, when I want to change the mapping in the script to the new template it won't let me.  How, can I change the script mapping to new?  See attached, and thanks!

------------------------------
Eric Sandberg | Sr Financial Systems Analyst
Walt Disney Company - Studio Entertainment | 818-544-9898
------------------------------