Convert PDF to WORD using Excel VBA

[Jamesera27]

I have existing VBA code to convert Excel to PDF. Once the PDF file is created, I would like to convert the PDF file which was just created to word, in the same Sub routine. This way I will have both file formats in the same folder. Currently all I can create is a PDF File using excel VBA. This is what I have and it works fine for creating the PDF File. I'm using Excel 2016 Pro and Adobe xl Pro. I know how to do this in Adobe but I want it automatically done using VBA. The reason I want to do it this way is because I want the sheets to look identical. Doing it manually, using Adobe, they do. The VBA code needed would go just before the last "End If". I've searched for a way but so far I haven't found a way. Any help would be appreciated.

Please Login or Register  to view this content.

[Logit]

.
Did a quick search and found this. Haven't tried it.

http://www.myengineeringworld.net/20...iles-into.html

[Jamesera27]

I found that too. Can't try it till tomorrow at work. I was hoping i only needed a few lines of code to make it happen...like when it was converted to pdf. Not sure how i would fit it in my existing code. Thanks anyway. I'll keep trying

[macropod]

Why are you trying to round-trip via PDF? You could just output the desired range direct from Excel to Word. Plus the Word content will have a far better chance of accurately reflecting the worksheet content.

[Jamesera27]

If it can't be done, that's fine. I'll do it manually.

[macropod]

You still haven't said why you're trying to get your Excel data from the PDF into Word instead of sending it direct to Word from Excel, which would be far simpler...

[Jamesera27]

my one excel sheet that i convert to PDF spans 5 PDF sheets. In the middle of those sheets is a table that I can't seem to incorporate since the table is the entire size of a landscape format and all others are portrait in my excel sheet. It copies over wrong to word format...everything is portrait so only part of the table is visible. Since you can't rotate a table 90* in excel i found another way. I made the table out of a lot of text boxes which i rotated 90*. Now, when i save as PDF everything is good and the PDF has the table still at 90* and in portrait format. But when i save as word the table is all messed up like its trying to rotate it.So i tried to manually convert "From Acrobat" the PDF to word, everything works fine...AND the table is actually saved in Landscape format and everything looks good and i still have full edit capibility. I have tried to figure out how to do this the way you are telling me but the table is the only thing that doesent work. Since I know manually converting the PDF to word works, i wanted to try that. I hope this makes sense

[macropod]

All you need do with Word, then, is to insert 'Next Page' Section breaks either side of the landscape table and set that Section's orientation to landscape when exporting from Excel. Importing from a PDF would likely still require you to do that.

Alternatively, you could insert the table into a Word textbox and rotate that.

[Jamesera27]

So back to my original post ,since i can't seem to get anything else to work. Is there a way to do it. Excel VBA to convert PDF to Word?

[macropod]

What have you tried to do vis-à-vis outputting the content to Word, including with the use of Section breaks?

[Jamesera27]

I've already stated that the only thing that works right is when i manually convert a pdf to word. I have tried all ways in vba that I know but nothing formats it right. I want to convert PDF to WORD in vba automatically.

[macropod]

So show use the code for direct conversion that you say doesn't work - and show us, too, that you've taken on board the advice to employ Section breaks as required.