Name an Entire Workbook

Name an Entire Workbook

Post by TmFCZWxsRk » Fri, 16 Nov 2007 23:24:01


I need to name an entire Workbook for a merge into Word. How do I name the
Entire Workbook to include all the Worksheets and all the cells in each
Worksheet?
 
 
 

Name an Entire Workbook

Post by TmFCZWxsRk » Fri, 16 Nov 2007 23:36:00

I need to Merge an Entire Workbook in Excel into a Word Document. How do I
name the Entire Workbook to include all worksheets and cells in each
worksheet?

 
 
 

Name an Entire Workbook

Post by Bernard Li » Fri, 16 Nov 2007 23:44:17

Please tell us what "name the entire workbook" means in this context.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
 
 
 

Name an Entire Workbook

Post by TmFCZWxsRk » Sat, 17 Nov 2007 00:38:11

My data is in a workbook with 10 worksheets. I need to merge all of this
data into a Word table document. In the form of 10 worksheets I have to
merge each worksheet separately into Word. I wanted to name the range of
worksheets. Is there a formula to define Sheet 1 through Sheet 10 and
include the range of cells in each sheet? I'm obviously having a hard time
explaining my project.
Any ideas would be appreciated!!!
 
 
 

Name an Entire Workbook

Post by Bernard Li » Sat, 17 Nov 2007 00:49:56

I would ask the Word group for a macro that does:
For each worksheet in myWorkbook
merge with Word doc
(and print)
next worksheet

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email