Hello experts
I have recorded a macro to save this file in a different folder. I want the name of the pdf to include a cell reference (J8) along with the date which is in cell (O7).The saved pdf file name must look like Rajesh / 001 dated 8th July 23. I need your expertise to edit this recorded macro and get the expected result.
Thank you in advance.
Last edited by RAJESH SHAH; 09-05-2023 at 12:06 PM. Reason: #Solved
"Where there is a will there is a way".
A VBA demonstration as a beginner starter :
PHP Code:Sub Demo1()
MsgBox [J8] & Format([O7], """ dated ""yyyy-mm-dd"" .pdf""")
End Sub
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
Re: "save this file in a different folder"
Maybe I misread your post but is it right that the path/folder is: "C:\WhereInTheHeckDoesThisGo"?
The inherent weakness of the liberal society: a too rosy view of humanity.
Removed as not working.
Last edited by RAJESH SHAH; 09-05-2023 at 06:58 AM.
There are many threads on this forum that are similar to your question. Is it really so hard for you to read similar topics with questions about converting and saving to PDF format and write something of your own code for your needs? And do not run to this forum with the same simple questions (such as how to enter data in the first empty cell and similar simple questions). It's time to create something of your own. And don't tell me that you have a YouTube page where you kind of help other users. For such an amount of time and the topics you created, you should have already become the Guru of this business (Excel and VBA). Or am I wrong?
I have posted this in another forum for the solution. Only if some of the members could concentrate more on the solution it would have been solved. Now some people just want to throw some or the other comment or the other on my posts. It has become a trend now. I didn't know there was a limit to ask for solutions. If some of the members feel they don't like answering please don't. At least don't judge me. You can avoid my posts if you wish. I am what I am. Thanks anyways for all the beautiful comments.
https://www.facebook.com/groups/3932...omment_mention
Last edited by RAJESH SHAH; 09-05-2023 at 11:28 AM.
The query is solved.
@RAJESH SHAHWell, Well, we are waiting for another 100 posts from you to reach this figure of 2000 posts, a round number still looks prettier. But your post from your other topic,with so many of your posts on this forum, is generally beyond all praise. Keep it up!Originally Posted by RAJESH SHAH
I am not sure how to write the code but maybe I understand I have to add last row in this line.
Please Login or Register to view this content.
Last edited by MikeVol; 09-05-2023 at 12:41 PM.
Re: "The query is solved."
After just about 2.000 posts you know full well that it is common courtesy to show the code that made your problem go away for other people that come here with the same problem.
I have a strong feeling that you use these forums for people to do your work for you instead of you putting some effort into finding a solution yourself. If they feel like doing that, nobody will stop them from doing so of course.
The sad part is that they could be helping someone that really is at their wits end with a problem and really need help from an outsider.
# Solution
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