Define a Range in your excel file that just contains these cells. Use Import Records to import that range.
Thanks again Phil. Pardon my newbie-ness, but I just don't understand how to do it. Import Record appears to only gives me the option of importing the whole file (I think).
WHen you select Import Records, you can then select an Excel file type. Then, when you select the file to import, a dialog pops up where you can select a work book or named range within the file.
Hey Phil, thanks for the follow up. I did try your first suggestion, when I get to the pop up dialog it only lets me select a work book sheet, the named range is grayed out. Which is why I couldnt get a range.
Does this only work with the latest Excel only?
I'll give it another go, but being this is something I only do once a day, and the file is open, a quick copy/paste into the container might be as good as it gets.
Thanks for your help
Did you create a named range in the Excel file so that you have one to select?
Thanks again Phil. I tried, but it's just not working. It only takes one cell, not both. It's something I'll play with later.
The way I was able to get it to work was to add a sheet to the Excel file, with just those two fields combined into one, i.e ='2012-2013'!I1&"/"&'2012-2013'!I2
Then scripted the container field as a button to import just that sheet from Excel into the global storage container field. Although not the best, It works just as I need it. Thanks always for all your help.