I have the following code: import win32com.clientimport os
file1= r'C:\\Users\file.xlxm' def refresher(): if os.path.exists(file1): xl = win32com.client.DispatchEx("Excel.Application") xl.Workbooks.Open(Filename=file1,ReadOnly=1) xl.Visible = 1 xl.Workbooks(1).Close(SaveChanges=1) xl.Application.Quit() del xl refresher() Which gets me into the file, but I am unsure of how to refresh a ODBC connected table that requires a simple form submission of user credentials. The current settings dont allow me to save credentials so a script seems to be the only solution. Any suggestions? This will allow me to quickly update my models without have to do it manually in excel. Thanks! -- ----- Carl E. Evans | Economist
_______________________________________________ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32