DALLASCAO.COM

Site of Cao Shouguang, English to Chinese translator

Excel Invoicer

Excel Invoicer
If you look for a simple and straight-forward invocing tool. Try Excel Invoicer. It’s an excel file embeded with VBA. You simply need to fill the ‘clients’ tab with clients information, and and then the clients drop-down is shown in the ‘jobs’ tab. After filling in the details of a job, a invoice number is […]Read More

Word Macro VBA: Capitalize 1st letter of each line

Word Macro VBA: Capitalize 1st letter of each line
Don’t miss out the translator’s productivity tool that can genuinely increase your translation speed and quality: GT4T!! Check it out here: GT4T website Convert: My name is ABC - I am from XYZ -he works on a word document 1. hello there to: My name is abc - I am from xyz -He works on […]Read More

Excel VBA: move matching rows to another sheet

Excel VBA: move matching rows to another sheet
This VBA moves my paid jobs in my job list sheet (sheet1) to the sheet named “history” (sheet4). If the value of sixth column (Column F) of a row in sheet1 is “closed”, that row is then moved to the end of sheet4. Sub Button_Remove_Closed_Click() With Sheet1 ' For Each rw In .UsedRange.Rows ' ' […]Read More

Word VBA: randomize paragraphs

Word VBA: randomize paragraphs
Sub ran_para() n = ActiveDocument.Paragraphs.Count ReDim a(1 To 2, 1 To n) Randomize For i = 1 To n a(1, i) = Rnd a(2, i) = i Next For i = 1 To n - 1 For j = i + 1 To n If a(1, j) > a(1, i) Then t = a(2, i) […]Read More

SSL certificate chain order

SSL certificate chain order
Contrary to what you may find on the Internet, the trust chain of ssl certificate is actually from BIG to small. It may not be matter to some browsers but matters to others. I installed the chain in reverse order but chrome and IE don’t complain. Firefox is more picky. The merge command line goes […]Read More