Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EB2003

    Excel Chart into Word Document automatically using VBA

    Rob and Skip, Thanks so much for all your help. You guys are great! Skip, I did read help for GetObject and that is where it told me to put the path in -- both in the description and in an example -- perhaps because I am using an old (Office97)version. In any case, thanks to the two of you, I...
  2. EB2003

    Excel Chart into Word Document automatically using VBA

    Thanks Rob and Skip, Now its working and I'm on my way! It works when I have the excel file already open on the proper worksheet. Can anyone tell me how to get it to open an excel file then use it? I tried typing the path in the Getobject function (e.g...
  3. EB2003

    Excel Chart into Word Document automatically using VBA

    I am trying to use the code from Rob in WORD and getting a compile error message on the dim statement for both the Excel.Application and Excel.ChartObject. Do I need to modify the code? Sorry, I have never done VBA in WORD before. Thanks, EB
  4. EB2003

    Excel Chart into Word Document automatically using VBA

    Hi, I have 62 Excel files all in the same format. One sheet has data, the other sheet has a set of 6 charts. Does anyone know how I can automatically put the set of 6 charts from each of the 62 Excel files into a word document (either in separate pages, or separate WORD documents)? Thank you.

Part and Inventory Search

Back
Top