bassms.blogg.se

The thing is that we have over a thousand files and this solution would take us too much time.

We know that we could fix it by replacing these instructions with the compatible ones. The driver MySQL ODBC 3.51 Driver is not compatible with Office 365. Here is the second example of the code: cn.Open "Driver=" & _ Choose Unicode (UTF-8) in the File Origin dropdown menu, and click Transform Data. After selecting a CSV file you want to open, you will see the following popup window.

The declaration Private Declare Function is not compatible with Office 365. Start by opening Excel and creating a blank spreadsheet (File->New) Under the Data main menu, click the From Text/CSV icon in the toolbar. Private Declare Function WritePrivateProfileString Lib "kernel32" Alias "WritePrivateProfileStringA" ( _ Private Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" ( _ Here is the first example of the code: Option Explicit The problem is that we have over a thousand Excel files and it's not possible to modify every each of them. We refer to something like right clicking the file and opening it in another way or Excel 365 being able to recognize the source of the problem and trying to open it in another way.

Is it possible to open an Excel file developed with Office 2016 (32 bit) which includes incompatible instructions (in macros) with Office 365 (64 bit) from Office 365 (64 bit)? Like an add-in or something.