Consulting

Results 1 to 4 of 4

Thread: Will VBA be in the new Mac Office?

  1. #1

    Will VBA be in the new Mac Office?

    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

  2. #2
    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

  3. #3
    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

  4. #4
    Quote Originally Posted by manish1994 View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •