They are, to open the file and try and execute the macro using a call function, and having the macro within the VBS File (I have made all the changes to the macro I know of to try and make it VBS) and the other method is to use the VBS file to create a new module and add the Macro code into the file.
I have researched 2 methods and can't get either to work. After doing some research, I have found out this could be possible via a VBScript file. What I want to create is a file that will allow me to run this macro without having to copy and paste every time. Obviously the macro will not be in this file. However the issue comes in when I need the macro to be run in a new download. I have written a macro in excel that carries out the actions I need.
0 kommentar(er)
