Subscribe Bookmark RSS Feed

Opening a specific worksheet in Excel

Hi - can anyone tell me (or point me at a thread somewhere as there may well be one already) how in JSL to prompt a user to open a specific worksheet in an Excel spreadsheet?  By default all of them open when a spreadsheet is opened, so he then has to close all the ones that are irrelevant to what he's doing.  If I can supply him with a list of worksheet names he could simply select the one he wants - which would be a lot more elegant.

Many thanks

1 REPLY

This looks like what's needed: https://communities.sas.com/message/147758#147758