i've been told i can't create a macro in word referencing excel data. is there a way to do this? i have a table in word, and i want to create a macro to go to a particular excel spreadsheet, copy the cells and paste them into word. they will always be the same ss and the same cells. its a few tables so i was trying to automate it rather than copy/pasting it all the time. thanks.
The method that you need to use is similar to that in the article at: http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Ann" wrote in message news:93ABA962-BC9B-4729-A637-CDA76FC07787@microsoft.com... > i've been told i can't create a macro in word referencing excel data. is > there a way to do this? i have a table in word, and i want to create a > macro > to go to a particular excel spreadsheet, copy the cells and paste them > into > word. they will always be the same ss and the same cells. its a few > tables > so i was trying to automate it rather than copy/pasting it all the time. > thanks.
