[RESOLVED] Is there a way to determine who opened an Excel workbook?

[doasidont]

We have Excel workbooks that are currently opened manually. When opened, SFTP download macros are automatically executed. We will be automating the opening of these workbooks via Windows scheduled tasks so that the downloads are done automatically each morning.

First, does anyone have any examples of job streams (MSDOS .bat files) that open Excel and Access and auto execute macros?

Second, is there a way to determine if the Excel workbook was opened manually by a user or opened via a scheduled .bat file task? It's important to know how the workbooks were opened.

Thanks.

[opus]

I don't think so, however while using a bat you are in control of who is opening. Just use the bat-file to create a value/setting etc to show it was open by the bat-file.

[westconn1]

you can use the commandline arguments to pass some parameter when auto opening the file, so that you know it was not opened manually, you would need to use APIs to get the commandline

their is also a last author builtin document property, but i assume that will be the person previous to the current opening of the workbook

[doasidont]

Thank you. I'll use GetCommandLine.

[westconn1]

the API getcommandline as string will just crash excel

see the last post in this thread for how to do it
http://www.vbforums.com/showthread.php?t=634313

[doasidont]

Thank you.