Terence

Raw honey comes with a layer of gooey dirty looking nuritious stuff on top. Am I supposed to mix them into the rest of the honey throughly before eating?

I took the injection on Sun, drew my blood on Mon for regular screening.

Hi there,

I have hide column B C and D. I would like to do an Activecell(0,1).Activate from Col A to Col E but then vba will move to Column B even though it is hidden. How do I ask VBA to ignore hidden column and pick up from Col A to E using 1 step cell move?

Another qn, how to search for value but exclude searching those rows/cols that are hidden?

Thank you.

I tried to use PHP_GET to download file from FTP server. However I cant get the file downloaded to my laptop. How do I do that? It only move the file within the ftp server itself.

Thank you.

I tried the below:

print "<a href=ftp://10.81.130.28/sn.txt>download link here</a>";

It prompted me for password and username. Am I able to add them into the link?

I need a working php ftp script as I cant use upload for my coy server.

I am curious about this piece of code:

ftp_put($conn, "sn.txt", "sn.txt", FTP_ASCII);

How do php knows where "sn.txt" is located? I am using a form where user can browse file and submit to ftp to server. However it doesnt work at all...it seems like that piece of code above doesnt indicate the full path to locate the local file?

PHP connection to server works though.

I need help in writing this query:

TableA has (FK)CustomerNumber, Address etc...

TableB has (PK)CustomerNumber and CustomerName.

How do I write the query if I want to pull * from TableA and the result must order by CustomerName from TableB?

Your help is appreciated!

I need to upload files via php form. The destination folder only allows my id to WRITE access thus IT support wants me to write the codes in a way the all users will upload files using my login. How do I do that in php? I cant find such method on the web.

Thank you.

I have a paragraph of text with some line breaks. However when viewed in php, all the texts will be displayed as a chunk.

I tried using nl2br but that will add <br> into the line break and when displayed, <br> will also be displayed. How do I retain original text line break? Thank you

How do I allow PHP to display < and >? I have a string like "Mary <mary@mary.com>" but when viewed, it always display Mary only however in mysql, < and > remain.

I tried using strip_text but dont work.

I need to allow user to input text containing ' and < and >

How do I parse the string? PHP just wont allow the text to go through thus saving into mysql. Pls advise. Thank you!

Cells.Find(What:="Add In", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _

xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _

, SearchFormat:=False).Activate

The above code tried to find a cell titled 'Add in' and from there, i want to set a variable to capture the cell reference number such as 'B4' if the string is found in that cell. How do I do that?

for example, i have a string 'apple vegetable cow phone' and i would like to separate the words in the string and place into individual column namely, 'fruit', 'veggie', 'animal' and 'electronic'

how do i do that?

i know macro record usual steps we performed. however, in real life situation, when do we apply macro?

Is the VB in Excel a mini-version of the real thing? Some of the codings I tried cannot work at all in Excel-VB.

I have a face that turns oily after a few hrs. i think its normal? so am i normal type?