Create a folder on your c: drive called 'All csv files' and place all of your .csv files inside.
Open notepad and add the text below
cd C:\All csv files
copy *.csv Merged.txt
Save the text file and changed its extension to .bat 'merge.bat'.
Double click the file and you will see that a txt file is created in the C:\All csv files folder called 'Merged.txt' with all your consolidated information inside !.
Showing posts with label notepad. Show all posts
Showing posts with label notepad. Show all posts
Sunday, 27 September 2009
Open multiple web pages at the same time using a batch file
Recently whilst working on a customer's PC I noticed that when they booted up they would manually open several webpages. I asked the customer two questions, do they do that every time they use the PC and if so would they like me to show them an easier way.
As it happens the user did repeat this process everytime they worked on the PC and she was more than willing for me to show her how to get the same result with two clicks !.
Solution
1. Open up notepad
2. Type the following (substituting the web addresses you require) :
start iexplore.exe -new http://www.supportingtech.blogspot.com/
start iexplore.exe -new http://www.bbc.co.uk/
start iexplore.exe -new http://www.facebook.com/
3. Save the file to your pc e.g. your desktop.
4. Rename the file to have a .bat extension instead of .txt.
5. Double click the file and you will see that the 3 websites will now open up
As it happens the user did repeat this process everytime they worked on the PC and she was more than willing for me to show her how to get the same result with two clicks !.
Solution
1. Open up notepad
2. Type the following (substituting the web addresses you require) :
start iexplore.exe -new http://www.supportingtech.blogspot.com/
start iexplore.exe -new http://www.bbc.co.uk/
start iexplore.exe -new http://www.facebook.com/
3. Save the file to your pc e.g. your desktop.
4. Rename the file to have a .bat extension instead of .txt.
5. Double click the file and you will see that the 3 websites will now open up
Subscribe to:
Posts (Atom)