excel-vba-mac

I need to write a script to save a worksheet with to a predetermined location and the save name is filled from values within the worksheet. I can get it to save in the proper location, but the file name returns a combination of FATPMetiFolderPath and FATPMetiPath...

What i need to do is - 1. I have a base data sheet(Data) with user id(col D), Username(col F) and Reports to(col I) data of all employees. 2. i have a set of unique managers and their ids in a sheet X. 3. In sheet Y i have a list of selected managers and their ids which are not in sheet...

All, I have this line in my code, which I have tested both on PC and MAC and works fine. I am trying to copy a file from an existing folder called Templates to a newly created folder (see 2nd snipet of code) and renaming it based on the newly created folder name. FileCopy ThisWorkbook.Path &...

Good morning all, Based on the help of an expert I have managed to create the following code that executes nicely what I am asking to do i.e. 1) create a new folder and subfolder structure at the same level as the active workbook path, based on the name in Column A (Column A is a CONCATENATE of...