@@analysiscloud Exactly! Isn't that strange, they ban Office Scripts but not VBA, go figure 🙄 It seems to me they just always ban the latest thing that they don't understand and know they don't have the knowledge to support it yet.
This does not explain how to address Excel worksheets in different locations - from different locations. We have had for many year VBA based applications that are all no broken since IT forced Sharepoint/Team on us. For example, in one our Excel based tools looks at specific sheet in another workbook located in a different department and asks the used to confirm that it is the correct sheet before copying the data and processing it. This requires identifying the current sheet in the external Workbook and, if the user wants another page, moving to another sheet before the user accepts it. This is only the beginning. Our tool requires the user to click on only two button (other than the sheet selection confirmation in a dialog box). I am searching how to understand file paths in Sharepoint.
Here is the info about the three actions from the Desktop flow in descriptive form: 1. Launch Excel (the paramters are "Launch Excel: "and open the following document" Document path: https: path to the PATriggeredVBAMacro.xlsxm file on SharePoint Make instance visible: True. Open as read only : False. Variable produced : ExcelInstance) 2. Wait 5 seconds 3. Close Excel (the Parameters are Excel instance : %ExcelInstance% Before closing Excel: "Save document")
What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?
This is awesome! My company disabled Office Scripts citing security concerns. This will be a great alternative.
VBA is far far more dangerous than Office Scripts. But you can bet your bottom dollar that your IT dept has NOT banned that! 😞
@@analysiscloud Exactly! Isn't that strange, they ban Office Scripts but not VBA, go figure 🙄 It seems to me they just always ban the latest thing that they don't understand and know they don't have the knowledge to support it yet.
Excelent!! Thank
What happen if the computer is turn off, still run the vba code?
Great video! I have a large vba file (10MB) that I would like to use as a calculator online as a web app . Is this possible in onedrive or sharepoint?
This does not explain how to address Excel worksheets in different locations - from different locations. We have had for many year VBA based applications that are all no broken since IT forced Sharepoint/Team on us. For example, in one our Excel based tools looks at specific sheet in another workbook located in a different department and asks the used to confirm that it is the correct sheet before copying the data and processing it. This requires identifying the current sheet in the external Workbook and, if the user wants another page, moving to another sheet before the user accepts it. This is only the beginning. Our tool requires the user to click on only two button (other than the sheet selection confirmation in a dialog box). I am searching how to understand file paths in Sharepoint.
Can I run this 24/7 non stop
Can you please share the power automate code ? I mean you can copy paste the whole thing and share
Here is the info about the three actions from the Desktop flow in descriptive form:
1. Launch Excel
(the paramters are "Launch Excel: "and open the following document"
Document path: https: path to the PATriggeredVBAMacro.xlsxm file on SharePoint
Make instance visible: True.
Open as read only : False.
Variable produced : ExcelInstance)
2. Wait 5 seconds
3. Close Excel
(the Parameters are Excel instance : %ExcelInstance%
Before closing Excel: "Save document")
no idea what this is all abt , thought i can automate the to extract excel file, and copy n paste to sharepoint
What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?
hi may i know did you already solved this problem? i am currently having this problem in shared files
Same here, any solution please share
@@niqsantos Not yet!
bgm 😭
Hi! I am replacing the background music for my next video today!