chaddiesel
Registered User.
- Local time
- Today, 06:40
- Joined
- Mar 30, 2005
- Messages
- 24
Hello Everyone,
I have a field set up in a table that is an OLE object with a link to an external Excel spreadsheet. My question is whether you can use a file path that contains wildcards. Each Excel file has a filename something like this:
Company Name Part Number Revision 05-31-05.xls
Is there a way to set a file path up that will search for the first part of the file name and load the file? The Company Name and Part Number will always be the same, but the Revision Date will change. We want to be able to just replace this file with the new file and have the link maintained. My boss does not want to change the name of the filename. Is something like this possible? I want to be able to associate the Excel sheet with part numbers so I can print the needed sheets. Any information would be appreciated.
Chad
I have a field set up in a table that is an OLE object with a link to an external Excel spreadsheet. My question is whether you can use a file path that contains wildcards. Each Excel file has a filename something like this:
Company Name Part Number Revision 05-31-05.xls
Is there a way to set a file path up that will search for the first part of the file name and load the file? The Company Name and Part Number will always be the same, but the Revision Date will change. We want to be able to just replace this file with the new file and have the link maintained. My boss does not want to change the name of the filename. Is something like this possible? I want to be able to associate the Excel sheet with part numbers so I can print the needed sheets. Any information would be appreciated.
Chad
