3

So... I had to create a VBA macro, ok, it is very simple and it will be necessary during some DOC files reviewing. Ok, not a problem.

I created the functions, added some quick launch buttons and saved it as a .DOTM file. I even included an autoload form with an Install button, so the file copy itself to the Word Startup folder. Nice, everything working just fine.

But... there are two Mac users in the company. I do not have a Mac, but the first thing I thought was I hardcoded the "\" to check if the file already exists and to copy the file. Using the system separator would do the trick. The macro would be copied and everything is done. But...

1. The quick launch buttons do not appear on Mac;

2. The "Application.PathSeparator" returns an ":"

3. The "application.StartupPath" returns an invalid path (something like "Mac's Name:Application:etc")

4. The copy command is not working, the Dir command appears to be not identifying the path etc

5. I need to have it working by Monday morning.

Comments
  • 1
    I'm working with VBA a lot... A FUCKING LOT!!! 👏 Hate my work place... but it's for money... haha 😂

    But I can't help you there (da big bad internet will)... 🤔 maybe... just search for "default startup path mac word" and try that. Or ask the users for checking the option settings.

    I don't like the dir function btw... it's returning the checked string or is empty and that's stupid 😂

    Edit: the first search entries for me (duckduckgo)

    https://rondebruin.nl/mac/...

    https://answers.microsoft.com/en-us...

    https://extendoffice.com/documents/...
  • 1
    ahahahahahaa I hate to work with VBA too. And the Dir function really does not make any sense to me. But it works to check if a folder exists. ahahahah

    Thank you so much for the links. I am thinking to send the startup path and ask the few Mac users to place the .dotm file manually there for Monday. It could work as there a just a few of them. :) But I will need to fix that anyway later, so they still can be usefull.

    Now I need to create a ribbon tab. Just downloaded the Custom UI Editor and I am creating it.

    Thank you again! :)
Add Comment