Use office script on iPad

Question

Hello, 

I have translate a VBA script in office script on Excel 365. 

When I have create the office script the file was recorded on my one drive documents folder in a sub folder Office Scripts. 

My Excel files is save on my one drive too. 

I use my Office 365 business user to connect on my one drive and for my Office 365 licence. 

On my pc all work well,  I open the workbook from my onedrive and I view my custom script in the  autmation tab in Excel.  I have make a shortcut like a button in my sheets and when I click on it the script execute and copy the data from tje sheet 1 to the sheet 2. 

If I try to connect on my office.com account and use the Excel Web apps all work too. 

I view my custom script and if I click on my button all execute without error from the cloud. 

I have try with Safari web browser of the iPad. 

When I connect on my account Office.com  I always view my Excel files and I can open it on the Excel Web apps on the website.  This time the automate tab is available on my file via Safari. 

After few minutes, in the automate table, I view all the default office script, but I dont view my custom script in the automate tab section like I view on the pc. 

I view my shortcut button on my sheet 1 and I could click on it. 

A message like Excel try to execute the script pop on the screen and nothing comes after. 

I could close the message ribbons with the X without error. 

If I wait enought I finish by receive a warning message like I dont have permission to run office script, my administrator have possibly block office script function, the document could be from another organisation so I could not execute scripts. 

If I click on new script button, the script editing windows open but dont finish to load and present a unknow error. 

I could maked modification and open the file on my pc  with the Excel local application and the Excel web application, but it's maybe a bug with the iPad or I need to copy the office script file locally on the ipad the make it availaible ? 

Any helps is welcome. 

Marc-Etienne

Answer 1

Ok I have copy my post and open a new question on the other forum.

Thank you.

Answer 2

Hi,

I suggest you post this thread to Excel for iPhone or iPad forum:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_unknown-mso_OPiOS

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.