Genrating the output to a .bat file from xls

[gaurde]

HI,

Through some vba code I am generating some c program script to column G in a xls file.

Example:- (below sample values are present in column G)

I am using the below script to copy the contents of the column G to a .bat file.

Please Login or Register  to view this content.

But I am getting some error, I have gone through the code multiple times but could not fix it. Anybody please tell me where I am doing wrong

Thx,
Deepti

[AlphaFrog]

Perhaps you could share what the error was and what line, if any, is highlighted when you debug the error?

For Each cell In Range("G5:G1005" & RR)
You could remove the & RR as it is not set to anything.

[gaurde]

Hi,

I have removed the &RR, when I am executing the macro I am getting error on this line.

Please Login or Register  to view this content.

Thx,Deepti

[AlphaFrog]

What is the error description?
Do you have a sheet named "Scripts"? If yes, what is in cell G5?
Do you have the folder C:\Automation ?

[protonLeah]

never mind....

[AlphaFrog]

Put the line:
Debug.Print FILENAME before the Open.. statement and see if it matches the actual file name.

The code is creating a file. I don't think FILENAME matches an existing file.

[billstpierre79]

Perhaps something like this would work?

Please Login or Register  to view this content.