Copy Contents of a text file and paste it in command prompt

Hi All,

I need a vba code to copy all contents of a input text file and paste it in a command shell.. Please help me..

Thank you.

Maybe something like:

Please Login or Register  to view this content.

Originally Posted by yudlugar

Maybe something like:

Please Login or Register  to view this content.

Hi Thanks for replying..

I used the code but getting wrong number of arguments or invalid property assignment error.. Pls help..

i am using below code

Please Login or Register  to view this content.

where rename file path is the file path from textbox.

Thanks

Please Login or Register  to view this content.

Read all method is working only for one line.. but i want it to process all lines

Hi,

no needs a command shell, just read the VBA help of Name statement !

Maybe try:

Please Login or Register  to view this content.

Originally Posted by yudlugar

Maybe try:

Please Login or Register  to view this content.

Hi,

This is also processing only one line...

With the txt file attached …

solved by changing the naming of the file from .txt to .bat and running it using Shell command.. Thanks all.