Ok I got it to work almost. I now understand what you mean when you say: "Open returns a handle in XLBookHandle which should be used to reference the workbook in other XL commands." But what if the excel file has been opened already by another program and it has NOT been saved to my computer. Does t...

Still getting the same error. I took out the "XLOpen" line because the file is already open. Using the debug tool the error happens on the XLSelectRange line. I also tried saving the Book1 file to my desktop and using the XLOpen with full file location but it made no difference. I know I have to be ...

VERY new here. My first post after just a few macros. Im trying to use ANY of the Excel Functions but keep getting the "Access Violation error". I have a program running that spits out an excel file using the default Book1 name. I need Scheduler to just select and copy some cells and then close out ...