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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top