How to determine the number of Pages in a Word Document using EXCEL VBA

Hi Forum,

I'm trying to copy the content of a word document (File A) to another (File B) using Excel VBA. File A has about 100's of pages (not sure of the number as it varies) and this needs to be split to different files, each having 15 Pages.

Below is my code, where I'm able to select the content of the first Page and paste it in the target folder, but not sure how to determine the number of pages in word using excel VBA. Can anyone help me out to get this sort outed.

Note: Copying the content should be done, page wise only.

Please Login or Register  to view this content.

Thanks,
King

Hi Guys,

I tried this myself and found a solution to this! Below is the final code

Please Login or Register  to view this content.

Thanks,
King