Method not valid with out a suitable object Error

[swathidas]

Hi ,

I am creating two .bat files using vb script, the first script is created based on the cell range cell In Range("K67:K87"), I am facing issue when generating second batch file, I need to execute the first batch file using the second batch file and capture the log as below.


Print Execue_Batch_load.bat > Execue_Batch_load.bat.Log 2 > &1


When I am executing the second script , I am getting a error like Method not valid with out a suitable object.

Please let me know where I am doing it wrong.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards,
Swathi

[Fettertiger]

Hi,
not sure if this was on purpose, but did you notice you have entered Execue rather than Execute (t minning) in some parts of your code?
Regards

Theo

[swathidas]

Hi,

Sorry for the Typo, I want to generate the below line using a macro.

Print Execute_Batch_load.bat > Execute_Batch_load.bat.Log 2 > &1

Regards,
Swathi

[TMS]

I think we'd need to see what's in the cells and hence what the scripts look like.

Regards, TMS

[swathidas]

HI,

The range of cells (K67:K87) has, some data load Parameters as below.

1. Monday,04/06/2012 DataLoaded 252 Records Processed.
2. Tuesday,05/06/2012 DataLoaded 252 Records Processed.
3. Wednesday,06/06/2012 DataLoaded 252 Records Processed.
4. Thursday,07/06/2012 DataLoaded 252 Records Processed.

The above range of cells I am writing to a batch file i.e through the first program to Execue_Batch_load.bat.

second batch file is a dummy batch file, which will execute first batch batch file for capturing the log of the first batch file.

Execute_Batch_load.bat > Execute_Batch_load.bat.Log 2 > &1

I tried use the above dummy statement in first batch program itself but it's giving the same error, please let me know where I am doing it wrong.

Regards,
Swathi