Python Forum
deactivate compatibility pop up with excel files
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
deactivate compatibility pop up with excel files
#1
Hello,

I have a program, that save all xlsx files in xls format. But there is always a pop up that checks the compatibility. How can I skip this pop up with python? I tried to extract it with wb.DisplayAlerts = False and wb.DoNotPromptForConvert = False, but the pop up is still activated.
HEre is the code:

import glob
from win32com.client import Dispatch

for file in glob.glob('C:\Users\iiii\Desktop\python\files\*.xlsx'):
    xl = Dispatch('Excel.Application')
    wb = xl.Workbooks.Add(file)
    wb.SaveAs(file[:-1], FileFormat=56)
    xl.Quit()
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Copy Paste excel files based on the first letters of the file name Viento 2 423 Feb-07-2024, 12:24 PM
Last Post: Viento
  How to loop through all excel files and sheets in folder jadelola 1 4,461 Dec-01-2022, 06:12 PM
Last Post: deanhystad
  How to deactivate correctly a conda environment NoNameoN 2 1,897 Nov-04-2022, 01:43 PM
Last Post: NoNameoN
  Creating csv files from Excel file azizrasul 40 5,582 Nov-03-2022, 08:33 PM
Last Post: azizrasul
  Working with excel files arsouzaesilva 6 3,150 Sep-17-2021, 06:52 PM
Last Post: arsouzaesilva
  win32com — How to resolve “AttributeError: xlUp” for Excel files? JaneTan 2 4,214 Aug-18-2021, 05:27 AM
Last Post: snippsat
  Windows compatibility Astrikor 19 5,278 Aug-10-2021, 01:38 PM
Last Post: Luckk
  code to read files in folders and transfer the file name, type, date created to excel Divya577 0 1,856 Dec-06-2020, 04:14 PM
Last Post: Divya577
  Creating Excel files compatible with microsoft access vkallavi 0 1,585 Sep-17-2020, 06:57 PM
Last Post: vkallavi
  Merging Excel Files JezMim 1 1,895 Sep-06-2020, 08:56 PM
Last Post: bowlofred

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020