Hi

I've got an issue but not sure if it's related to excel or to the batch code I use.

I'm using a batch file so that I can schedule a process to run the file "Book1.xls".

When I run the batch file, which opens Book1.xls, it gives me this error when I use the code Application.Workbooks("Book2.xls").Close {where I use Book1.xls to close the (already) open excel Book2.xls}

But when I run Book1.xls by double-clicking and enabling macros, it runs perfectly.

Any ideas in terms of batch code? This is the code I'm using:

@echo off

echo off

SET PROD_Folder=S:\General\Team\

"C:\Program Files\OFFICE11\EXCEL.EXE" "E:\Excel_Practise\Book1.xls" /p".\" /e

echo Copy to prefered location!

copy "E:\Excel_Practise\Book2.xls" "%PROD_Folder%Book2.xls"

echo DONE!

exit

* My excel code saves the file Book1.xls and places it as Book2.xls at the "PROD_Folder" location.

Can anyone help me on this?

Justin

i'm thinking you either need to digitally sign the workbook or make the folder it's in a trusted location. the problem i believe is the fact that you have to click enable macros, which you can't do with a batch file.

In Excel, try going to File > Options > Trust Center, then clicking on the "Trust Center Settings" button, then on the "Add New Location" button and take it from there.

Never tried signing a workbook, but that functionality is usually on the Start Menu > Microsoft Office > Microsoft Office 2010 Tools > Digital Certificate For VBA Projects

Good luck, gonna be away from comp, let me know if you figure it out

Mike

Thanks Mike... Well that doesn't really help me out much!

My problem is that when i run my batch file, it opens my excel and runs the macro automatically but gives me an error at the above mentioned line.

Well if I open the excel manually and run the macro, it executes line where the error used to occur and gives me my required output.

Need some real help on this one!!

Justin

when you open the workbook manually, do you have to click options, then click enable macros?