Create folders from an Excel sheet
Let’s say that you’re working on a project and you have an Excel sheet that contains 100 names. For part of your project, you need to create a folder for each of the names. If you don’t want to create a new folder and name it 100 times, I have a very simple solution for you.
In this example, we’re starting out with this:
Step 1. Highlight the “A” column and select “Insert”.
Step 2. In the new “A” column type the letters “md” into the first row.
Step 3. Save the Excel sheet as a CSV (Comma delimited) file.
Step 4. Right-click on the new .csv file and choose to open in Notepad.
It should look like this:
md,folder1
md,folder2
md,folder3
and so on…
Step 5. Click on “Edit” and then select “Replace…”.
Step 6. Replace every comma with a space.
Step 7. Save the file as “filename.bat” and change the file type to “All Files”.
(This makes the file executable.)
Step 8. Double-click on the new .bat file.
Note: The new folders will be created in the same directory that the .bat file is in. So, if you don’t want 100 folders on your desktop, don’t run the .bat file from the desktop.
Free Codeweavers Software For All
The Codeweavers “Great American Lame Duck Presidential Challenge” has ended in surprise and free software all day Tuesday (October 28, 2008) at the Codeweavers site.
When I actually got the site to work, they said that they removed the homepage because of the amount of traffic, but they had the download links active.
Give it a try here: Codeweavers
After you download the software, you have to enter your email address on a different page to get a serial number. I had to try that about ten times before it worked.
Good luck!
Is MySpace selling my email address?
This morning, while I was playing around on MySpace, I noticed a new banner image at the top of the page.
I’m not sure why it got my attention, but it did. Maybe it was flashing or something. Anyways… After a few minutes I checked my Hotmail account (same as MySpace login). I noticed an email with this subject line: “Flush Out 20 Pounds with Acai Berry”. The email was from acaiberry@AIDENTOKEN.COM. So, I went to aidentoken.com to see what it was. This was their homepage:
Please note you have received this email because you are currently on our mailing list.
Our records indicate that you have requested for information from one of our partners or affiliates. By entering your email address in the box below will promptly remove you from our lists and you will no longer receive emails from us or our affiliates.
I wonder if MySpace is one of their “partners”?
National Breast Cancer Awareness Month
As you may or may not know, October is national breast cancer awareness month. I know I’m a few days late, but I just found this image today and I thought it deserved to be posted.
National Breast Cancer Awareness Month
Homepage Advertising – MySpace Vs. Facebook
This morning, when I went to check my Facebook account, I noticed that there’s a really big difference between MySpace’s homepage and Facebook’s homepage. When comparing the two pages, the first thing I noticed on MySpace’s homepage was the ginormous flash commercial that spanned the width of the layout. There’s also many smaller ads tucked away throughout the page. On Facebook’s homepage, there doesn’t seem to be any advertising at all. Facebook’s homepage doesn’t require any vertical scrolling either when viewing as 1024×768. Check out the screenshots below:
Let’s play a game… Click on the MySpace screenshot and see if you can count the number of advertisements. Post your guess as a comment.
Get Notified When We Post Updates
