Excel -> Word (in office 2k)

[Kalechibki]

To be honest, I'm not sure if this post should be here or in the VB6 forum. But, I'm going to try my luck here first, hoping this is just a macro that I can write in excel.

I'm working on a cost spreadsheet, and one of my bosses asked me, to save time, to use excel to generate a word document that would print out if a user "hits a button."

I have a lot of programming background, but I've never done anything with Macros (though, I've heard they are easier than using VB). I also have a lot of experience in Excel and in Word on their own. Anyone have an idea on how I do this?

 

[Dreamboat]

I don't get it.
Print out what, Kale?

Can you give us more info?

Why would you want it to print out in Word? Do you have a bunch of other text to go with it?

Otherwise, what is wrong with printing it out in Excel?

Are you entering mail merge data into an Excel file, and then you want to run the mail merge right from Excel? Anne Troy

http://www.TheOfficeExperts.com

 

[Kalechibki]

Oops! sorry for not being more clear.

There is a form letter that some of the fields from the Excel file would go into. For instance, one line in a written document would say something to the extent of...

The cost of buying back this service would cost $4,264.64

...where $4264.64 comes from a calculation on the Excel spread sheet.

I hope this provides enough information to help me! ^^;

 

[Kalechibki]

One edit from my last post

It is a letter than is typed out write now. They want it to be automatic. That's what I meant by form letter

 

[Dreamboat]

Mail merge? Have you tried mail merge? What does your excel file look like? Anne Troy

http://www.TheOfficeExperts.com