Need VBA Help to export data from excel to word as 2 header

[julielara]

Dear experts

I have data in excel sheet to transpose from excel to word manually i am in need of vba code help ,

i have set of data which is need to copy first 2 rows only 8 columns A:H paste into word with header point

The data layer segregate as two layer FY 19-20 one row, FY 21-22 second row
first two row copy with header paste into word as vertical
third and fourth row as another segment with header value paste into word
fifth and sixth row as another segment with header value paste into word


please find the attachment

[HariArvi]

Hi,

Please find attached the sheet containing the code to generate the word document as requested.
If you click on the blue button on the page, the word document will be created as per your specifications.

Note: Please do not clear the formatting in the range S8:U8 as I have placed the formatting needed to paste the output onto the word doc here.

[julielara]

Hi sir Thanks for your brilliant code it does work for me, i need an extra requirement on same file need to add an images after copy range, sorry for annoying you
it helps me alot time and accuracy for my project please sir help me

i just need an add two images after every report range paste in

i added all images in local folder path:C:\Users\User\Desktop\Oracle_FYIMAGES

insert images path in col I:I, once click code it would copy from path and paste into word after data pasted

please find the attachment

thanks and regards

[HariArvi]

Hi,

I have updated the excel as per your requirement. The code will paste the images in the corresponding pages on the top of the page. You can move the image manually and format it as per your needs.

Note:
The image file path shall be with the format of image. For ex.:C:\Users\User\Desktop\Oracle_FYIMAGES\FY_19-20_1.jpg

[julielara]

Wow!! Its amazing Master you are champion Thanks!! small query images mingle with text values on page, if its comes in proper allignment it would be more helpful

[HariArvi]

Hi, Thank you for your response.

We have two options. Both need manual intervention. But option 1 as posted in the previous reply is simple. Once the images are pasted you can move and place wherever you want in the page as the image size and resolution may vary. The second option is explained below.

Option2:
Refer the File attached(twoheader-With BM)
There are two codes in the excel. One for populating the table and other for adding the pics below table.
There are some manual steps to be followed in this option

Step1: Click the Blue icon in Excel for populating the table in the word document.
Step2: Once the tables are pasted. Add Bookmarks(BM) in each page for each pic and the BM name shall be same as mentioned in the J column in excel.
Step3: After adding the BMs, Save the file and type the file path with extension in the cell L1 in excel.
Step4:Click the orange icon in the excel for the pics to be placed in the corresponding BMs.
Note: File will be saved after adding the pics in the same location as mentioned above.

[julielara]

Hi sir i am getting error still , please find the excel with path location
this is my images save location C:\Users\User\Desktop\Booking_price\renamer\build_2\ img.....
this is my word.doc save location C:\Users\User\Desktop\Report_Generator\JACKFRUIT.docx
advice me if i am wrong

[HariArvi]

Hi,
1.The image path is not with full image file name. For ex:C:\Users\User\Desktop\Booking_price\renamer\build_2\ADA_BUIL2_001.jpg.
2. In the column j You need to enter the bookmark name which you use in word document as the location where you want to paste the image.

To add Bookmark to word follow the following steps:
1.Once the first macro is done, the tables will be pasted in the word. Open the word document and Go to insert tab and insert bookmark by keeping the cursor in the locations you want the images to be. In each page below the table you will need two book marks as you wanted to paste two images below the table in each page. Name the book marks as Image1, Image2 etc; Like wise do for all the pages and save the file and put the file path as you have done in Cell L1.

2. Put the same names of the bookmarks you have kept in the word file in the J column.
3.Click the Second macro. All the pics will be pasted in the bookmarked location.

[jolivanes]

http://www.vbaexpress.com/forum/show...l-to-word-file

[julielara]

sorry for that i post across forum might be get solution soon for thread by the way of attitude, i delete my account after here never ask free help on forum, sorry to Hariarvi if i hurt your feeling
thanks all experts

[macropod]

Also cross-posted at:
https://www.msofficeforums.com/excel...er-values.html
https://www.myonlinetraininghub.com/...ord-from-excel

[6StringJazzer]

sorry for that i post across forum might be get solution soon for thread by the way of attitude, i delete my account after here never ask free help on forum, sorry to Hariarvi if i hurt your feeling
thanks all experts

julielara, if you post to another forum we ask that you provide a link so people do not spend time solving a problem that has already been solved somewhere else. Most other forums have the same rule. Please take the time to review our rules. There aren't many, and they are all important.

[FDibbins]

sorry for that i post across forum might be get solution soon for thread by the way of attitude, i delete my account after here never ask free help on forum, sorry to Hariarvi if i hurt your feeling
thanks all experts

Based on your report on this thread...

i think its not cross post, i posted threads across different forum not same excel forum.

cross check if come again same excelforum. even forum rules didnt say repeat post across different forum is overrule, dont need send reminder or warning for me.

The requirement is if you post the same question on DIFFERENT web sites, not just this 1. This is to prevent members wasting their time answering a question which might already have been answered in another site.

If this requirement means you wish to leave this forum now, that is unfortunate, but it is your choice. Note that you will find teh same requirement on pretty much any forum such as ours.

[AliGW]

even forum rules didnt say repeat post across different forum is overrule, dont need send reminder or warning for me.

Further to Ford's message to you above, the forum rules DO talk about repeat posts across different forums:

3. Questions that are cross-posted to other web forums must contain links to those posts on those forums or a comment to tell us where else the question has been asked.