How to call VBScript from excel macro's

[rameshmsmr]

HI, I need some excel vba examples, where with in the VBA code(Excel Macro) i could call a VBScript and will get some values like filename and directory information from the vbscript and assign it to the variables in VBA code.
The basic requirement here is, I need to assign dynamic values(basically file paths and filenames) to the variables in Excel macros. I dont want to go in to the macros each time i change the path, so if we can assign those values through the VBS then it would be easy assign and change the values.
Thank you in advance

 

[Jaafar Tribak]

Hi and welcome to the board.

What VBScript do you have ? You know that you are probably able to do most VBScript operations with VBA and from VBA without the need to have a seperate VBS file.

 

[rameshmsmr]

I need to assign dynamic values(basically file paths and filenames) to the variables in Excel macros. I dont want to go in to the macros each time i change the path, so if we can assign those values through the VBS then it would be easy assign and change the values.

 

[Jaafar Tribak]

I need to assign dynamic values(basically file paths and filenames) to the variables in Excel macros. I dont want to go in to the macros each time i change the path, so if we can assign those values through the VBS then it would be easy assign and change the values.

I am afraid the code will have to be edited each time the file paths change. You could get the File paths from the users via some kind of UI such as GetOpenFilename and then assign the return values to the variables.

 

[rameshmsmr]

In my case the users are no where responsible for specifying the input files. What i wanted is when i want to change the paths or file names, i should not go in to the excel macros and change the paths, rather its easy to change in the background VBS file if it is internally called in the Vba.

 

[Jaafar Tribak]

In my case the users are no where responsible for specifying the input files. What i wanted is when i want to change the paths or file names, i should not go in to the excel macros and change the paths, rather its easy to change in the background VBS file if it is internally called in the Vba.

No. It is not easier than changing the paths in VBA plus you will still need to edit the VB script each time the paths change.