Hi.
I am trying to do something that I thought would be easy. I have a Word document that uses UserForms to input data. The data is then inserted into described bookmarks in the document.
Currently, I can import the text within these bookmarks into an Excel spreadsheet, using Excel to open Word, allowing the user to select the file that they want to import the bookmarks from and then saving the file based on a name derived from the text in those bookmarks.
So far, a doddle.
I want to be able to ‘graduate’ from the Excel spreadsheets that we are using up to an Access database. It is more flexible and easier to manage and less prone to error than the spreadsheet we use.
Try as I might I can’t find a way to:
1. Select the document that I want to open. I can write code that will open a specific document, but not the allow me to select documents save to my computer.
2. Transfer the text in the bookmarks in the Word document into the database. I can find plenty of advice on going the other way, that is, populating Word bookmarks with data from a database.
Does anyone have any ideas about how to go about this? I am practicing in Access 2002 (because that is what I have at home), but will be rolling this out in Access 2003 at work, if that makes a difference.
Thank you in advance,
Bill
