Excel to word, without using a macro

[Kevineamon]

Hey guys.
Anyone know a way to autopaste a worksheet into Word or better again - Notepad, without using a macro?

 

[Macropod]

That depends on whther you want to maintain any relationship between the two. For that, you might use an OLE link, which you can achieve by copying the Excel range and pasting it into Word with Paste Special, using the 'paste link' option and the paste format of your choice.


Otherwise, mailmerge or a Word DATABASE field might be a possibility.

You really haven't given us much to go on.

 

[Kevineamon]

Sorry should have given more detail. No I don’t need any continued relationship for this section of the workbook.

We generate a lot of repetitive data, handled by excel. Of course there’s the copy paste option but I’ve been tasked with automating as much as possible. I can make a button, for hyperlinks for example. I was thinking I might be able to make one, to dump some of the data onto a txt file...

It’s not always just the text files imports, we use the workbook for.

The vba scripts on the macros don’t communicate well with some of the hardware we use.

 

[Macropod]

If the data are for a text file, it's not clear why your title refers to Word; Excel can save content to a text file without involving Word. For example, you could use formulae to collect data onto a worksheet that you save in CSV format.

Again, you really haven't given us much to go on. As for:

The vba scripts on the macros don’t communicate well with some of the hardware we use.

we really couldn't comment on the issues there in the absence of knowing what you code or hardware are, other than to say any problems are most likely due to: faulty code; a faulty Office installation; and/or faulty hardware.

 

[Kevineamon]

The only reason I'm talking about the comms issues, is because you asked me for more information and I'm telling you, why I can't use a macro. I didn't need or want comments on it, it's been troubleshooted inside out and upside down and I'm not bringing it up again within the team. No one wants to think about it...believe me...
Anyways forget about that, tell me more about this formulae used to collect data.

 

[Macropod]

tell me more about this formulae used to collect data.

At its most basic, open the sheet you want to update, select the cell you want to update, press the = character, then switch to the sheet & cell you want to get the data from.

 

[Kevineamon]

Ok thx