''wb.Sheets("Ek.prognos").Range("Ek_prognos").CopyPicture Appearance:=xlScreen, Format:=xlPicture ''wDoc.Bookmarks("BM_Anskaffning").Select ''wb.Sheets("Anskaffning").Range("Anskaffning").CopyPicture Appearance:=xlScreen, Format:=xlPicture ''wDoc.Bookmarks("BM_Driftbudget").Select ''wb.Sheets("Driftbudget").Range("Driftbudget").CopyPicture Appearance:=xlScreen, Format:=xlPicture Set fd = Application.FileDialog(msoFileDialogFilePicker)įd.Title = "Please select the Excel file." Set wApp = GetObject(, "Word.Application") I have not found a way to select both the Databodyrange and the Totalsrange. The below code (Word VBA) is not working, it is stopping at the Databodyrange selection, any idea why? I do not know if the "paste code" work yet, that is my next aim. If I copy the Databodyrange+Totalsrange in Excel and place the cursor just below the one row table in Word and paste, the two tables merge. It is difficult formatting the table headings the way I want so I have a one row table in Word with the headings, below I want to have the data. Maybe I made a mistake and tried to attack the problem from Word, should maybe have stayed in Excel and pushed it to Word? The table can change in size and might also break the page so i can't use the same "picture" method. I now also want to paste part of an Excel table to word and merge the tables. I got it working pasting Excel range to Word as a picture. I know, maybe this is not the right forum but it is the one I usually use.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |