This is a windows pure C language version of a urlencode() function.Sometimes, when I need simple tools and self contained windows EXEs (“just run it”, no “dll”s to copy or register), I find it simpler to code in C than in other languages. Particularly when you want to link with specialized libraries available only in… Continue reading A pure (windows) “C” version of urlencode
In a previous post I briefly explained how you can compile the free zlib library with Visual 2013 Studio and produce a 32 and a 64 bits dll that you can then use in VBA (Word, Excel, Access, etc…). If you follow this link to the article, you can even download the binaries I baked.… Continue reading Using the free zip library in VBA
I was working last week on a Microsoft Access application and I needed to get some data from a webserver running Apache/PHP. Exchanging data with the server was easy, the WinHTTP and XML ActiveX library components are really cool and easy to use for that. But then I came unto some unexpected trouble when I… Continue reading How to get the same result in VBA and in PHP computing a CCITT CRC checksum
Accessing the clipboard in Windows becomes quite tricky in VBA, particularly if you have to stay 32 and 64 bits compatible. Here’s my compilation of portable routines, inspired by MSDN, Internet scraping and good sense. First the Declares section (I know, it pours out of the frame on the right, just select and copy the… Continue reading Share the Clipboard with VBA and the Windows API
If you try to open a connection to an Access database via ADO, you’ll have to use a different provider, whether you’re coding for 32 or 64 bits environments. Here’s a utility function I use for that (updated 25.02.2014):
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
Public Function ADOGetAccessConnString(ByVal psDatabasePathname As String) As String Dim sConnString As String #If Win64 Then sConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & psDatabasePathname #Else If GetFileExt(psDatabasePathname) = "accdb" Then sConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & psDatabasePathname Else sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & psDatabasePathname End If #End If ADOGetAccessConnString = sConnString End Function |
Of course you have to have the correct jet engine files installed on the target… Continue reading Microsoft Access Databases ADO connection strings for 32/64 bits
I you need zip compression in your development project, the zlib library is a good and free solution. There’s however a bit of googling necessary to achieve a successful compilation with VS2013, especially for generating the 32 bits version of the library. As I just needed it for some VB/VBA integration, I had to sort… Continue reading Compiling the zlib compression library with Visual Studio 2013
One of the useful uses of the Windows API, back in the old days of 32 bits programming, was to use the shell’s standard dialogs for browsing for a folder or picking a file. VB/VBA didn’t have a way to do that, whereas today, modern VB, I mean VBA7 of course (today’s “Visual Basic” denomination… Continue reading Shell Hell for VBA 64 bits
Introduction TCP et IP ont été développé par l’agence de projets de recherche avancée (DARPA, Defense Advanced Research Project Agency) du département de la défense américaine (DOD), en 1969, dans le cadre du projet de recherche ARPANET (Advanced Research Project Agency Network) visant à connecter des réseaux conçus par différents fournisseurs en un super-réseau, le… Continue reading Les méandres de TCP/IP (2002)
We were 8 fresh MBA buddies less than two years ago who teamed to create the ISMA (information Security Management Association) and our new website just got a lifting recently, just after we organized our first “security talk”. The ISMA website, keep tuned there for more updates about our activities.
Vous en avez sûrement déjà entendu parler.Voici les deux premières vidéos publicitaires avec Bill et Jerry: [youtube=http://www.youtube.com/watch?v=7SiBBi35zKY&hl=en&fs=1&color1=0x2b405b&color2=0x6b8ab6] [youtube=http://www.youtube.com/watch?v=gBWPf1BWtkw&hl=en&fs=1&color1=0x2b405b&color2=0x6b8ab6] Je les trouve les deux géniales. Mais quelle est donc la stratégie de Microsoft ici ?
Recent Comments