Shell command

[BryceVBA]

Hello,

I'm using the shell command to run a VBscript in my VBA. I'm getting the error Variable not defined.

Please Login or Register  to view this content.

The compiler thinks that I'm trying to define x, but this is how the function worked I thought.
Can someone explain?

[YasserKhalil]

May be there is this statement at the first of module
Option Explicit
Remove this line or it is better to declare x in this way

Please Login or Register  to view this content.

[BryceVBA]

May be there is this statement at the first of module
Option Explicit
Remove this line or it is better to declare x in this way

Please Login or Register  to view this content.

Yep, worked like a charm. Thanks!!

[YasserKhalil]

You're welcome. Glad I can offer some help