Generate .VBS script with a .VBA code

[Judgedread]

Good afternoon,

My first post on the famous Mr.Excel.com. Hope I would post a question that has been answered thousands times.

I need to create a .VBS document/script from an excel sheet. Is there any easy way to do a "save-as" and choose the .VBS extension ?

Once the .VBS is created, I would like my macro to open it so it perform automatically an extraction from SAP system. I'll then import this extraction in my excel document.

But right now my main concern is : is it possible to create a .VBS document from excel using vba code ? if yes how ?

Many thanks guys for your help on that !
Take care
Judge

 

[shg]

Just save it as a text file with a vbs extension.

 

[shg]

ActiveSheet.SaveAs "C:\myPath\myFile.vbs", FileFormat:=xlTextWindows

 

[Judgedread]

Works great many thanks !

I'll now work on how to run this .vbs file and import the result after the vbs is finished.

Thanks again,
Cheers

 

[shg]

You're welcome.