I need vba code to update item cost from a word document w/o changing the previous wks item cost in Excel 2004

20 pts.
Tags:
Excel 2004 Workbooks
Excel VBA
Excel worksheets
Visual Basic
I have a work book with week 1 - 5  ending inventory worksheets.  I need vba code to update item cost from a word document w/o changing the previous wks item cost.

Software/Hardware used:
excel 2004

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t have any control over the word doc format. I think will have to create a separate import file for each week and then have it update only those items. I still will have to create some code that will automatically update the upcoming weeks. Such as updates made to week 2 need to be carried over to weeks 3,4 & 5.

Thanks,

Joe

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Chippy088
    Do you have control of the format of the word doc? If you can design the word document to have the figure/data you want to always be in the same place (therefore the same cell in the imported data sheet), get it into excel and then link the 2 cells. I update an excel sheet from a web page imported into the workbook, when it is opened, and select a currency figure from a cell in the imported page. this is done by entering an absolute sheet/cell ref in the target sheet. The sheet is automatically updated from the web when it is opened. Some times it works, and sometimes it doesn't. I have no control over the imported content, so the figure I need is not always in the same cell each week. I still have to check it. It isn't more than 2 cells out either way. You will have to change the links to reflect which week column it is entered into. My simple method doesn't do what you want, but it proves there is a way to import from a doc/web page, and automatically get data, providing it is in the same place each time.
    4,625 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following