A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
hi.. don't know if this is too lo end, but will workbook find itself.. if run macro recorder is used.
all i got was:
Workbooks.Add
Hi. Thanks for your interest. No, Excel would have to be open already to run the code.
I do have shortcuts set up that will launch Excel, and open a particular workbook thru the Command-Line.
However, sometimes I just wants to launch Excel, and avoid having to always select "Blank" workbook from the template list.
I'll keep looking... Thanks. :>)
[Edit...]
Oops. Found it! Thank you Debra Dalgleish for her posting a while ago.
Excel 2013 is a little different. This solution worked for me.
http://blog.contextures.com/archives/2013/01/17/open-excel-2013-with-a-blank-template/
I recommend visiting her site! A short copy of her excellent solution for Excel 2013..
- Open Excel, and click the Blank Template, to go to the Excel window.
- Click the File tab, and click Options, at the bottom of the list at the left.
- In the Options window, click the General category
- Scroll down to Start up Options, and remove the check mark from ‘Show the Start screen when this application starts’
- Click OK, to close the Options window.
Thanks. :>)