Hi @Sudhi Ramamurthy, I followed this successfully the other day, but today I cannot repeat it. In the 'run script' window, there is no 'sheet name' entry box, and I wrote the script as shown "GetUsedRangeAs Formulas" but it comes up with an error that the script is bad. I've tried multiple times from fresh start. Can you help, or provide another way to call the file meta-data ID like with console commands?
@suhasinimetri9792
2 жыл бұрын
Hi Sudhi Ramamurthy ,I have used get file metadata for Business user action ,but I am not able to see XLSM file. Please help on this. Thanks
@lesblack3774
3 жыл бұрын
So an Office Script can run against an xlsm file and a xlsx file. I wonder if it will run against xls, txt, csv files too! I will try it! The VBA doesn't function despite this. And the big question :-) Will it run against Word files?! :-) Answer : maybe one day?? Thanks for video.
@lesblack3774
3 жыл бұрын
In order to answer my own question I just tested against a variety of file types, csv, txt, xls95, xls97, tab delimited - ALL fail with error : "We were unable to run the script. Please try again. The script couldn't create a connection with Excel. Please try again."
@s65012r
3 жыл бұрын
Only Open XML based xlsx/xlsx files and xlsb files are supported.
@musicmania9837
2 жыл бұрын
What to write in Script?
@musicmania9837
2 жыл бұрын
How macros can be converted to office script? Please explain
@familia5d997
2 жыл бұрын
Thank you for the video. Is it possible to update a row of a XLSM file with the metadata?
@shivampandey5274
2 жыл бұрын
Hey Sudhi, Great Work man Could you please share the office script codes used in this video
Пікірлер: 12