Hmm, no that doesn't make sense -- I even tried downloading the actual file that I have attached in the first post and saved it to a diff location - then pasted the last batch of code into a new Module 3 -- ran it and everything within the file disappeared and it shows it to be a 1 page document.
Alternatively, I tried moving the code to the main ThisDocument area and tried to run it again and the exact same result occurred -- everything was deleted and only a single white page was left behind.
Where did you place the code when you tested with the attached file?
Can you attach the file you used to test with - where it successfully extracted? Do you think it has something to do with that MS Forms object not being present?
This is really odd -- makes no sense
|