Converts bat file into compatible VBA string.

psbat2vba.rb

#!/usr/bin/env ruby

content = File.open(ARGV[0]).read
# sub escaped double quote for single quote
content.gsub!(/\\\"/, "'")
# sub double quote for decimal double quote
content.gsub!(/\"/, '" & Chr(34) & "')
# add cmd.exe for execution
content = '"cmd.exe /C ' + content
# split every 200 chars and then rejoin with newline and string continuation
content = content.scan(/.{1,200}/).join("\" & _\r\n\"")
content += '"'
puts content