Displaying a Worksheet in an ACCESS control
I need to provide a toggle button that displays a specific worksheet when selected. See attached document for clarification. Thanks in advance you geniuses. Or is that geni?? SpreadsheetControlRequirement.doc
ASKER
I would like them to just see the specific WORKSHEET (in my document example that would be 341) within the spreadsheet that is named the same as the plant number. I think that your suggestion would open the whole spreadsheet and then they'd need to find the correct worksheet. - there will be possibly hundreds of the little suckers.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Don't know if my last comment has been saved, but your second option was a perfect solution. Thanks so much.
No problem.
The Canadians are done.
Go the All-Blacks
Glad it was what you need.
Nick
Grande Prairie AB
The Canadians are done.
Go the All-Blacks
Glad it was what you need.
Nick
Grande Prairie AB
If you put the path and file name of the spreadsheet into a table field with a datatype Hyperlink, when you doubleclick on the field with the table in datasheet view, you will open the spreadsheet in it's native Excel application - is this what you want?