search

michaelneu / webxcel

🤔 A REST backend built with plain VBA Microsoft Excel macros. Yes. Macros.
https://dev.to/michaelneu/to-vba-and-beyond---building-a-restful-backend-using-plain-microsoft-excel-macros-76n
MIT License
438 stars 70 forks source link

implement tcp interop layer for Office on mac OS #9

Open michaelneu opened 5 years ago

michaelneu commented 5 years ago

Wrap wsock32 in an if guard like this to prevent importing missing functions on macOS (Win32 is True for both 32 and 64 bit Windows):

#If Win32 Then

' imports

#End If

Add a similar file for macOS, to allow for socket connections there.

Then rename TcpServer to TcpServerWindows, add a superclass ITcpServer and ITcpClient and select the appropriate tcp server/client based on the operating system.

jzajac2 commented 5 years ago

Sounds like a big one. webxcel is my first goto (out of about 15 other options) for getting a project up and running soon, and working off my macbook. Does this gap mean I can't do local development unless I wire up a windows box?

michaelneu commented 4 years ago

It's not really a big one, just a mildly annoying one in my opinion. I just found out that VBA supports OS specific preprocessor declarations using #If ... Then, which I just tried and #If Win32 Then does indeed work.

I will some day in the far future come around to add the socket logic for macOS, too, since it seems it's "just" importing things, but for now, you won't be able to use webxcel on a non-Windows-machine, sorry.

dumblob commented 2 years ago

Any news on this?