Author Archive for WebGuru

Page 2 of 13

How to use script auto-convert all WORD files into PDF with Office 2007

Say you have a few hundreds WORD (*.doc and *.docx) files on your computer, and you need to convert them all into PDF format files. Yes, you can open them and then Save As into PDF in WORD 2007 one by one, or you can highlight all of them (provided they are in the same folder) and print them into PDF format. But you still need to click a few hundreds times mouse to answer Save As… questions within Word. Is there a way to automate it.

Hey, you might say I already mentioned this similar feature in my previous post (http://lichao.net/eblog/how-to-auto-find-and-replace-text-in-bulk-word-files-and-save-convert-to-other-format-with-script-201002475.html). But that script was mainly created for Find and Replace feature and there is a glitch in the PDF convert bonus feature. If you have Word 2007 installed on your machine, and that script will prompt you with READ-ONLY permission warning if your Word files are in 2003 version. But if you use that script on Word 2003 machine, the PDF convert feature will not work. So we need to create separate PDF convert scripts for Word 2003 and Word 2007.

Continue reading ‘How to use script auto-convert all WORD files into PDF with Office 2007′

Related posts

How to post Twitter tweets onto Facebook Fan Page Wall and Profile status update

imageAs I suggested before (see the bottom appendix part) you can easily connect your Facebook Fan Page to the twitter account. With this connection, all of your fan page status updates will become tweets and be published onto your twitter account.

Now how about the reverse or the other direction around? Meaning, can your tweets be auto published to your Facebook Fan Page Wall? The answer is YES with capital Y, although it is not as easy as the way of linking fan page to twitter.

Continue reading ‘How to post Twitter tweets onto Facebook Fan Page Wall and Profile status update’

Related posts

How to auto find and replace text in bulk Word files and save convert to other format with script

Challenge:

As I indicated in my previous post, I needed to rename thousands Microsoft Word documents based on the updated old/new catalog ID pairs.

But that was just one part of my requirement. Since these Word DOC files have the old catalog IDs inside the content which need to be updated with new IDs as well. The methods of my previous post could only resolve the file name part but not the contents.

Unsuccessful trials

I started with some existing utilities I found on the Internet but they were not working as I hoped.

1), I tried the Useful File Utility along with its free plug-in “Batch Replacer for MS Word” (Useful File Utility is a shareware which can allow you to use 15 times for free, then $29 for a single user license). It looks promising as it indicated on its web page, but it failed on me with too many un-successful replaces in a few hundreds files.

2), I was impressed with this VBA macro I found on Internet named VBA Find and Replace. But it could not work well with the Find and Replace text list. I always get an error saying my name list is not valid.

After one night’s trying, I decided to write my own script to handle such automate job.

Continue reading ‘How to auto find and replace text in bulk Word files and save convert to other format with script’

Related posts

How to rename thousands Word documents file name in bulk based on an Excel list

Challenge:

We have a few hundreds Microsoft Word documents with old catalog names as their file names. We need to rename them with these new catalog ID as their new file name.  Good thing is that we already have these old/new catalog name pairs in an Excel worksheet.

To save the time of manually changing all file names, we come up two solutions/approaches to automate the process.

Continue reading ‘How to rename thousands Word documents file name in bulk based on an Excel list’

Related posts

Install VMWare Tools on guest ubuntu linux virtual machine

I used Microsoft Virtual PC, Sun VirtualBox, and VMware Desktop to play with Linux distro in virtual environment. Later on, I got rid of Microsoft VirtualPC due to its imperfection dealing with ubuntu, and am only using Sun VirutalBox at home and VMWare at work. Today, my co-work showed me how he installed VBoxAdditions in Virtual Box to improve the guest Linux OS screen resolution. I could not help thinking I should do the same in VMWare WorkStation by installing VMWare Tools .

But when I followed the install instruction to run “vmware-install.pl” in my guest Ubuntu virtual machine, I got “vmware-install.pl command not found” message. It took me a while to figure out the reason, and it was just a simple Super User permission issue but I thought it was because of PERL installation on ubuntu.

To save you all valuable time in the similar situation, I am sharing here with the detail steps to install VMWare Tools on Ubuntu Linux Guest OS in VMWare WorkStation (version is 5.5.9).

Continue reading ‘Install VMWare Tools on guest ubuntu linux virtual machine’

Related posts

Install Adobe Flash player in Firefox on xubuntu

xbuntuI installed ubuntu 9.10 on one of my laptops with GNOME desktop environment, but unfortunately it worked very slow due to the limited memory of 256 MB. So I decided to switch to xfce desktop environment. After I installed xfce on top of GNOME then remove all package of gnome, I started to have some different issues as I had in the Ubuntu GNOME environment. Today I just wanted to talk about the flash player plug-in installation on Firefox issue here.

Continue reading ‘Install Adobe Flash player in Firefox on xubuntu’

Related posts

Are you ready for Amazon ebook reader Kindle?

In my recent trip to China, I found out the paper book business is still very good. It is understandable, after all the audience pool is so huge and unlike the reading materials on the Internet you still need to pay money for the paper books.

When I mentioned e-book reader to some of my friends, they also said it would be popular too. Since it is very attractive from a huge capacity perspective. With it, you do not carry a heavy bag of books instead of packing a thin e-reader in the travel. But they said we could not see the immediate hit recently. 1), it still depends on a good hardware e-reader: multiple task (music, video etc), light and stylish; 2), not too many e-book available and the technology to protect intelligence rights, and others.

Continue reading ‘Are you ready for Amazon ebook reader Kindle?’

Related posts

What do you use Twitter for, post resignation note?

Yes, Jonathan did. The then CEO of Sun Microsystem posted his resignation note in a Haiku poem style on his twitter account today. On Jonathan Schwartz’s Twitter page, it reads

Today’s my last day at Sun. I’ll miss it. Seems only fitting to end on a #haiku. Financial crisis/Stalled too many customers/CEO no more

It is not a surprise to me. Jonathan is the person always out spoken. He set up his personal blog as one of first CEOs did that.

As oracle bought SUN, it is not unusual see he departed. Nothing to add, just say GOOD Bye, and keep your good personality in the future executive life.

Related posts

Google leaving China is just a threat

Google ChinaIt is very interesting that there are a lot of talks about Google leaving China on the Internet now (A New Approach to China). More interesting since I just came back from China and expressed my totally dis-satisfied about the Chinese Great FireWall and Internet censorship. But I really do not think Google decided to withdraw because of my complaint LOL, not the recent cyber-attacks either. My thinking is that Google’s behavior  is purely political and business oriented strategy.

As a big entity appears in Internet Cyber world, it is a very usual thing to have cyber attacks. I can say the so-called sophisticated cyber attacks to Goolge’s infrastructure (GMail, etc.)  is not the first one, and not be the last one either. Then why Google screams now? why now?! It was just “enough is enough” as it indicated, or something else?

Continue reading ‘Google leaving China is just a threat’

Related posts

Happy New Year to you all!

Dear friends, wish you have a great year of 2010. Sorry I have not updated the blog for a while since I just traveled back to China at the end of 2009.

Thanks to the damn Chinese Great Firewall, I still can connect to my own blogs even I could not connect to Twitter.comFacebook.com and other my important favorites.

I do not really feel sorry for my hometown fellowers as I did before. Even I felt pity for them to lose almost half popular web sites in the world. But you know, Chinese people is still happy in their “own” internet world. Look around the cyber cafes I ever walked in, every body especially the teenagers is HAPPY with all kind of PC Games, or online chat rooms. In China, who cares Twitter.comFacebook.com anyway, LOL.

Furthermore, without the authenticate web 2.0 services web sites, our Chinese friends can easily have some similar copy-cat web sites running inside the Great FireWall. After all, ShanZhai (means imiation) is the most popular term in the Chinese Internet right now.

So, wish all the netizens around the world a happy new Year.

Related posts

Google Enterprise Search and Apps are nice, but no, thanks

This morning, I got a meeting pop-up prompt reminding me I have a meeting with Google’s representative. I was excited since I thought we were going to talk about Free Wi-Fi cooperation (confused with the other topic with Google before). But when I sat down and had the introduction, I realized he was a local account manager from Google and he was going to talk about Google Enterprise application with us.

Which was still cool, since we had such similar interesting discussions  internally a few weeks ago anyway. Then he started to introduce 3 types of Google productions which can be sold to enterprises: Google Enterprise Search Appliance; Google Map & Earth; Google Apps.

But unfortunately we did not get much interesting on all of these offers above.

Continue reading ‘Google Enterprise Search and Apps are nice, but no, thanks’

Related posts

How to use the new Google Real Time Search

Google Real Time search is available in most English language searches. Here is how and what you can get from this new feature.

Go to Google main site, and type any keywords you would like to search. And then on the search result page, look for the Show Options on the top of your results. When you click the Expand plus sign +, you will have an extra side bar on the left of the result page.

Now, you can click the Latest option from the list, and then you will see the Google Real Time Search in play.

Continue reading ‘How to use the new Google Real Time Search’

Related posts

How to use Google Free Public Open DNS Services

As I said in my previous post, Google has introduced its own Free Public DNS services to the general public. If you used OpenDNS.org service before (208.67.222.222, 208.67.220.220), you should be familiar with what Google is going to offer.

Anyway, I still suggest you change your DNS servers from your ISP’s default ones to Google, or OpenDNS in your router instead of single computers at your home.

Here is a simple how-to for you to utilize Google’s public DNS servers in your router (I am using my ISP AT&T’s Netopia Gateway as the illustrators).

Continue reading ‘How to use Google Free Public Open DNS Services’

Related posts

Michael Jackson is the King: the No. 1 of 2009 Top searches from Google, Yahoo and BING

image What does the Google and Yahoo in common? Well, at least in 2009 yearly top searches review, they both have Michael Jackson as the top of top searches 10 in 2009.

According to just published Google zeitgeist 2009, Michael Jackson is the No.1 searched term in the whole world and No. 2 in the United States. It seems more international fans care about this king of pop than Americans, who is caring about more Twitter or Facebook, LOL.

Continue reading ‘Michael Jackson is the King: the No. 1 of 2009 Top searches from Google, Yahoo and BING’

Related posts



Get Adobe Flash playerPlugin by wpburn.com wordpress themes