I am trying to open PDF and Word files in MS Word using a Start Process so I can scrape data from them. I am having an issue where if the filename contains spaces, it will start word but attempt to open three word documents. e.g. If my document was named “hello world.docx”, it will try to open “hello.doc” and “world.doc”. See below screenshots:
How would I overcome this without altering the filenames? I can’t use Word Application Scope because I have PDFs, and I can’t convert the PDFs as I need to keep the tables in the files exactly as they were. I also can’t scrape through Acrobat.