objexcel

Gentlemen, I am running this code via task scheduler, and the workbook is closed when it runs. At the end of the process, it gives me the following error; however, all the expected processes are perfect. I have also run the macro manually, and it works as expected. I suspect the VBS code has...

Guys, Please can anyone throw some suggestions on the error when the script is run turns the excel file property to read only.

My employer upgraded from Office 2007 to Office 365. I have an Access db that gathers/opens data from and Excel file and everything was working file in 2007. Now, the code will FREEZE below on the SET. In the References, I do have Microsoft Excel 16.0 Object Library. Dim objExcel As...

Calling Excel from Word.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a sub in Excel called ChooseRegion, Excel syntax:<o:p></o:p> ChooseRegion 2<o:p></o:p> Or <o:p></o:p> Call ChooseRegion(2)<o:p></o:p> <o:p></o:p> I have a Sub called Reset which...