Working with Progressing

Sometimes, we might get a report with a column, which people "know" they are date but Excel not. It is very common especially as the file is from other notions. We can only use "format" or press "Enter" again in the cell to make Excel know them.

Just 'couse I had taught someone at work. Record this since I didn't know how to do it two years ago. (Excel, you are an easy to use, but hard to remember tool with a lot of "tips" hidden :(  Haha~~) 【中文】 因為日前在工作上剛好需要教人這功能，順便記錄下來，畢竟兩年前的我也根本不知道這功能怎麼用。 （題外話：Excel您真是簡單好用、但不易記得的好工具，但卻有一堆隱藏撇步啊～）

As I wrote in the last post, we can setup "hotkeys" for some macros (VBA Sub or Function) in Excel. It avoids the needs to create buttons or setup events in objects just to trigger those. It also brings the "actions" to other Excel files you have also opened.

When processing data in Excel (especial inputing values & outputting as reports), we might require (sometimes just prefer) some cells with all upper case letters (ex: ABC instead of Abc). In Word, we have a function to do so in the toolbar. In Excel, can you expect us to replace one letter by another?

Following the previous post , I apply the application, 7z ( http://www.7-zip.org/ ), instead this time. The reason is obvious: sometimes our work environment might not allow us installing WinRar. The major differences are 7zip doesn't support auto-seed in parameter (in another word, 7zip will replace the file with the same file name because of using "a" in parameter). Therefore, I have to get the "seeds" from current time. 7zip will show the detail during the compressing process (i.e. print out every file name). Thus I use the command script to output the detail into a TXT file, log.txt.

There is one daily task from my colleague that she has to input a lot of values from Word files. The content of Word files is in simple form (table-like) format. However, the providers refused to provide in Excel files, which have further using possibility. So she would print out Word files in hard copy and input values into a fixed formatted Excel file.

這幾天都在嘗試用「金融憑證」進行網路綜所稅申報作業，用了我刻意去辦得金融憑證，卻始終無法成功，沒想到結論居然這麼「機車」！ 明明告訴你要檢查是否為最新版的程式，檢查的結果也都是如此，但卻一直發生下面的問題「下載失敗，可能為網路連線狀況異常所致，請重新執行下載作業!!」。