I want to use a short batch file in an Excel macro. I know that I must use Chr(34) to designate a double quote in the code. What other special characters must I use the Chr() to designate the character without interferring with the VBA coding?
i have attached the batch file. It was written by billprew
to solve another issue I was having.
Any help on converting this batch file to Excel VBA is appreciated.
if exist "%DestFile%" del "%DestFile%"
for %%A in ("%BaseDir%\*.csv") do (
for /F "tokens=* usebackq" %%B in ("%%~A") do (