if i have an excel file and a word file saved in the same folder, how do i reference a cell in the excel file from the word macro?
lets say for example, I want to reference A3
if i have an excel file and a word file saved in the same folder, how do i reference a cell in the excel file from the word macro?
lets say for example, I want to reference A3
I am not too familiar with Word VBA, but try the code below. You may have to change directory and cell reference to suit your need.
PS: Make sure Microsoft Object Reference from the library is checked
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks