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