Dim dim
Author: s | 2025-04-24
Sub MergePPT3() Dim pp As Object Dim pptemplate As Object 'Dim headerbox As TextRange 'Dim contextbox As TextRange Dim x As Long Dim y As Long Dim sld As Slide Dim shp As Shape Dim ShpTxt As TextRange Dim TmpTxt As TextRange Dim FindList As Variant Dim ReplaceList As Variant Dim ExApp As Object Dim ExInput As Object Dim SuName As String Dim Sub MergePPT3() Dim pp As Object Dim pptemplate As Object 'Dim headerbox As TextRange 'Dim contextbox As TextRange Dim x As Long Dim y As Long Dim sld As Slide Dim shp As Shape Dim ShpTxt As TextRange Dim TmpTxt As TextRange Dim FindList As Variant Dim ReplaceList As Variant Dim ExApp As Object Dim ExInput As Object Dim SuName As String Dim
dim, dimmer, dimmest, dimming, dimmed, dims- WordWeb
3I had mItem as Object, instead of MailItem, but changing the data type did nothing. Last edited by Aussiebear; 12-27-2024 at 07:13 PM. 04-19-2006, 02:50 PM #4 Here is the code in its entirety. Perhaps there is something that I am doing that triggers the warning, but there is an alternative that would not? Option Explicit Sub SaveAllEmails_ProcessAllSubFolders() Dim i As Long Dim j As Long Dim n As Long Dim StrSubject As String Dim StrName As String Dim StrFile As String Dim StrReceived As String Dim StrSavePath As String Dim StrFolder As String Dim StrFolderPath As String Dim StrSaveFolder As String Dim Prompt As String Dim Title As String Dim iNameSpace As NameSpace Dim myOlApp As Outlook.Application Dim SubFolder As MAPIFolder Dim mItem As Object Dim FSO As Object Dim ChosenFolder As Object Dim Folders As New Collection Dim EntryID As New Collection Dim StoreID As New Collection Set FSO = CreateObject("Scripting.FileSystemObject") Set myOlApp = CreateObject("Outlook.Application") Set iNameSpace = myOlApp.GetNamespace("MAPI") Set ChosenFolder = iNameSpace.PickFolder If ChosenFolder = "" Then GoTo ExitSub: End If Prompt = "Please enter the path to save all the emails to." Title = "Folder Specification" StrSavePath = BrowseForFolder If StrSavePath = "" Then GoTo ExitSub: End If If Not Right(StrSavePath, 1) = "" Then StrSavePath = StrSavePath & "" End If Call GetFolder(Folders, EntryID, StoreID, ChosenFolder) If Not FSO.FolderExists("C:\Data") Then FSO.CreateFolder ("C:\Data") End If If Not FSO.FolderExists("C:\Data\Mail") Then FSO.CreateFolder ("C:\Data\Mail") End If For i = 1 To Folders.Count StrFolder = StripIllegalChar(Folders(i)) n = InStr(3, StrFolder, #2 Absolutely brilliant Thanx Erel! #3 That's absolutely awesome @ErelOnce again you have come up with the goods #4 Will you be integrating it into B4A? Like adding a shortcut to it in a menu somewhere #5 There are no plans to integrate it into the IDE. Last edited: Dec 23, 2013 #7 That's a very handy app. Thanks! #8 The code fails to get results if you have a json like this: [ "Item1", "Item2", "Item3", "Item4"] Maybe if just an array is detected omit adding the "For Each" loop to the code. Last edited: Dec 28, 2013 #9 It works fine: This is the exact code you need to use in order to access the items. #10 Thanks for this brillant tool! #11 It works fine: This is the exact code you need to use in order to access the items. Yes, you are correct, I understand now.Thanks. #12 I try to parse json string from glosbe witch is free tool dictionary and I could not understand where I am doing wrong .I am getting error ..object should be first initialized list. I tried to initialize the components but no result. Sometimes it works sometimes not.I use the folowing code I do a http utils job to retrive job.getstring from Sub parse_translation(detail As String)' sb As StringBuildersb.InitializeDim parser As JSONParserparser.Initialize(detail)Dim root As Map = parser.NextObject'Dim authors As Map = root.Get("authors")'Dim 2698 As Map = authors.Get("2698")'Dim id As Int = 2698.Get("id")'Dim U As String = 2698.Get("U")'Dim N As String = 2698.Get("N")'Dim 1 As Map = authors.Get("1")'Dim id As Int = 1.Get("id")'Dim U As String = 1.Get("U")'Dim N As String = 1.Get("N")'Dim 2877 As Map = authors.Get("2877")'Dim id As Int = 2877.Get("id")'Dim U As String = 2877.Get("U")'Dim N As String = 2877.Get("N")'Dim 25018 As Map = authors.Get("25018")'Dim id As Int = 25018.Get("id")'Dim U As String = 25018.Get("U")'Dim N As String = 25018.Get("N")'Dim 25115 As Map = authors.Get("25115")'Dim id As Int = 25115.Get("id")'Dim U As String = 25115.Get("U")'Dim N As String = 25115.Get("N")'Dim result As String = root.Get("result")'Dim dest As String = root.Get("dest")'Dim phrase As String = root.Get("phrase")'Dim from As String = root.Get("from")Dim tuc As List = root.Get("tuc")For Each coltuc As Map In tuc' Dim authors As List = coltuc.Get("authors")' For Each colauthors As Int In authors' Next' ' Dim meaningId As String = coltuc.Get("meaningId")' Dim meanings As List = coltuc.Get("meanings")' For Each colmeanings As Map In meanings' Dim text As String = colmeanings.Get("text")' Dim language As String = colmeanings.Get("language")' Next' Dim phrase As Map = coltuc.Get("phrase") Dim text As String = phrase.Get("text") Dim language As String = phrase.Get("language") sb.Append(text).Append(CRLF) msgbox(sb.tostring,"Glosbe Dictionary")Nextend sub ** Service (httputils2service) Create **** Service (httputils2service) Start **JobName = job_tr, Success = truemain_parse_translation (java line: 5082)java.lang.RuntimeException: ObjectDim Dim Light Song Download: Play Listen Dim Dim Light
#2 try this VBA Code: Sub GetIPAddresses() Dim TargetFolder As String Dim FileName As String Dim FullPath As String Dim RegexIPV4 As String Dim RegexIPV6 As String Dim IPV4Matches As Object Dim IPV6Matches As Object Dim IPV4Address As String Dim IPV6Address As String Dim IPV4Addresses As String Dim IPV6Addresses As String Dim IPV4Count As Integer Dim IPV6Count As Integer Dim I As Integer TargetFolder = InputBox("Please enter the path of the folder you wish To search:") FileName = Dir(TargetFolder & "*.xlsx") RegexIPV4 = "\b(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\b" RegexIPV6 = "\b(([0-9A-Fa-f]{1,4}:){7}[0-9A-Fa-f]{1,4})\b" IPV4Addresses = "" IPV6Addresses = "" IPV4Count = 0 IPV6Count = 0 While Len(FileName) > 0 FullPath = TargetFolder & FileName Set IPV4Matches = CreateObject("VBScript.RegExp") IPV4Matches.Pattern = RegexIPV4 Set IPV6Matches = CreateObject("VBScript.RegExp") IPV6Matches.Pattern = RegexIPV6 IPV4Matches.Global = TRUE IPV6Matches.Global = TRUE IPV4Matches.IgnoreCase = TRUE IPV6Matches.IgnoreCase = TRUE Set FoundIPV4Matches = IPV4Matches.Exec Set FoundIPV6Matches = IPV6Matches.Exec For I = 0 To FoundIPV4Matches.Count - 1 IPV4Address = FoundIPV4Matches.Item(I).Value IPV4Addresses = IPV4Addresses & IPV4Address & vbCrLf IPV4Count = IPV4Count + 1 Next For I = 0 To FoundIPV6Matches.Count - 1 IPV6Address = FoundIPV6Matches.Item(I).Value IPV6Addresses = IPV6Addresses & IPV6Address & vbCrLf IPV6Count = IPV6Count + 1 Next MsgBox ("IPV4 Addresses Found: " & IPV4Count & vbCrLf & IPV4Addresses & vbCrLf & vbCrLf & "IPV6 Addresses Found: " & IPV6Count & vbCrLf & IPV6Addresses) End Sub. Sub MergePPT3() Dim pp As Object Dim pptemplate As Object 'Dim headerbox As TextRange 'Dim contextbox As TextRange Dim x As Long Dim y As Long Dim sld As Slide Dim shp As Shape Dim ShpTxt As TextRange Dim TmpTxt As TextRange Dim FindList As Variant Dim ReplaceList As Variant Dim ExApp As Object Dim ExInput As Object Dim SuName As String DimBrr skim dim dim dim ringtone by mattyhum - Download on
. . ~-- Fm Pent Fm7 . . . . . . . . . . . . . . .. . G7 pent Cm(7M) . Gm pent Fm/Eb . Dm pent . Cm7 • Db pent . . . . . . . . . . . . . . . . . . Ebm7(9) D pent Ab7(#5) Eb pent Db7M . Db6 • • 53 PARTE IV . . __ sea as simetricas ~ • Escalas simetricas sao escalas construidas pela repeticiio ou alternancia de intervalos constantes. Nest» topico trataremos de ires tipos basicos de escalas simetricas: diminuta, de tons . . , . inteiros e cromatica. Nelson Faria 1. Escala diminuta Formada pela alternancia entre tons e semitons. ,,_ ... " t. C diminuta - e 0 1 1/2 1 - 1/2 .- - X3 1/2 1 -. -- • 1/2 1 Observando a simetria entre os graus da escala, podemos dizer que as escalas diminutas se equivalem em tercas menores, ou seja: C dim = Eb dim = Gb dim = A dim C# dim= E dim= G dim = Bb dim - Bdim Ddim - Fdim - Ab dim Exemplo: -e •• •• • • • • • • • •• •• • • C dim • • •• •• • •• •• •• •• • •• •• •• • • •• • • • ••• • • • • • • • • • • •• • • • • • • •• • • ••••• • • •• • • • • • • • •• • • • • • • •• • • • • • • • • •• •• • • • • • • • • • • • • • •• • • • • • • For a folder name Backup, if you don’t find it then just create a new one with capital B.5- Copy backup.dat to the Backup folder on your Nokia phone.6- Go back to your Nokia and press Done and disconnect the USB.7- On the Nokia go to Menu–>Settings–>Backup–>Restore backup–>Choose–>Contacts–>Done you will get a note Restoring data contacts and the phone will restart, wait a little until the phone power on and loading all your contacts.Import contacts from Outlook / Google contacts (CSV format):1) Export contacts from Google contacts into CSV format (I used the CSV for Outlook and other programs format)2) Open the CSV file in Excel and run an Excel macro against it which outputs a file called BACKUP.DAT.Macro Code:Option ExplicitSub OutputContacts() Dim ws As Worksheet Dim colCount As Integer Dim rowCount As Integer Dim s As String Dim r As Integer Dim c As IntegerDim fn As Integer Dim mn As Integer Dim ln As Integer Dim h As Integer Dim h2 As Integer Dim m As Integer Dim b As Integer Dim b2 As Integer Dim o As IntegerDim name As String‘ set up Set ws = ActiveSheet colCount = ws.UsedRange.Columns.Count rowCount = ws.UsedRange.Rows.Count Open ws.Parent.Path & “\backup.dat” For Output As #1‘ read the headings r = 1 For c = 1 To colCount s = ws.UsedRange.Cells(r, c).Value If s = “First Name” Then fn = c If s = “Middle Name” Then mn = c If s = “Last Name” Then ln = c If s =What is Dimming? An Introduction to Dimming LEDs
DPWORD = CreateObject("docuPrinter.WordMacro") DPWORD.CHBookmarks=true DPWORD.CInternetLink=true DPWORD.CCrosRef=true DPWORD.CCrosDoc=true DPWORD.LinkFootEnd=true DPWORD.CWordTextBox=true DPWORD.CDocInfo=true DPWORD.CBookNameDest=true DPWORD.CComNotes=true DPWORD.ConvertDocument docToConvert Set DPWORD = Nothing DPSDK.RestoreSettings Set DPSDK = Nothing MsgBox "Done converting!!!"End SubExample 4. Convert a MS Excel document into PDF fromVisual Basic Sub ExcelConverter() Dim docToConvert : docToConvert="c:\test.xls" Dim DPSDK : Set DPSDK = CreateObject("docuPrinter.SDK") DPSDK.BackupSettings DPSDK.DocumentOutputFormat = "PDF" DPSDK.DocumentOutputName = "demoXLS" DPSDK.DocumentOutputFolder = "c:" DPSDK.HideSaveAsWindow = true DPSDK.DefaultAction=1 DPSDK.ApplySettings Dim MSExcel : Set MSExcel = CreateObject("Excel.Application") MSExcel.DisplayAlerts = False Dim XLDoc : Set XLDoc = MSExcel.Workbooks.Open(docToConvert, 0, True) XLDoc.Activate XLDoc.PrintOut ,,, False, "docuPrinter" XLDoc.Saved = True XLDoc.Close MSExcel.Quit Set MSExcel = Nothing Dim RVal : RVal = DPSDK.Create ' Create output document If (RVal 0) Then MsgBox "Error while creating the document!!!" DPSDK.RestoreSettings Set DPSDK = Nothing MsgBox "Done converting!!!" End SubExample 5. Convert a MS PowerPoint document into PDF fromVisual BasicSub PowerPointConverter() Dim documentToConvert : documentToConvert="c:\test.ppt" Dim DPSDK : Set DPSDK = CreateObject("docuPrinter.SDK") DPSDK.BackupSettings DPSDK.DocumentOutputFormat = "PDF" DPSDK.DocumentOutputName = "demoPPT" DPSDK.DocumentOutputFolder = "c:" DPSDK.PDFAutoRotatePage = "PageByPage" DPSDK.HideSaveAsWindow = true DPSDK.DefaultAction=1 DPSDK.ApplySettings Dim MSPowerPoint Set MSPowerPoint = CreateObject("PowerPoint.Application") Dim PPTDoc Set PPTDoc = MSPowerPoint.Presentations.Open(documentToConvert, -1, 0, 0) PPTDoc.PrintOptions.PrintInBackground=0 PPTDoc.PrintOptions.PrintColorType=1 PPTDoc.PrintOptions.ActivePrinter="docuPrinter" PPTDoc.PrintOut 0 PPTDoc.Close MSPowerPoint.Quit Set MSPowerPoint = Nothing Dim RVal : RVal = DPSDK.Create ' Create output document If (RVal 0) Then MsgBox "Error while creating the document!!!" DPSDK.RestoreSettings Set DPSDK = Nothing MsgBox "Done converting!!!"End SubExample 6. Convert a PowerPoint document into PDF fromVisual Basic (usingthe docuPrinter PowerPoint Macro)Sub PowerPointConverter() Dim documentToConvert :documentToConvert="c:\test.ppt" Dim DPSDK : Set DPSDK = CreateObject("docuPrinter.SDK") DPSDK.BackupSettings DPSDK.DocumentOutputFormat = "PDF" DPSDK.DocumentOutputName = "demoPPT2" DPSDK.DocumentOutputFolder = "c:" DPSDK.PDFAutoRotatePage = "PageByPage" DPSDK.HideSaveAsWindow = true DPSDK.DefaultAction=1 DPSDK.ApplySettings Dim DPPPT : Set DPPPT =CreateObject("docuPrinter.PowerPointMacro") DPPPT.CTransition=true DPPPT.CHBookmarks=true DPPPT.CInternetLink=true DPPPT.CDocInfo=true DPPPT.ConvertDocument documentToConvert Set DPPPT = Nothing DPSDK.RestoreSettings Set DPSDK = Nothing MsgBox "Done converting!!!"End SubExample7. Convert a MS Access report into PDF from Visual Basic Sub AccessConverter() Dim DPSDK : Set DPSDK = CreateObject("docuPrinter.SDK") DPSDK.BackupSettings DPSDK.DocumentOutputFormat = "PS" DPSDK.DocumentOutputName = "demoAccess" DPSDK.DocumentOutputFolder = "c:" DPSDK.DocumentResolution = 300 DPSDK.HideSaveAsWindow = true DPSDK.DefaultAction=1 DPSDK.ApplySettings Dim objAccess Set objAccess = CreateObject("Access.Application") Dim defPrinter : defPrinter=DPSDK.GetDefaultPrinter DPSDK.SetDefaultPrinter "docuPrinter" objAccess.OpenCurrentDatabase "c:\access.mdb", true objAccess.DoCmd.OpenReport "rptCatalog", 0 'rptCtatalog is the repport name objAccess.Quit 2 Set objAccess=nothing RVal = DPSDK.Create ' Create output document If (RVal 0) Then MsgBox "Error. Create returns "+CStr(Rval) DPSDK.SetDefaultPrinter defPrinter DPSDK.RestoreSettings Set DPSDK = Nothing MsgBox "Done converting!!!" End SubExample8. Convert an URL / HTML into PDF from Visual Basic Sub URLConverter() Dim IE : Set IE = CreateObject("InternetExplorer.Application") IE.Visible=true Dim DPSDK : Set DPSDK = CreateObject("docuPrinter.SDK") DPSDK.BackupSettings IE.navigate2 "http:\\www.neevia.com" DPSDK.doSleep 100 While (IE.ReadyState4) or (IE.Busy) DPSDK.doSleep 100 Wend DPSDK.DocumentOutputFormat="PDF" DPSDK.DocumentOutputFolder="c:" DPSDK.DocumentOutputName="testURL" DPSDK.HideSaveAsWindow = true DPSDK.DefaultAction=1 DPSDK.ApplySettings Dim defPrinter : defPrinter = DPSDK.GetDefaultPrinter DPSDK.SetDefaultPrinter "docuPrinter" IE.ExecWB 6,2 Dim RVal : RVal = DPSDK.Create If (RVal 0) Then MsgBoxDim Dim Light - Official Video
"") + 1 StrFolder = Mid(StrFolder, n, 256) StrFolderPath = StrSavePath & StrFolder & "" StrSaveFolder = Left(StrFolderPath, Len(StrFolderPath) - 1) & "" If Not FSO.FolderExists(StrFolderPath) Then FSO.CreateFolder (StrFolderPath) End If Set SubFolder = myOlApp.Session.GetFolderFromID(EntryID(i), StoreID(i)) On Error Resume Next For j = 1 To SubFolder.Items.Count Set mItem = SubFolder.Items(j) StrReceived = ArrangedDate(mItem.ReceivedTime) StrSubject = mItem.Subject StrName = StripIllegalChar(StrSubject) StrFile = StrSaveFolder & StrReceived & "_" & StrName & ".msg" StrFile = Left(StrFile, 256) mItem.SaveAs StrFile, 3 Next j On Error GoTo 0 Next i ExitSub:End Sub Function StripIllegalChar(StrInput) Dim RegX As Object Set RegX = CreateObject("vbscript.regexp") RegX.Pattern = "[" & Chr(34) & "\!\@\#\$\%\^\&\*\(\)\=\+\|\[\]\{\}\`'\;\:\\?\/\,]" RegX.IgnoreCase = True RegX.Global = True StripIllegalChar = RegX.Replace(StrInput, "") ExitFunction: Set RegX = NothingEnd Function Function ArrangedDate(StrDateInput) Dim StrFullDate As String Dim StrFullTime As String Dim StrAMPM As String Dim StrTime As String Dim StrYear As String Dim StrMonthDay As String Dim StrMonth As String Dim StrDay As String Dim StrDate As String Dim StrDateTime As String Dim RegX As Object Set RegX = CreateObject("vbscript.regexp") If Not Left(StrDateInput, 2) = "10" And _ Not Left(StrDateInput, 2) = "11" And _ Not Left(StrDateInput, 2) = "12" Then StrDateInput = "0" & StrDateInput End If StrFullDate = Left(StrDateInput, 10) If Right(StrFullDate, 1) = " " Then StrFullDate = Left(StrDateInput, 9) End If StrFullTime = Replace(StrDateInput, StrFullDate & " ", "") If Len(StrFullTime) = 10 Then StrFullTime = "0" & StrFullTime End If StrAMPM = Right(StrFullTime, 2) StrTime = StrAMPM & "-" & Left(StrFullTime, 8) StrYear = Right(StrFullDate,. Sub MergePPT3() Dim pp As Object Dim pptemplate As Object 'Dim headerbox As TextRange 'Dim contextbox As TextRange Dim x As Long Dim y As Long Dim sld As Slide Dim shp As Shape Dim ShpTxt As TextRange Dim TmpTxt As TextRange Dim FindList As Variant Dim ReplaceList As Variant Dim ExApp As Object Dim ExInput As Object Dim SuName As String Dim Sub MergePPT3() Dim pp As Object Dim pptemplate As Object 'Dim headerbox As TextRange 'Dim contextbox As TextRange Dim x As Long Dim y As Long Dim sld As Slide Dim shp As Shape Dim ShpTxt As TextRange Dim TmpTxt As TextRange Dim FindList As Variant Dim ReplaceList As Variant Dim ExApp As Object Dim ExInput As Object Dim SuName As String DimDim - definition of dim by The Free Dictionary
For the designated string beginning on the right, not left as Instr does.Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim recips As Outlook.Recipients Dim recip As Outlook.Recipient Dim pa As Outlook.PropertyAccessor Dim prompt As String Dim strMsg As String Dim Address As String Dim lLenConst PR_SMTP_ADDRESS As String = " recips = Item.Recipients For Each recip In recips Set pa = recip.PropertyAccessor Address = LCase(pa.GetProperty(PR_SMTP_ADDRESS)) lLen = Len(Address) - InStrRev(Address, "@") Select Case Right(Address, lLen) Case "cdolive.com", "slipstick.com", "outlookmvp.com" Case Else ' remove case else line to be warned when sending to the addresses strMsg = strMsg & " " & Address & vbNewLine End Select NextIf strMsg "" Then prompt = "This email will be sent outside of the company to:" & vbNewLine & strMsg & vbNewLine & "Please check recipient address." & vbNewLine & vbNewLine & "Do you still wish to send?" If MsgBox(prompt, vbYesNo + vbExclamation + vbMsgBoxSetForeground, "Check Address") = vbNo Then Cancel = True End If End IfEnd SubCheck for different domainsFrank wanted to check to see if a message was being sent to two different domains and if so, trigger a warning. (This code skips addresses in the sending account's domain.)To do this, we need to create a string containing the message recipients then split it into an array. We compare the members of the array and if any two don't match, trigger the warning message. If you say Yes the first time the warning comes up, the macro exits and the message is sent. If you want to continue checking addresses after clicking Yes, remove the Exit Sub after the prompt.Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim recips As Outlook.Recipients Dim recip As Outlook.Recipient Dim pa As Outlook.propertyAccessor Dim prompt As String Dim strMsg As String Dim Address As String Dim lLen Dim arr Dim strMyDomain Dim userAddress Const PR_SMTP_ADDRESS As String = " ' non-exchange' userAddress = Session.CurrentUser.Address' use for exchange accountsuserAddress = Session.CurrentUser.AddressEntry.GetExchangeUser.PrimarySmtpAddresslLen = Len(userAddress) - InStrRev(userAddress , "@")strMyDomain = Right(userAddress, lLen)Set recips = Item.Recipients For Each recip In recips Set pa = recip.propertyAccessor Address = LCase(pa.GetProperty(PR_SMTP_ADDRESS)) lLen = Len(Address) - InStrRev(Address, "@")str1 = Right(Address, lLen)If str1 strMyDomain ThenstrRecip = str1 & "," & strRecipEnd IfNext arr = Split(strRecip, ",")' need to subtract one because string ends with a ,For i = LBound(arr) To UBound(arr) - 1 For j = LBound(arr) To i If arr(i) arr(j)Comments
3I had mItem as Object, instead of MailItem, but changing the data type did nothing. Last edited by Aussiebear; 12-27-2024 at 07:13 PM. 04-19-2006, 02:50 PM #4 Here is the code in its entirety. Perhaps there is something that I am doing that triggers the warning, but there is an alternative that would not? Option Explicit Sub SaveAllEmails_ProcessAllSubFolders() Dim i As Long Dim j As Long Dim n As Long Dim StrSubject As String Dim StrName As String Dim StrFile As String Dim StrReceived As String Dim StrSavePath As String Dim StrFolder As String Dim StrFolderPath As String Dim StrSaveFolder As String Dim Prompt As String Dim Title As String Dim iNameSpace As NameSpace Dim myOlApp As Outlook.Application Dim SubFolder As MAPIFolder Dim mItem As Object Dim FSO As Object Dim ChosenFolder As Object Dim Folders As New Collection Dim EntryID As New Collection Dim StoreID As New Collection Set FSO = CreateObject("Scripting.FileSystemObject") Set myOlApp = CreateObject("Outlook.Application") Set iNameSpace = myOlApp.GetNamespace("MAPI") Set ChosenFolder = iNameSpace.PickFolder If ChosenFolder = "" Then GoTo ExitSub: End If Prompt = "Please enter the path to save all the emails to." Title = "Folder Specification" StrSavePath = BrowseForFolder If StrSavePath = "" Then GoTo ExitSub: End If If Not Right(StrSavePath, 1) = "" Then StrSavePath = StrSavePath & "" End If Call GetFolder(Folders, EntryID, StoreID, ChosenFolder) If Not FSO.FolderExists("C:\Data") Then FSO.CreateFolder ("C:\Data") End If If Not FSO.FolderExists("C:\Data\Mail") Then FSO.CreateFolder ("C:\Data\Mail") End If For i = 1 To Folders.Count StrFolder = StripIllegalChar(Folders(i)) n = InStr(3, StrFolder,
2025-03-28#2 Absolutely brilliant Thanx Erel! #3 That's absolutely awesome @ErelOnce again you have come up with the goods #4 Will you be integrating it into B4A? Like adding a shortcut to it in a menu somewhere #5 There are no plans to integrate it into the IDE. Last edited: Dec 23, 2013 #7 That's a very handy app. Thanks! #8 The code fails to get results if you have a json like this: [ "Item1", "Item2", "Item3", "Item4"] Maybe if just an array is detected omit adding the "For Each" loop to the code. Last edited: Dec 28, 2013 #9 It works fine: This is the exact code you need to use in order to access the items. #10 Thanks for this brillant tool! #11 It works fine: This is the exact code you need to use in order to access the items. Yes, you are correct, I understand now.Thanks. #12 I try to parse json string from glosbe witch is free tool dictionary and I could not understand where I am doing wrong .I am getting error ..object should be first initialized list. I tried to initialize the components but no result. Sometimes it works sometimes not.I use the folowing code I do a http utils job to retrive job.getstring from Sub parse_translation(detail As String)' sb As StringBuildersb.InitializeDim parser As JSONParserparser.Initialize(detail)Dim root As Map = parser.NextObject'Dim authors As Map = root.Get("authors")'Dim 2698 As Map = authors.Get("2698")'Dim id As Int = 2698.Get("id")'Dim U As String = 2698.Get("U")'Dim N As String = 2698.Get("N")'Dim 1 As Map = authors.Get("1")'Dim id As Int = 1.Get("id")'Dim U As String = 1.Get("U")'Dim N As String = 1.Get("N")'Dim 2877 As Map = authors.Get("2877")'Dim id As Int = 2877.Get("id")'Dim U As String = 2877.Get("U")'Dim N As String = 2877.Get("N")'Dim 25018 As Map = authors.Get("25018")'Dim id As Int = 25018.Get("id")'Dim U As String = 25018.Get("U")'Dim N As String = 25018.Get("N")'Dim 25115 As Map = authors.Get("25115")'Dim id As Int = 25115.Get("id")'Dim U As String = 25115.Get("U")'Dim N As String = 25115.Get("N")'Dim result As String = root.Get("result")'Dim dest As String = root.Get("dest")'Dim phrase As String = root.Get("phrase")'Dim from As String = root.Get("from")Dim tuc As List = root.Get("tuc")For Each coltuc As Map In tuc' Dim authors As List = coltuc.Get("authors")' For Each colauthors As Int In authors' Next' ' Dim meaningId As String = coltuc.Get("meaningId")' Dim meanings As List = coltuc.Get("meanings")' For Each colmeanings As Map In meanings' Dim text As String = colmeanings.Get("text")' Dim language As String = colmeanings.Get("language")' Next' Dim phrase As Map = coltuc.Get("phrase") Dim text As String = phrase.Get("text") Dim language As String = phrase.Get("language") sb.Append(text).Append(CRLF) msgbox(sb.tostring,"Glosbe Dictionary")Nextend sub ** Service (httputils2service) Create **** Service (httputils2service) Start **JobName = job_tr, Success = truemain_parse_translation (java line: 5082)java.lang.RuntimeException: Object
2025-04-08#2 try this VBA Code: Sub GetIPAddresses() Dim TargetFolder As String Dim FileName As String Dim FullPath As String Dim RegexIPV4 As String Dim RegexIPV6 As String Dim IPV4Matches As Object Dim IPV6Matches As Object Dim IPV4Address As String Dim IPV6Address As String Dim IPV4Addresses As String Dim IPV6Addresses As String Dim IPV4Count As Integer Dim IPV6Count As Integer Dim I As Integer TargetFolder = InputBox("Please enter the path of the folder you wish To search:") FileName = Dir(TargetFolder & "*.xlsx") RegexIPV4 = "\b(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\b" RegexIPV6 = "\b(([0-9A-Fa-f]{1,4}:){7}[0-9A-Fa-f]{1,4})\b" IPV4Addresses = "" IPV6Addresses = "" IPV4Count = 0 IPV6Count = 0 While Len(FileName) > 0 FullPath = TargetFolder & FileName Set IPV4Matches = CreateObject("VBScript.RegExp") IPV4Matches.Pattern = RegexIPV4 Set IPV6Matches = CreateObject("VBScript.RegExp") IPV6Matches.Pattern = RegexIPV6 IPV4Matches.Global = TRUE IPV6Matches.Global = TRUE IPV4Matches.IgnoreCase = TRUE IPV6Matches.IgnoreCase = TRUE Set FoundIPV4Matches = IPV4Matches.Exec Set FoundIPV6Matches = IPV6Matches.Exec For I = 0 To FoundIPV4Matches.Count - 1 IPV4Address = FoundIPV4Matches.Item(I).Value IPV4Addresses = IPV4Addresses & IPV4Address & vbCrLf IPV4Count = IPV4Count + 1 Next For I = 0 To FoundIPV6Matches.Count - 1 IPV6Address = FoundIPV6Matches.Item(I).Value IPV6Addresses = IPV6Addresses & IPV6Address & vbCrLf IPV6Count = IPV6Count + 1 Next MsgBox ("IPV4 Addresses Found: " & IPV4Count & vbCrLf & IPV4Addresses & vbCrLf & vbCrLf & "IPV6 Addresses Found: " & IPV6Count & vbCrLf & IPV6Addresses) End Sub
2025-04-05