PDA

View Full Version : Will VBA be in the new Mac Office?



jvbeaupre
03-05-2015, 06:01 PM
I just saw on CNET Mac Downloads, a Mac Office 2016 preview item.
My question is will VBA be in the upcoming Mac Office?
Any rumours or actual knowledge of that in the upcoming Office?
Jim

jvbeaupre
03-06-2015, 07:24 AM
I bit the bullet and did the whole 2.5 Gb download.
Excell 2016 can do simple macros, but failed a complex macro in the following way: It could not find or open a .xls file in the current directory.
It also blew right by (didn't wait for a file name input) an open "save" dialog.
I'm not sure what went wrong or how to report the problem.
Jim

manish1994
05-17-2018, 11:17 PM
hi
i have a problem
like i want a code for a word document macro to put the word to a next line

ex
06:00 Pingu Show

like this it sould display
06:00
Pingu Show

jvbeaupre
05-18-2018, 05:18 AM
hi
i have a problem
like i want a code for a word document macro to put the word to a next line

ex
06:00 Pingu Show

like this it sould display
06:00
Pingu Show

Insert the new line ascii character into your test stream. I forget what the ascii character number is for that, so let's say it's 13.
Then if your string is "06:00 Pingu Show" change it to "06:00" & Chr(13) & "Pingu Show"

Be sure to look up the correct number for the ascii "new line" character.
Good luck.