Search results

Hello There, I would like to know how can I extract website data using VBA. Currently the below manual procesure is followed. I would like to do this using excel VBA The following is the manual procedure followed: 1. Go to website: https://www.msc.com/nld 2. Click Tab "TRACK...

Thank you Debaser for your reply. I didn't understand. Could you please let me know how this can be done in VBA? When I open the second workbook, I do open it with full path with write mode. But before opening it I would like to check if it is already open, if yes then kill it's process and...

Thank you for your question. The first workbook opens the second workbook. Sometimes, when the workbook crashes the child process still remains active in the Task Manager. When you open the workbook (after the crash), then it says the first workbook is open, to be open in read-only mode...

Hello There, I would like to know how to kill a Task Manager's process using excel vba. I am using 2 files: 1. File 2 Donnie Working All.xlsm 2. Piramide Database.xlsx I would like to have the vba code in the following manner: 1. Check if there are any Excel Task Manager process running...

Thank you Bosco

Hello There, I have a given date, and I would like to know whether this date: 1. Is any date during the month (Output: During the Month) 2. Is the 1st and the last day of the month. (Output: Not during the Month) The formula needs to be build compatible to Excel version 2003...

Hello There, I have a 2 worksheets: 1. Actual Working: This worksheet has formula across 12 months, which is working fine 2. To Be Working: I would like to have a change in the way the formula is applied across the cells. I have attached a sample workbook for your reference which would give...

Hi Bosco, There is a slight problem with the calculation of the formula in the detail section 1st part. I have attached the sample file for your reference. The 2 rows are marked in Bold. The one in green first row is working good. The second row formula marked in red is giving problem. I have...

Thanks a lot Bosco for taking the time to help me out. :):awesome: Wish you a pleasant weekend. Regards, Don

Hi Bosco, As a summary of the detail listing, I tried to get the unique listing of the persons and it's totals of the relevant columns against each person. Could you please have a look at the attached sample file and help me. Many thanks and look forward to hearing from you. Regards, Don

Thank you very much Bosco. It works as expected. I thought it would be a very complex one but you have made it look simple. :awesome::) In another worksheet it should reflect the summary of the Person Number wise (unique) listing and it's FTE Months. I will try it out myself, if I can get it...

Hi Bosco, Thanks a ton. It works so wonderful. :awesome::awesome::awesome::) I was trying to debug your formula and would like to know what each part does. When you have some free time to spare, would appreciate if you could explain the parts in the formula. The characters '--' you have used...

Hi Grah, Thank you for your reply. The person's availability is calculated based on the From and To date precisely. If it is a whole month, then the end of month date should be displayed. If it is not a whole month in the from or to date, then in under it's respective month column it should...

Hi There, I have a date range (From and To Date) and month columns from Jan to Dec. Based on the From and To Date, it should generate the date for the month (Jan to Dec) column. Eg. From Date: 15-Feb-2018 To Date: 30-Apr-2018 Under Column Jan it would be empty Under column Feb it should...

Hello There, I have a requirement to calculate the presence of a person's availability based on working hours (FTE) on the start and an end date. The calculation is displayed across the months (Jan to Dec). I have uploaded the sample file. For ease of understanding, I have given range names...

Hi There, I have 3 defined named ranges in 3 different worksheets. The following is the functionality: 1. Sub CheckMandatoryFields It check if the 3 defined named ranges has a value. 2. Sub ChangeInvalidColour If defined name range is empty then fill the interior to color yellow else...

Hi There, Any help, please? Regards, Don

Hi There, I have 2 workbooks where I would like to have data from one workbook worksheet to various worksheets in another workbook. The requirement is as below: Please find attach the below sample files for your reference. A. Source Data.xls The first file has the raw data from a system that...

Works perfect. Thank you :)