Hello friends, We have a 3rd party Tax based desktop application, and are trying to load in DB. They gave us a sample excel file with a macro, which when I click on excel button, a application browser with all groups show up. It is divided into 3 sections, one has all groups, second has cell information, third is property of all groups. It is not in excel table format and there are no menu options to capture the data. It wouldn’t allow me to copy all values, as only the column values are copied when pasted in notepad. I have attached a snapshot for reference. I need to capture name, description, type and index in section 2 including scroll down and extract the data into an excel file. It doesn’t allow me to do data scraping and asking me for index. When I try to do screen scraping, I don’t know how to get scroll down covered and extract to excel. I need to do this for most groups in 1st section. 3rd section is not needed.
Could you please help me!! Appreciate your support!