Fix Gen Cache and Win32 issues

I have constant problems with Win32, dll and gen.py. This has been going on for two weeks now, ever since I added a new computer and a remote on GCP. Here's the error code: See the caveats in the documentation: [login to view URL] data['Datetime']=data['Datetime'].dt.tz_localize(None) Traceback (most recent call last): File "[login to view URL]", line 74, in <module> excel = [login to view URL]('[login to view URL]') File "C:\Users\rodmaciver\AppData\Local\Programs\Python\Python36\lib\site-packages\win32com\client\[login to view URL]", line 531, in EnsureDispatch mod = EnsureModule(tla[0], tla[1], tla[3], tla[4], bForDemand=bForDemand) File "C:\Users\rodmaciver\AppData\Local\Programs\Python\Python36\lib\site-packages\win32com\client\[login to view URL]", line 388, in EnsureModule module = GetModuleForTypelib(typelibCLSID, lcid, major, minor) File "C:\Users\rodmaciver\AppData\Local\Programs\Python\Python36\lib\site-packages\win32com\client\[login to view URL]", line 263, in GetModuleForTypelib AddModuleToCache(typelibCLSID, lcid, major, minor) File "C:\Users\rodmaciver\AppData\Local\Programs\Python\Python36\lib\site-packages\win32com\client\[login to view URL]", line 559, in AddModuleToCache SetTypelibForAllClsids([login to view URL]) AttributeError: module 'win32com.gen_py.00020813-0000-0000-C000-000000000046x0x1x9' has no attribute 'CLSIDToClassMap' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "[login to view URL]", line 80, in <module> excel = [login to view URL]('[login to view URL]') File "C:\Users\rodmaciver\AppData\Local\Programs\Python\Python36\lib\site-packages\win32com\client\[login to view URL]", line 531, in EnsureDispatch mod = EnsureModule(tla[0], tla[1], tla[3], tla[4], bForDemand=bForDemand) File "C:\Users\rodmaciver\AppData\Local\Programs\Python\Python36\lib\site-packages\win32com\client\[login to view URL]", line 444, in EnsureModule if [login to view URL] != tlbAttributes[4] or genpy.makepy_version != module.makepy_version: AttributeError: module 'win32com.gen_py.00020813-0000-0000-C000-000000000046x0x1x9' has no attribute 'MinorVersion' [INFO] Processing file Calculations Books\2021_07_26_03-01_PM\[login to view URL] Press any key to continue . . . I use Python programs to access databases and download stock price data into complex Excel spreadsheets that run all day long identifying stock price patterns. When I notice an error or a possible improvement, I stop the program and modify the Excel formulas. When I do that, on some of my computers -- I have 4, three locals and a remote -- it generates a [login to view URL] temp file, and that file shuts the whole program down. For this task I need someone who knows this issue well and has fixed it before. I already have someone who can figure it out, kind of. His solution works until it doesn't, then he has to spend two hours fixing it again. When I first encountered this problem a year or so ago, I found someone who fixed it in a few minutes. That contractor is no longer available. Again, to emphasize, I'm not looking for someone who kind of knows the problem, kind of doesn't, but thinks he can figure it out. If it takes you a few minutes, I'll pay you for an hour. If it takes you more than an hour, you are not the right person for this particular task. For the right person, I have constant Python projects. Please respond if: • You have experience with Python setup. • have an excellent rating on this platform or can provide client references • are available to discuss (not via Chat) the project and are fluent, easy to understand in English. • Have a functioning microphone. • are available to work on this today or it not today, soon.