VLAN traffic is restricted to untagged (which gets tagged) or only tagged VLAN20.
]]>If VLAN 20 traffic is restricted, how does the phone still work ?
]]>So somewhere in your project you need to make a reference to the outlook library. Should be “Microsoft Outlook 16.0 Object Library”. If you are in VS 2019 or 2022 and making a .Net app it would be under “My Project” -> “References” -> “Add” then look through the COM list. Otherwise it doesn’t know what to do with that line.
]]>Thanks for the response :-). I am not a trained programmer so maybe that could be part of the issue but I want to learn.
When I put a watch on the objOL.ActiveExplorer I get the following error message (unfortunately it is in Dutch) but basically it seems to be that he cannot convert tot het Outlook_application. Interface is not registered he says.
Kan COM-object van het type Microsoft.Office.Interop.Outlook.ApplicationClass niet converteren naar interfacetype Microsoft.Office.Interop.Outlook._Application. Deze bewerking is mislukt doordat de QueryInterface-aanroep voor het COM-onderdeel voor de interface met IID {00063001-0000-0000-C000-000000000046} is mislukt door de volgende fout: Interface is niet geregistreerd (Uitzondering van HRESULT: 0x80040155).
]]>It’s almost like objOL.ActiveExplorer is null. So in the first couple lines:
Dim objOL As New Microsoft.Office.Interop.Outlook.Application
Should be successful and objOL should not be nothing. If it is then yeah the next lines will fail. You can try to force it to a value just to make sure, something like:
If val(objOL.ActiveExplorer.Selection.Count) > 1
But otherwise I’m not sure why it would throw that error. This is a little old so maybe the interop libraries are outdated but were still using it daily in a program so it definitely does work. Make sure you have referenced that interop library in your program? Is there a inner message on the error?
]]>Yes but I have never tried it. You will want to search for “VBA Folder Picker”. It will be something like this that would go after the current “HostFolder” line (so you have a default value and then the one the user selects)
With Application.FileDialog(msoFileDialogFolderPicker)
If .Show = -1 Then ‘ if OK is pressed
HostFolder = .SelectedItems(1)
End If
End With
I have just dowloaded Your VBA script to convert VSD files to VSDX. It’s running perfectly
Question: is it possible in VBA to present the users to select the root folder instead of writing the path in VBA (ex. HostFolder = “C:\Temp\” ? If Yes, how can I change the VBA Code?
Kind regards,
Pascal