excel to excel, excel to word

[nancyo]

I am looking for a simple code to do the following:

1. Copy ONE spreadsheet from an excel workbook into a new workbook.

2. Create the new workbook as part of the macro.

3. Save the new workbook as part of the macro.

4. The saved filepath will be different only in the FILENAME, which somehow must be referenced from the original excel file (possibly from a specific cell reference from a different spreadsheet).

5. Fantasy macro - do the same to word.

I have tried several variations on macros offerend in this website and others, and can't get anything to work. I am not a programmer at all, but have been able to modify other macros in the past to work.

Any help is appreciated!!!!!!!

 

[Anne Troy]

At this point, you can record a macro in Word to format it. When recording the macro, store it in your normal.dot so it's available all the time (you can't really store it in a file that's being newly created from Excel). Here's how to record a macro:

http://www.thewordexpert.com/wordvba.htm

(You probably know that already...) Anyway, if you have problems with formatting it, email the doc and I'll see what I can do. I'm very good with tables, which I suspect is the new format. I've also got a tables document for download at:

http://www.thewordexpert.com/word.htm#AllAboutTables

 

[nancyo]

Dreamboat: Thanks for the info. I printed out the "How to record a macro..." and will play around with it today. I will reply with questions ASAP. Thanks again.

NateO - Have a great weekend. You saved my life this week!!!!

 

[NateO]

Nancy, TGIF!! Have a great weekend! Happy to be of help. Try and see if you can bury your Word Vba in the macro, in an attempt to avoid running macros in two applications.