Vbs won’t launch ‘1234_1.xls!RunForVBA’

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading...
Go back to All Questions Login or Register
586 views
0

Dear Sir, I first want to congratulate you for all the awesome work.
I am trying to make your VBA multithreading tool work. I was very impressed by the code.
However I have a bug at one stage, that I don’t explain myself.

After creating the xls and the vbs, the program tries to launch the VBS via the instruction
wsh.Run """" & sFileName & """"

However, at this stage the VBS isn’t able to trigger the RunForVBA macro in the phantom workbook

I tried several stuff, trying to swap everything to xlsm. I verified that the VBA project is accepted in the macro options.

I would therefore be very grateful for any clue about this issue.

Regards
Damrick

0

Hi Damrick, great! Yes the VBA Multithreading Tool has some overhead indeed.

Read more here about how VBA Multithreading compares against other multithreading capabilties like VBscript and C#.NET.

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match