Excel help please

  snowman 21:37 25 Mar 2003

Can anyone help with this problem.

Is it possible to link excel spreadsheet to word.

I have an invoice in excel from A1:P43 that prints out.

I would like to keep an electronic copy in word that pastes only the data into word and then adds a page break ready for the next entry.

Is this possible using Vb in excel and word or do you need additional programming software?

  VoG™ 22:10 25 Mar 2003

The easiest way to do this is to record a macro in Word.

With your Excel file open, start Word and Tools/Macro/Record new macro.

Assign the macro to a keyboard function (e.g. CTRL+I).

Do all the actions necessary to transfer the information from Excel to Word. Then stop the macro recorder.

The next time you need to do this, make sure the Excel Workbook is open, start Word and press your keyboard shortcut.

A question - why? Wouldn't it be easier to print the invoice directly from Excel?

  snowman 22:23 25 Mar 2003

Thanks for the reply. I will try that.

I do print it from excel but i would like an electronic copy for faster access to the information instead of searching through the paper.

A question

Is it possible to link the process from excel Vb to run the macro in Word

  VoG™ 22:31 25 Mar 2003

Your question - I believe that is possible but that's beyond my meagre knowledge. Somebody else here may know or you could try click here - total Office gurus.

  snowman 22:35 25 Mar 2003

Thanks i will check that out and close this discussion for the time being

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?