Good Morning Everyone, starting off I been notified my departments trying to see if they could pull data from Extra into Excel to work with instead of printing 8 pages every time we need to review clients. This is more of a optional side project to see if its possible.
They been looking into extra trying to figure out how they can program it. But as of today, I been notified of the project and instead of using Extra I figured why not use Excel and program it to pull the data. With no programming knowledge, I have been unable to get very far.
We use 3 windows of Extra.
1. Summary of Clients info.
2. Ledgers or whatever
3. Blank or whatever we want.
I been looking at a few links and they are a bit outdated so I don't know if anything changed in the coding,
We want to pull Total Salaries per year out of (Extra Session 2 window) to edit in Excel that is currently opened and named Salary.xlsm on a different sheet named Data.
The beginning always starts with 14-15 for current year. <Enter> goes to next page, which would be 13-14; Unless too much information was on page 1, then there will be two pages both assigned for the same year.
We are trying to pull in salaries based on our date range. So (14-15 to 02-0) or (05-06 to 99-00). I was hoping to assign A1 to end date and B1 to beginning Date. Run macro, then the macro will check the date on Extra screen, if it is equal to what is in B1, Copy Date from top right corner (idk,idk,5) and Salary from bottom left corner (7,20,10) to Excel, A2 for Salary and B2 for Date; If not B1, <Enter> repeat.
After it copies the first page its suppose to, It needs to go to the next page and check Date that it is not Equal to B2, If not, Copy again into A3 and B3; If equal then <Enter>, Repeat. ;3rd page will be checking date B3 and ect
Then finished when it reaches the page with the same date as A1 are equal and copy Date and Salary and End or STOP macro.
Lastly, copy clients name and ID# from (Extra session 1 window) and End
Any advice or helpful links or straight code for setting Date ranges and cross checking it with Extra would be helpful. Pulling code is one thing, I have no idea how to set the ranges and get them to work like i described. If I can get it to check dates its as simple as throwing a code to copy coordinates on a screen and repeat. I also don't know if the links of code I been reviewing is still usable. Sadly, don't have the exact coordinates of the text that needs to be copied so I made due.
They been looking into extra trying to figure out how they can program it. But as of today, I been notified of the project and instead of using Extra I figured why not use Excel and program it to pull the data. With no programming knowledge, I have been unable to get very far.
We use 3 windows of Extra.
1. Summary of Clients info.
2. Ledgers or whatever
3. Blank or whatever we want.
I been looking at a few links and they are a bit outdated so I don't know if anything changed in the coding,
We want to pull Total Salaries per year out of (Extra Session 2 window) to edit in Excel that is currently opened and named Salary.xlsm on a different sheet named Data.
The beginning always starts with 14-15 for current year. <Enter> goes to next page, which would be 13-14; Unless too much information was on page 1, then there will be two pages both assigned for the same year.
We are trying to pull in salaries based on our date range. So (14-15 to 02-0) or (05-06 to 99-00). I was hoping to assign A1 to end date and B1 to beginning Date. Run macro, then the macro will check the date on Extra screen, if it is equal to what is in B1, Copy Date from top right corner (idk,idk,5) and Salary from bottom left corner (7,20,10) to Excel, A2 for Salary and B2 for Date; If not B1, <Enter> repeat.
After it copies the first page its suppose to, It needs to go to the next page and check Date that it is not Equal to B2, If not, Copy again into A3 and B3; If equal then <Enter>, Repeat. ;3rd page will be checking date B3 and ect
Then finished when it reaches the page with the same date as A1 are equal and copy Date and Salary and End or STOP macro.
Lastly, copy clients name and ID# from (Extra session 1 window) and End
Any advice or helpful links or straight code for setting Date ranges and cross checking it with Extra would be helpful. Pulling code is one thing, I have no idea how to set the ranges and get them to work like i described. If I can get it to check dates its as simple as throwing a code to copy coordinates on a screen and repeat. I also don't know if the links of code I been reviewing is still usable. Sadly, don't have the exact coordinates of the text that needs to be copied so I made due.