VB Script to save Thisworkbook with changes

Hello All,

I have a vba macro which I need to trigger using VB script and it is working so far good, but only road block is it is not saving the thisworkbook with the changes.

I have some data which will be saved in the different sheets of thisworkbook and this works fine when run manually but when I try to run through vb script it does not save.


Below is the vb script i'm using

Please Login or Register  to view this content.

Below code which I'm using in my module to save the workbook

Please Login or Register  to view this content.

Any help would be appreciated!!!

Try this way:

Please Login or Register  to view this content.

Thanks kasan, but unfortunately this script don't even run the macro.

delete row "ExcelMacroExample"

Its strange, the code you provided does not trigger the macro at all, but if I use the older one it works fine.

Below is the code which I'm using currently and it does not work.

Please Login or Register  to view this content.