386 reputation
21429
bio website jakesee.com
location Singapore, Singapore
age
visits member for 3 years, 8 months
seen 2 days ago

Thinking


Mar
6
comment Macros in Excel 2010 hangs
@Ahmad have you tried commenting out function calls and debug by elimination?
Mar
6
comment Copy Excel worksheet and maintain relative cell reference in formulas
the paste special values only paste the calculated values. I need the formulas to be copied over, WITHOUT WBA.xls appended.
Mar
6
comment Copy Excel worksheet and maintain relative cell reference in formulas
I already attempted to explain in my last paragraph, but i think it still wasn't clear. Yes, WBA and WBB are identical expect for one sheet in WBA. While designing that sheet in WBA, it is intended that all cell reference be relative to the sheet's workbook. The copy worksheet function appends all cell formulas with WBA, making it "absolute" and I do not want that.
Mar
6
comment Create reusable custom shapes in Microsoft Excel or even Office in general
@datatoo and Raystafarian In case you are interested, please see my edit
Feb
18
comment Create reusable custom shapes in Microsoft Excel or even Office in general
That is such a dissapointment... thanks for the affirmative. I'm going to wait a few more days before marking as answer though. Hope there's tips and advice.
Feb
1
comment Autoincrement the VLOOKUP column index in Excel
@barry yes, the input!$b$3 is a number and I am trying to match it to min-max value in the first column.
Nov
27
comment Windows 7 and UTF-8 saving and display in programs
It's just that... my answer/solution/fix is not perfect as existing files are permanantly corrupted. The "how to revive" was just to ask for a better answer that will preserve existing files. otherwise, most people will come and go, seeing that I answered my own question. anyhow, I strike of that line already.
Nov
27
comment Windows 7 and UTF-8 saving and display in programs
please see my answer if interested. Thanks for far for your help. The answer to superuser.com/q/221593/52492 was insightful and good information. Thank you.
Nov
27
comment Windows 7 and UTF-8 saving and display in programs
I opened the files originally created in Notepad++, with notepad.exe with the encoding settings as you advised. but the decoding seems to fail. still garbled text or bunch of "????"
Nov
27
comment Windows 7 and UTF-8 saving and display in programs
My experience is that HTML/PHP pages when saved with BOM does not display corrrectly with "content="text/html; charset=UTF-8". In any case, I think this is a windows bug because as i mentioned, previously it worked, just not now. Maybe someone knows a KB related to this issue?
Nov
27
comment Windows 7 UTF-8 and Unicode
I know this post is a bit old, but i currently have issue with win 7 and notepad++ not displaying UTF 8 without BOM when the files were initially created using notepad++ v5.9.6.2 itself.
Nov
19
comment Windows 7 explorer DPI smaller than 100%
@afrazier no i did not restart the computer because changing it in Control Panel\Appearance and Personalization\Display only instruct me to re logon to the profile. Maybe, yea, I could have worked too.
Nov
17
comment What does the $ in drive mappings and AD objects mean?
@tombull89 is the $ automatically appended to the name by the system or can I manually rename my drive name and it will magically become "hidden" or "admin"?
Nov
17
comment What does the $ in drive mappings and AD objects mean?
@tombull89 I edited the AD object name for clarification. Even the SQL created group has $ in it.
Nov
7
comment Where can I download Windows Vista?
That's why this will be my last resort!
Oct
4
comment Following Excel precedents to cells on other sheets
brilliant! I almost destroyed my monitor after hours of trying!!
Sep
22
comment I need a good split-screen WYSIWYG editor?
@user958405 If it's plain HTML, you do not need anything extra other than the browser. If its a script like PHP, it will not render in a WYSIWYG editor without first installing PHP. In the latter case, you might as well run a local HTTP-server like RedGrittyBrick suggests. That said, WYSIWYG in the editor is not always the same in the browser you end users use.
Sep
22
comment I need a good split-screen WYSIWYG editor?
In response to the link you provided: I use 2 monitors, one with notepad++ and the other with FF, IE and Chrome. I edit in notepad++ and hit the F5 in the browsers. Not "real-time" but it works!
Jul
27
comment Cannot access network server via hostname, can with IP
Typically, users have permissions problems once a month, if any, when they go through the AD passsword mandatory change. This guy issue is that his problem persisted in various forms, and this time I cannot solve it.
Jul
27
comment Cannot access network server via hostname, can with IP
@KCortreau the DNS is set to "automatically detect" and ipconfig shows 192.168.x.y, the same Win2k3 server. Which I believe would be correct. Internet, Skype etc are working fine.