How to execute Macro with arguments

I looked at it and seems some of the Excel features are not working correctly.
.Copy and .Select for example are not working. However, .Value is working.

So this is strange.

If I find a workaround for this I will let you know.


Here is a snippet of one of my .vbs files on a part that creates an Excel object then creates a new workbook
image

As you can see it’s similar to VBA but with a few differences to some syntax; one key difference is you can declare variables in one line. Also, I would recommend using a VB edit tool; one free one is vbsedit. For resources on how to do something like Open or Save for example, there are many answers online that can be found through Google.
https://www.google.com/search?q=vbscript+help&rlz=1C1GGRV_enUS751US751&oq=vbscript+help&aqs=chrome..69i57.4544j0j1&sourceid=chrome&ie=UTF-8

Although, it does require a little bit of knowledge on how loops and if statements can be used, but it’s mostly logic anyway :stuck_out_tongue:

Hope this helps answer your question on VB scripting.

And, I’ll get back to you if I find any answers on the problem with Excel Macro.

Regards.

1 Like