glyn8

Thanks for the spot, I would hate for something I posted to lead to malware. the solution I posted also no longer works and you have to create a network location in the 'This PC' section of file explorer.

I can create a long string variable in VBA by repeatedly appending short string variables like this: sMyShortString = "a" For i = 1 to 100 sMyLongString = sMyLongString & sMyShortString Next i This works nice and quick, but a weird thing happens when you get to a string length of around 270,000 - the rate at which the code runs suddenly drops by a factor of 10. I have tested this on Excel 2010 and Excel 2016 on a variety of machines, and the performance hit always happens at the same string length. Does anyone know why this happens?

A few years ago I made a post on this forum concerning the inability of my computer to connect to a Freenas server that I had recently constructed. I got a reply to it the same day but alas we were not able to find a solution to this problem. I ended up re-installing Windows and that somehow fixed it, later on that year i finally found the solution to the problem. (TLDR) You have to go into Turn Windows features on or off and scroll down until you find SMB and turn it on. (DO NOT DO THIS, as Jarsky (someone with a lot more experience in this field than me) pointed out that it can lead to malware infection)

It's just the one computer that cannot connect to it. The network on is set to private using said computer.

I set up a SMB share on the Freenas which I can connect to from other computers on my network.

I've tried everything I can think of (Turning on network discovery, searching for the NAS directly using both it's name and IP address, switching the network from public to private and back again and even switching the Ethernet port i'm using on my router) I can ping the NAS using CMD but I cannot see or connect to it in the network tab of windows explorer. I cannot see any other computers on my network either. Please help.