Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by rutherfordcpa
at 2024-07-13 11:15:50
ModifyPoint:500 Replies:3 POST_ID:828971USER_ID:11869
Topic:
Microsoft Excel Spreadsheet Software;;Microsoft Office Suite
The following changes the default file type when saving in Excel:
Application.DefaultSaveFormat = xlOpenXMLWorkbookMacroEnabled
Does anyone know if this works in Mac 2011 as well? If not, what would be a comparable code?
I am unable to test in a Mac at this time.
Thanks.
Application.DefaultSaveFormat = xlOpenXMLWorkbookMacroEnabled
Does anyone know if this works in Mac 2011 as well? If not, what would be a comparable code?
I am unable to test in a Mac at this time.
Thanks.
Expert: duncanb7 replied at 2024-07-17 11:11:47
Thanks for your points
Have a nice day
Duncan
Have a nice day
Duncan
Author: rutherfordcpa replied at 2024-07-17 11:03:44
Thanks.
Accepted Solution
Expert: duncanb7 replied at 2024-07-13 17:28:50
500 points EXCELLENT
Probably, it is okay using xlOpenXMLWorkbookMacroEnabled but if
using number 52 to specifiy ,xlOpenXMLWorkbookMacroEnabled ,
for example, ActiveWorkbook.SaveAs "C: est.xlsm", fileformat:=52
that might not work unless you add 1 on 52 equal to 53
You can take a look at this article in which show all compatibility at the bottom.
http://www.solveyourtech.com/change-the-default-file-format-in-excel-2011-for-mac/
Hope understand your question. If not, please point it out
Duncan
using number 52 to specifiy ,xlOpenXMLWorkbookMacroEnabled ,
for example, ActiveWorkbook.SaveAs "C: est.xlsm", fileformat:=52
that might not work unless you add 1 on 52 equal to 53
You can take a look at this article in which show all compatibility at the bottom.
http://www.solveyourtech.com/change-the-default-file-format-in-excel-2011-for-mac/
Hope understand your question. If not, please point it out
Duncan
