Can someone tell me how to create a new workbook? I'm trying to open one with this:
<font class="small">Code:</font><hr /><pre>
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\New_users.xls")
but I'm getting the following error:
"C:\New_users.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.
If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted."
I feel like I already know this but for the life of me can't remember. and all the searches I've done only show how to open an existing workbook...
A good rule of thumb is to never measure with your thumb.