Share via

Name saved Word file with the value of a cell in an Excel worksheet.

Eduardo Martins 1 Reputation point
2022-04-13T15:21:21.89+00:00

Good Morning!
I need to name a save Word file, with the value of an Excel cell, which in this case would be the person's name.

My Excel spreadsheet is in the folder: "C:\Users\Matheus\Desktop\Drawings\drawings.xlsm"
on the bottom tab "drawings 2-6 years old"
the person's name is in cell "B4".

I need the file to be named like this: drawing-tree_Matheus.pdf
in this case the value of cell "B4" is "Matheus"

In this case the macro would be in Word, correct?
Is this possible?

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
994 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,502 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Eduardo Martins 1 Reputation point
    2022-04-20T01:23:34.54+00:00

    omg.... six days... pls helpe me!

    0 comments
  2. Eduardo Martins 1 Reputation point
    2022-04-23T16:11:26.777+00:00

    omg....ten days... pls helpe me!

    Is there anyone who reads this here?

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.