mac macro

Hello peers, I appreciate this has been asked numerous times and i have tried google search and to no avail in amending the code below to paste in the next empty column in the workbook the data is being copied to. for some reason its pasting the values at the bottom row of the workbook in...

Good morning, I have the below script that works perfectly well on a windows machine. However it doesnt run on a Mac Operating system. Can I get your guidance on what I need to do to the code?

Hi all, I was wondering if i could get your advice, with the below error message and how can i go about fixing this issue on my Mac. I have searched high and low for a mac solution to a fix. this is the code thats failing: ExportWorkbook.SaveCopyAs ThisWorkbook.Path &...

Hi all, I found the below code on another forum that will loop through files on a normal windows machine with a network location. However I am using a mac and i was wondering if anyone knows how to amend the code so it works on a mac. Sub Macro1() '//Change the path to the main folder...

Thank you for reading my post. I have the below formula which I would like to change into VBA code. The spreadsheet that has this code in there are 43 columns with similar formula's in them which makes the documenter slow. Could I get your advice on how to write this as VBA code and then for...

I'm sorry in advanced if this has been answered before. I couldn't find the answer in past threads. I have an .xlsm file that calls the user name to help make a record of changes Function GetUserNameMac() As String Dim sMyScript As String sMyScript = "set userName to short user name of...

I am not a macro coder or a MAC user. It is my wife's MAC. I can edit the VB code a bit but that is about it. I am using an excel sheet with recorded macros on a MAC computer. The macros were recorded on a PC and I have run a similar spreadsheet on the MAC with no problem. The macro has...