Please give assists on my case, since I am new on coding.
I do have userform which had Application.FileDialog(msoFileDialogFilePicker) for pdf file.
The question is what is the script for saving file selected pdf file on specific folder when I click Submit CommandButton.
Untitled.jpg
I hope somebody could help me finish this coding.
Post a small example of your excel file without sensitive data, make sure it's clear what you want to achieve.
Don't post a picture, pictures belong in a photoshop forum and not in an excel forum.
Click the * Add Reputation below to say thanks.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
It is kind a workingSixthsense
Thank you very much brother.
Could we also change the name of the new copied files?
Replace this
WithPlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks again,
Now for the last thing, I need to put Hyperlink on value entered to the file path.
Could I made this automatically from userform as well?
Please Login or Register to view this content.
Can we set the range not to specific cells? because if we put specific cell it will be replace for the next file saved.Originally Posted by :) Sixthsense :)
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks