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!
Bookmarks