Excel Macro - Update Worksheet with help of text file

[SandeepKumar]

Hi All,

I need excel macro to update Excel worksheets with commands or excel worksheet names provided in the text file.
for Example in text file,




PutText value ="blank" cell = "F26" sheet = "SERVICE_RENAULT_2"
PutText value ="blank" cell = "F27" sheet = "SERVICE_RENAULT_2"
PutText value ="blank" cell = "F28" sheet = "SERVICE_RENAULT_2"
PutText value ="blank" cell = "F29" sheet = "SERVICE_RENAULT_2"





I want to put red color on the mentioned cells that are provided in the text file.

Please anyone could provide the solutions for this ?

Many thanks in Advance to all..</puttext></puttext></puttext></puttext>