unix

Hello all, I recently watched https://www.youtube.com/watch?v=Tq3B168qT5E and have a question regarding this. My list for example contains these 4 words that i need to use to search for a similar words in a column. admin List 1 unix hrms quality The cells that i am searching for any of...

I would like to have the unix timestamp to be 2 Wednesdays back based on the current date. For example for Dates if I ran the file on a day within 10/25 - 10/31, the Start date would be 10/18. If I ran the File on 11/1, the start date would be 10/25. I figured it out in a formula for a...

I have a formula that I've been trying to setup that reads a data value from the 4th row of the N Column IF the current time is less than 5:00am, ELSE pull from the 2nd row of the column. <code>=IF(T2<"5",N4,N2)</code> Formula for Current Time (Hour) in Cell T2...

Hi, I am wondering if i can get help to develop an excel macro with which we can read lines from another window - unix window. Sending commands to that window can be done using Send keys method, but now i need to read the result of the commands that i have sent to the unix window. For...

Hi friends, I am new to this forum and need you suggestion on a perticula query: I am trying to get some data on a excel. This data is available on a unix OS solaris server. The data is available in tebular format on the txt file in teh server and i need to populate this data on my excel...

Hi all, I've searched a lot on Google and on here and have found a ton of ways to convert a Unix timestamp *TO* an Excel Date/Time value but I need to do it the other way. I've got 2 columns of values (about 9700 in total) - they're all in Excel Date/Time format and the cells have been...

Hi, Would anyone please help me by telling me how I can connect to a unix server through VBA? Example: Unix server: IP: 10.10.10.09 PORT: 12345 credentials: username: user Password: pwd how i can connect to the above mentioned server with the credentials and then execute some commands...

Hi, I would like to connect to Unix server and execute a perl script there from Excel VBA. Can you please give an example of this. Thanks, Aseem EDIT: <!-- / icon and title --> <!-- message --> Oh and I am using Excel 2007. I think that will make a difference finding the...