Hi,
I want to convert a pdf file to excel and be able to transfer the data into another workbook using VBA. Based on research, converting pdf to excel can be done by first converting to Word document and then to excel. But I want to know if the excel conversion can be transferred into an existing workbook within the same VBA. Also, I would like users to be able to select the pdf file they want to convert without having to set a file path. This can be done by using 'get open file name' but I can't figure out how to combine the two. I'm hoping there is a way.
I want to convert a pdf file to excel and be able to transfer the data into another workbook using VBA. Based on research, converting pdf to excel can be done by first converting to Word document and then to excel. But I want to know if the excel conversion can be transferred into an existing workbook within the same VBA. Also, I would like users to be able to select the pdf file they want to convert without having to set a file path. This can be done by using 'get open file name' but I can't figure out how to combine the two. I'm hoping there is a way.
