Stack Overflow
Stack Overflow

Questions tagged [excel-mac]

7 questions
2
votes
1 answer

How to use VBA in Excel to truncate numbers rather than rounding?

I need to create a table where the operator can input numbers. This is a protected sheet, so the operator can not change anything, they can just input numbers in specific cells. [Microsoft 365 for Mac] I need Excel to show 2 decimal places without…
Milad
  • 33
  • 4
1
vote
1 answer

Code runs fine as regular sub but won't run as Workbook_Open() event

I have this code in VBA that builds a list of all currently opened workbooks, and adds them to a named range, so that I can use that as input for a selection list. This way the user is able to select the workbook that should be processed. Sub…
Luuklag
  • 3,897
  • 11
  • 38
  • 57
0
votes
0 answers

I'm trying to output a json file from excel with visual basic. Is there a way to specify unicode encoding for the file?

I'm using data from excel to write a json file to be read into sketch. Special characters like ® and ™ aren't coming through and are being replaced with a ?. I'm assuming that the default encoding of the file generated is not unicode. Can unicode be…
notAdev
  • 1
0
votes
0 answers

Excel tab-delimited differences between Windows and Mac

I have an excel file that is used to generate input files for scientific equipment where users fill in their samples and it generates a file the equipment can read. However, I've noticed that if a Windows Excel saves the tab-delimited file the…
BrenenP
  • 1
  • 1
0
votes
1 answer

Work around for AutoFilter function VBA on Mac?

I'm trying to turn on Autofilter for the the header row on each page of my workbook before each sheet is protected with a password. I'm using Microsoft Excel for Mac, which if you're familiar with, lacks the complete functionality of VBA for Windows…
Anna Glover
  • 11
  • 2
0
votes
0 answers

Rearrange whole rows, based on a variable depending on formula result, after sorting the source table

I have an issue with using data from a source table: Lets say we have Sheet 2, where in column A is the formula =IF(Sheet1!A1 = 0;"";Sheet1!A1) I am taking only the newest info form Sheet1 to keep another type of data in Sheet2 about the given…
Petya Hadzhiyska
  • 1
0
votes
1 answer

VBA makro to create seperate files for every worksheet in excel workbook on mac - splitbook

I would like to split an excel workbook into one file for each worksheet using VBA on mac. I tried many different makro-codes I found in different forums but I never got them to work. Does anyone have a code that works for him? The best code I found…
brauer-t
  • 45
  • 7