I am working in Excel for Mac 2011 and my goal is to create a simple macro that writes particular cells to a file. This is generally a simple task, but VB chooses not to accept a file path. For example, the following code literally writes a file called
~/file.txt, ignoring the directory structure entirely:
Open "~/file.txt" For Output As #1
I have tried the full path
/Users/Sergey/file.txt to no avail.