unix

  1. A

    Unique List When Adjacent Cell Contains a list of Words

    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...
  2. B

    Find the UNIX Datetime stamp for a specificdate based on the current date in VBA?

    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...
  3. A

    Time-Defined IF Statement Does Not Update

    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...
  4. B

    Excel Macro to read lines from Unix window

    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...
  5. M

    How to connect to unix os on solaris server from Excel

    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...
  6. D

    Convert Excel Date/Time *TO* Unix timestamp

    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...
  7. J

    Connect unix server through VBA

    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...
  8. A

    Connect to Unix and execute perl script from VBA

    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...

Watch MrExcel Video

LET Function Second Look: Reusing Variables! 2326

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top