VB Syntax, How do you merge Excel workbooks thru VB

How do you merge Excel workbooks thru VB

Author	Message
Thoma #1 / 5	How do you merge Excel workbooks thru VB I have three workbooks that I want to merge into one. So far, I haven't had any luck anything I've tried. Any suggestions?
Mon, 14 Nov 2005 02:17:38 GMT

Matt Williamso #2 / 5	How do you merge Excel workbooks thru VB What have you tried? What version of excel are you using? Quote: > I have three workbooks that I want to merge into one. So > far, I haven't had any luck anything I've tried. Any > suggestions?
Mon, 14 Nov 2005 02:56:10 GMT

thoma #3 / 5	How do you merge Excel workbooks thru VB What I have tried is the MergeWorkbook mehtod. Quote: >-----Original Message----- >What have you tried? What version of excel are you using? >> I have three workbooks that I want to merge into one. So >> far, I haven't had any luck anything I've tried. Any >> suggestions? >.
Mon, 14 Nov 2005 03:43:44 GMT

Matt Williamso #4 / 5	How do you merge Excel workbooks thru VB The MergeWorkBook Method adds changes from a workbook into another open one. If you want to take 3 workbooks and turn them into one workbook, you'll probably want to open each workbook and get the usedrange into a range object and then add the 3 range objects to the new book. Search the Microsoft.public.excel.programming groups archive for more info. There are many examples of doing this. I'd also check out http://j-walk.com/ss/excel/index.htm This site has excellent programmers resources for Excel. HTH Matt Quote: > What I have tried is the MergeWorkbook mehtod. > >-----Original Message----- > >What have you tried? What version of excel are you using? > >> I have three workbooks that I want to merge into one. So > >> far, I haven't had any luck anything I've tried. Any > >> suggestions? > >.
Mon, 14 Nov 2005 04:12:56 GMT

thoma #5 / 5	How do you merge Excel workbooks thru VB Thanks. I'll go see what I can get. Quote: >-----Original Message----- >The MergeWorkBook Method adds changes from a workbook into another open one. Quote: >If you want to take 3 workbooks and turn them into one workbook, you'll >probably want to open each workbook and get the usedrange into a range >object and then add the 3 range objects to the new book. >Search the Microsoft.public.excel.programming groups archive for more info. Quote: >There are many examples of doing this. >I'd also check out http://j-walk.com/ss/excel/index.htm This site has >excellent programmers resources for Excel. >HTH >Matt >> What I have tried is the MergeWorkbook mehtod. >> >-----Original Message----- >> >What have you tried? What version of excel are you using? >> >> I have three workbooks that I want to merge into one. So >> >> far, I haven't had any luck anything I've tried. Any >> >> suggestions? >> >. >.
Mon, 14 Nov 2005 04:37:40 GMT

Page 1 of 1

[ 5 post ]