Description: extract each workbook sheet1 user name/IP Address/Monitor in the right column, the content of the record to the appropriate form, these columns in the original number of columns in the table to determine, the number of rows, the Monitor may have at most four units, at least may not;

Given the workbook (+ 300) may be updated regularly, hope every run VBA, only to find the last run time are changed or generate the contents of the excel, and mark color,

QQ: 984398795

CodePudding user response:

To "content" has no difficulty,

But, you don't have clear:
1. Are you looking for the "workbook", are all open, or some files in the directory?
But look at what you said "the number" there are so many, should just file, general won't open so many book at the same time,

2. The problem of "update time",
One is the "last run time, every time I'm afraid I have to run to record by oneself (of course is to use code implementation, not manual records)?
Secondly, the content "are changed or generated", to file "modified time" or create time to judge?
Otherwise, each run, have to be scanned files for all do a "snapshot", otherwise how to judge whether the modified...

3. The problem of the output, the actual is to each of the "requirements" of the original table, the user name/IP address/Monitor this several content extraction, sorting out, right?
"Coloring" what's the necessary? Anyway, after the operation output is "new content",