24 April 2018

Save text file UTF-8 encoded with VBA

Dim txt AS New ADODB.Command

With txt
 .Type = adTypeText
 .Charset = "utf-8"
 .Open
 
 .WriteText "special characters: äöüß"
 .WriteText "", adWriteLine    ' add an empty line, like WriteLine()
 .WriteText "another special characters: äöüß"
 
 .SaveToFile FileName, adSaveCreateOverWrite
 .Close
End With

Set txt = nothing


My version, from stackoverflow.com

17 April 2018

Virtual Box Bridged networking not working in Virtualbox under Windows 10

This fix this problem:

Enable "Windows 8" compatibility for VirtualBox executable: right-click on VirtualBox shortcut>Properties: in Properties dialog box: switch to "Compatibility" tab, under "Compatibility mode" section, select the check box next to: "Run this program in compatibility mode", make sure "Windows 8" is selected in combo box. click Ok, run VirtualBox again! (it's not needed to run as Administrator)


Via: https://stackoverflow.com/a/40204718