spotforless.blogg.se - Excel ole action fix

#EXCEL OLE ACTION FIX CODE#

This, however, seems like a horrible idea, since there might actually be cases where I do need to be alerted.

#EXCEL OLE ACTION FIX CODE#

Therefore, I guess I'm not encountering an error (also it doesn't trigger the error handlers), but rather something like a timeout.Īs suggested on other sources, I do wrap my code into Application.DisplayAlerts = False.

In both cases, when I OK through all the reappearing prompts, the code will eventually finish with the desired results.

When run on a smaller scale (for example, when querying less records or using less complex templates), both codes do run smoothly.

, CreateBookmarks:=wdExportCreateNoBookmarks _

, OptimizeFor:=wdExportOptimizeForPrint _ Run "quelle_aendern", rst!DataSource, rst!Sql Stroutfile = fCheckPath(rst!outpath, True) & Application.PathSeparator & rst!outfile Enable the Ignore other application that use DDE feature. Ive checked online and tried these two things: 1. Documents.Open rst!inpath & Application.PathSeparator & rst!infile 'Microsoft Excel is waiting for another application to complete an OLE Action'. If rst!Verarbeiten And Not IsNull(rst!Verarbeiten) Then If sErr = vbNullString Then sErr = "Keine Fehler"ĬreateDB = "Zeit: " & Now & " | Dauer: " & Format(dTime, "hh:mm:ss") & " | Anzahl Fehler: " & iErr & vbCrLf & sErrĬreate mail merges from Excel in a Word.Application, using existing and rather large .docm-templates and dynamic SQL-queries that returns the receipents Set rst = GetRecordset(ThisWorkbook.Sheets("Parameter").Range("A1:S100")) Number & " | " & Replace(.Description, vbCrLf, vbNullString) DBEngine.CreateDatabase(pathDB, dbLangGeneral)įor Each statement In Split(sql, " " & vbNewLine)

Public Function createDB(pathDB As String, pathSQL As String) As Stringĭim statement As Variant, file As Variant

OLE was originally an acronym for Object Linking and Embedding. OLE is a mechanism that allows users to create and edit documents containing items or objects created by multiple applications. Two recent examples (I recon the code is less important):Ĭreating an accdb-Database from Excel with an Access.Application and populating it by running rather complex SQL-queries on large amount of data. What does OLE mean in Microsoft Word Object Linking and Embedding. How can I deal with this in an appropriate fashion? This only happens when automating lengthy tasks. When automating other MS-Office applications with excel, I frequently get ok-only prompts saying that Microsoft Excel is waiting for another application to complete an OLE action.