AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Download video lawak batak 3gp11/14/2022 ![]() ![]() ![]() The story presently narrates how Goddess Shakti's human incarnation Sati, grand daughter of Lord Brahma and daughter of Prajapati Daksha (a staunch devotee of Lord Vishnu) and Queen Parvati is reunited with Shiva after Shakti was separated from him for the benefit of the universe. It is an elaborated narration of Shiv and Shakti's separation and union, their journeys together, and how that affected and shaped the world. So, I have this code: Sub RunBAT Set obj = CreateObject('Wscript.Shell') obj.Run Chr(34) & 'X: Test ' & 'Termination Reports Scripts ' & 'ExecuteTerminations.bat' & Chr(34), 0, True Set obj = Nothing End Sub Which gives me an error: Permission Denied Then there's this code: Sub WriteAndRunBatFile Call Shell('X: Test Termination Reports Scripts ExecuteTerminations.bat') End Sub Which gives me the error: Invalid procedure call Any and every single code sample that contains the 'Shell' command gives this error.This is the story of Lord Shiva and Goddess Shakti. ![]() Then I thought perhaps it would be easier to execute the next set of scripts (also in a batch file) from within a macro. So my initial thought was to test if the workbook is open, if it is, delay the execution of the next script by a minute or so, then test again and again. The batch file I currently have, calls all the scripts one by one, and the very last script opens one of the xlsm workbooks which contains a few macro's in it - and here is where the issue is - There are still scripts to be executed but they can only be executed once this workbook has executed all its macros. These scripts and macros work great, however, I would like to make a the process even easier for the users by running a single batch file that will systematically execute the scripts and macros. ![]() I have been attempting to automate a series of administrative events for some of the users where I work by creating scripts and macro's and so on. ![]()
0 Comments
Read More
Leave a Reply. |