Hey, I just wanted to know how the file structure in Mac worked for saving a module file to the C drive.

I currently do the following in Windows:

On Error Resume Next
Kill ("C:\RBIWMod4.bas")
On Error GoTo 0
ActiveWorkbook.VBProject.VBComponents("Module1").Export ("C:\RBIWMod4.bas")

--Code would go here--

Application.VBE.ActiveVBProject.VBComponents.Import ("C:\RBIWMod4.bas")
Kill ("/RBIWMod4.bas")

I assume for Mac it would be something like this:

If Val(Application.Version) > 14 Then


On Error Resume Next
Kill ("/RBIWMod4.bas")
On Error GoTo 0
ActiveWorkbook.VBProject.VBComponents("Module1").Export ("/RBIWMod4.bas")

--Code would go here--

Application.VBE.ActiveVBProject.VBComponents.Import ("/RBIWMod4.bas")
Kill ("/RBIWMod4.bas")


Not entirely positive. I have a Mac user who's getting an error when attempting to run the macro.

Thanks!