Does anyone know if it's possible when referencing an excel spreadsheet in a course to direct the user to a certain row within the spreadsheet when they click on the link within the course to access the file? If so, how is this done.
We have an large excel spreadsheet that we would like to use and instead of having the user open the spreadsheet and scroll through all of the info in order to find the related information we would just like for, once clicked and opened, it automatically directs them to that certain row.
I don't believe there would be a way to do this unless you were to set something up within Javascript. I'll defer to the community on the possiblity of that and you may also want to begin by reviewing the information here on Javascript best practices.
This is possible with a macro-enabled .xlsm file. Here's a link to instructions that direct the focus of an Excel spreadsheet to a specific sheet & cell within the workbook file:
Some users will receive a prompt asking whether to allow the macro functions of the Excel file; if they choose yes, then the spreadsheet opens to the cell indicated in the VB script.
3 Replies
Hi Adam,
I don't believe there would be a way to do this unless you were to set something up within Javascript. I'll defer to the community on the possiblity of that and you may also want to begin by reviewing the information here on Javascript best practices.
This is possible with a macro-enabled .xlsm file. Here's a link to instructions that direct the focus of an Excel spreadsheet to a specific sheet & cell within the workbook file:
http://www.atlaspm.com/toms-tutorials-for-excel/toms-tutorials-for-excel-open-a-workbook-to-a-specific-sheet-and-cell/
Some users will receive a prompt asking whether to allow the macro functions of the Excel file; if they choose yes, then the spreadsheet opens to the cell indicated in the VB script.
Thanks for stopping in with your suggestion, S! Hopefully it will help others who encounter this post in the future.
This discussion is closed. You can start a new discussion or contact Articulate Support.