vurice.blogg.se

QUESTION: Is this task even possible to achieve in VBA? I'd love to find a simple and elegant solution, but at this point I would settle for something that WORKS. PROBLEM WITH METHOD 03: It works with only 1 cell, but as soon as I attempt to get more than one cell copied and pasted over, the result is the same data over and over again across multiple cells. 'In Excel, Save changes to cell and move 1 cell to the right

'Select the appropriate cell in the active Excel worksheet (based on the For Loop) Using Excel to transfer data between Word and Access: Copy and Paste the table onto an Excel worksheet Open your Access database (create a new one if need be). 'for some reason Application.caption works for me. 'Note: I'm not sure why AppActivate ("excel") does not work, but 'Select the appropriate cell in the Word table (based on the For Loop)ĪctiveDocument.Tables(1).Cell(r, c).Select

(When All Information is selected, InDesign will paste everything in a single cell.)Ĭlose the Preferences dialog box and re-paste and all will be well.'Loop through the 3x3 Source table and simulate sending keys to copy and paste, cell by cell Click it, and under When Pasting Text and Tables From Other Applications, choose Paste: Text Only. All the way down at the bottom of the list of categories you’ll see Clipboard Handling. Press Command/Ctrl+K to open the Preferences dialog box. The table data will spread out over all the necessary rows and columns.ĭidn’t work, you say? Did all the table data go in that one cell you had selected, like this? Just copy the content from the Word document and paste it on the Excel document. You’ll know you have the cell selected when it’s fully highlighted. Alternatively, click and drag just to the cell border. You can do this by putting your cursor in the InDesign table cell and pressing Esc. But it’s good practice since it helps you end up with a table that’s sized properly from the get-go.Īnd here’s the key step: Select the top left cell (or whichever cell where you want the pasted data to start filling in the table). This isn’t strictly necessary InDesign will add rows and columns to fit the data when you paste. In InDesign, create a table with the right number of row and columns to house your data. In Word or Excel, copy the cells you want to bring into InDesign.

But if all you want is a simple, 2-second method, here it is: Of course, using File > Place will give you access to import options that can be very handy for controlling what content comes in from Word or Excel, and how that content is formatted. Here’s a quick tip for those times when you want to quickly get some tabular data from Microsoft Word or Excel into InDesign without going through the process of placing the file.