For example, the worksheet reference appears as Worksheet!data_range. Then, it becomes [Workbook name.xls]Worksheet!data_range.
- Rename the workbook, and then delete any characters that are not letters, numbers, underscores, or periods.
- Use the same worksheet for both input and output data.
Article ID: 896014 - Last Review: 29 Apr 2008 - Revision: 1