You will receive an error similar to the one below. So, if you have SQL Servers that have TLS 1.0 Server disabled, you will no longer be able to use this feature. This provider is an older MDAC/WDAC provider (see Data Access Technologies Road Map below) that comes built into the Operating System (including Windows 10) but DOES NOT support TLS 1.1+. The problem with this feature lies in the fact that this menu option will, by default, leverage SQLOLEDB.1 as the OLE DB provider when connecting to SQL Server. See the screen print below from Excel 2016. What you may NOT know is that there is a popular feature in Excel to import data from SQL Server. You may also know that Microsoft has provided TLS 1.1/1.2 patches for the SQL Server Database Engine (2008+) as well as the client connectivity components (see TLS 1.2 support for Microsoft SQL Server below). make Excel freeze and wait while SAP does its thing? (don't know if that makes sense.) - BTW, Tried with Application.As you may know, TLS 1.0 is being deprecated due to various known exploits and will no longer be PCI compliant as of June 30th, 2018 (see PCI DSS v3.1 and SSL: What you should do NOW below). Make it automatically click OK every time it apearsģ. So, can anyone help me achieve one of the three solutions i can think of:Ģ.
My laptop is from work and i cannot install any additional software or updates to it without permission so please give me alternative solutions if you had that in mind.Ģ.I tried checking the Excel option for DDE, but it only gives me an error when i try to run the script: I searched the net and the site, but there was barely any usefull info maybe because my question is to specific.
I tried turning it off withĪpplication.DisplayAlerts = False, but it would not works, instead gives me: When doing it without a macro, SAP does not give me any error. So i have to click OK in order to continue, which is annoying because then it pops-up non-stop and i have to do it like 10-15 times in order to reach the goal, which removes the point of automation. So all is fine, but for one of the parts SAP makes a lot of calculations which takes a few minutes and around the middle of it, Excel generate the message: Set Application = SapGuiAuto.GetScriptingEngine So i am recording a series of procedures, pasting the code in a macro sheet and make the Excell read the VBS code with the following commands: Dim SapGuiAuto AsObject i have the following issue trying to automate a process in SAP for my current position. I am fairly new to SAP scripting, but have some experience with VBA already.
0 kommentar(er)
