×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Saving File in multiple folders using MACRO

Saving File in multiple folders using MACRO

Saving File in multiple folders using MACRO

(OP)
Good morning

I am working on a macro that would save my files in two different folders. I know it sounds easy except:
-Folder 1 in the same all the time so this will be easy
-Folder 2 is part of a folder structure we use for each project.
Example of folder structure:
\\User

-Project X

-Work
-PDF
-Images

So I am working on files in the "work" folder and need to save a PDF version of the file in the "PDF" folder.
I managed to go back one level, from "Work" to "Project x" using the following code but I do not know how to go into PDF and save my file there.

CODE --> VBA

FileLocation2 = Left(MyDoc.Path, InStrRev(MyDoc.Path, "\") - 1) 

Any help will be much appreciated.

RE: Saving File in multiple folders using MACRO

(OP)
Hello ferdo

I wrote it in Catvba as I am planning to use it with Office as well.
The interface for picking the path would not be required as they are standard (one is a fixed pathway from start to finish and the other will only be different until inside the project folder.)
I am not sure about using a different environment as I will need to have a clear button inside the software they are using (Catia, PowerPoint, Word) so it is as easy for the user as possible. I would go for a toolbar like yours but they are not very open to big changes. I need to ease them in saving time eliminating specific tasks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources