Excel-Word Macro Development
Budget: $30 – $250 USD
I'm looking for a professional developer who can create a macro for my Excel file "Report1".
Here's the functionality I need:
- When the user clicks the "Select File" button in the Excel file, they should be able to choose the Word document (e.g., "SampleForm1"). The macro should transfer the text fields from the Word file to the corresponding columns in the Excel report.
- Additional clicks on "Select File" should add a new row for each new entry.
- The Word file uses legacy forms, which may complicate things, but this needs to be handled.
Considerations:
- The software versions in use are Office 365.
- Text fields from the Word file should match with the columns in the Excel file by field name.
- If a field from the Word file does not exist in the Excel template, it should simply be ignored.
Ideal skills for this job include advanced Excel and Word knowledge, VBA programming, and experience with legacy Word forms. Please provide examples of similar projects you have completed.
Here's the functionality I need:
- When the user clicks the "Select File" button in the Excel file, they should be able to choose the Word document (e.g., "SampleForm1"). The macro should transfer the text fields from the Word file to the corresponding columns in the Excel report.
- Additional clicks on "Select File" should add a new row for each new entry.
- The Word file uses legacy forms, which may complicate things, but this needs to be handled.
Considerations:
- The software versions in use are Office 365.
- Text fields from the Word file should match with the columns in the Excel file by field name.
- If a field from the Word file does not exist in the Excel template, it should simply be ignored.
Ideal skills for this job include advanced Excel and Word knowledge, VBA programming, and experience with legacy Word forms. Please provide examples of similar projects you have completed.