Thank you for the lessons. I wrote a macro to open my workbook with a new number every time (+1), but I also would like to have a button to save the workbook to a specific location as .xlsx after I input the data, then clear the contents and be ready for the next one. I can perform both in separate workbooks but I'm having trouble combining them all in one workbook. Any help?
Hi, Thank you for sharing, kindly let me know if sheet1 and sheet4 i want to export pdf in one page? is there any formula for that. thank you in advance
Hello, thank you for your videos. Could you also make a video of how to create leave tracker? I would like to add emp code before name and have new sheet to track leave each month, year and entitlement leave.
Hi, It is a great video. But I have one question. Is it possible to export PDF to the folder if the path is submitted in a certain cell, for the user to be able to choose the direction?
Thank you for this but my PDF is not exporting in the same folder as my excel file. my PDF is always showing up in the Documents folder for some reason?
Hello Sir, I am trying to create a VBA macro where I can copy data from excel and paste it to another application, i.e., Notepad++ and save it on the desktop in XML format. This is one part of it. Can you help me with this.?
Thank you very much for this video, very helpful and easy to follow. Is is possible to exclude one or more tabs from being saved as PDF? For example, I have a workbook with "Course manager" "SIM Prac" "Overview" & "Learner 1" "Learner 2".. up to "Learner 15" (number of learners vary for each course). I want to save only the learners worksheets as separate PDF files. I also want the PDF files to be saved with the learners names & staff numbers which are 2 different fields on each worksheet. Finally, I want to assign the macro to a button on the "Course manager" worksheet. Appreciate your assistance :)
Hi, just a question, how can you save a file to pdf using a filename which is stored in a certain range? If I have a referenced cell that will change its value over time, the pdf that will be exported will be the same name as the stored value on the referenced cell. I had tried to create a variable that will store the name that will be inputted on the referenced cell, but I have a hard time joining it to have an output of pdf with a filename same as the stored value. I hope you can help me with this. Thanks
Suppose its a employeee payroll sheet and want to save this file as pdf after incorporating passoword . Can it be done with VBA in excel ?? if yes then plz guid sir ....
It would give you a strong foundation and you would easily be able to work with basic and intermediate vba codes. The more you work with it, the more expertise you would gain. This course covers almost everything you need to know about VBA in Excel
Just finished watching the whole VBA series, it was very insightful and thank you for such detailed videos.
great video, I will follow it to improve my work. thank you!
You're my savior, thank you so much
Excellent work!
Thank you Sir for simple and easy illustration.
Thank you it was so helpful and clear 🙏🏻🙏🏻🙏🏻🙏🏻
Thank you very much for this series. I have Finished it and really awesome . Eagerly waiting for for part 2 of VBA Jet pack course.
Came across first course in you tube which is really helpful to learn Excel. Thank you so much for it!!
Thank you for the lessons. I wrote a macro to open my workbook with a new number every time (+1), but I also would like to have a button to save the workbook to a specific location as .xlsx after I input the data, then clear the contents and be ready for the next one. I can perform both in separate workbooks but I'm having trouble combining them all in one workbook. Any help?
Thanks for the simple code. I used for my application.
Thank you very helpful
Great video ❤
And again Thank you for this course. It's my third course /Finished/.
YOU ARE THE BEST
Thankyou!
thanks that helped
Hi, Thank you for sharing, kindly let me know if sheet1 and sheet4 i want to export pdf in one page? is there any formula for that.
thank you in advance
Hello, thank you for your videos. Could you also make a video of how to create leave tracker? I would like to add emp code before name and have new sheet to track leave each month, year and entitlement leave.
Thank you for this video. Supposed you have a template. How do you convert each row into pdf?
Hi, It is a great video. But I have one question. Is it possible to export PDF to the folder if the path is submitted in a certain cell, for the user to be able to choose the direction?
duper hit sir 👍👍👍👍👍👍🤣
Thank you sir,
How to pdf lengthier column file
Thank you for this but my PDF is not exporting in the same folder as my excel file. my PDF is always showing up in the Documents folder for some reason?
is there a way to export only certain columns (user is prompted to select which columns to export) as pdf?
Hello Sir, I am trying to create a VBA macro where I can copy data from excel and paste it to another application, i.e., Notepad++ and save it on the desktop in XML format. This is one part of it. Can you help me with this.?
Thank you very much for this video, very helpful and easy to follow.
Is is possible to exclude one or more tabs from being saved as PDF? For example, I have a workbook with "Course manager" "SIM Prac" "Overview" & "Learner 1" "Learner 2".. up to "Learner 15" (number of learners vary for each course). I want to save only the learners worksheets as separate PDF files. I also want the PDF files to be saved with the learners names & staff numbers which are 2 different fields on each worksheet. Finally, I want to assign the macro to a button on the "Course manager" worksheet. Appreciate your assistance :)
hi Sumit, Thanks for sharing the video. I am facing the problem that it is not creating any pdf also it shows Runtime error 1004
Can you make a video on VBA formatting? My Word report is not showing the formatting I specified in the macro :(
Hi, just a question, how can you save a file to pdf using a filename which is stored in a certain range?
If I have a referenced cell that will change its value over time, the pdf that will be exported will be the same name as the stored value on the referenced cell.
I had tried to create a variable that will store the name that will be inputted on the referenced cell, but I have a hard time joining it to have an output of pdf with a filename same as the stored value. I hope you can help me with this. Thanks
Suppose its a employeee payroll sheet and want to save this file as pdf after incorporating passoword . Can it be done with VBA in excel ?? if yes then plz guid sir ....
Excellent, final some one explain in detail how it's working, thanks
Hi .trying to use it .after pressing on Alt f11 - i didnt see the name of the excel sheets .may be i need to presssomething else after Alt F11 ?
Is there a way to combine two sheets into 1 pdf file? please help?
What if the sheet range selected page i wish to saved all in 1 page, what should i do ?
I want to change the address from desktop to my difference drive? How to do this
Summit, is there any way to add suffix numbers to exported files to prevent overwriting of previous ones?
You can create a counter in a cell.
Each time you run this code, add +1 to that cell (first) and then use that cell value within your name string.
I went through all of the course videos from video 1 to video 36 and appreciate all that you went over in the program. It was amazing.
thank you.but sir if I want the pdf file to e-mail then what will be the vba code
how can we name the file name as per specific cell in worksheet ?
Sir can you please make a video on how to divide worksheet in a excel file into different worksheet based on a criteria
How to generate report contains range and chart in a same page
What to do next after completing this course?!
how do you save a worksheet as a pdf that is set up in a landscape mode and not Portrait .
I ends up with a Run-Time error "1004" Method "ExportAsFixedFormat" of object _Worksheet failed
i want sheet nam to range convert. not want name "range". halp
hi Sumit.can i save the form as PDF?
How can I make pdf of every page of excel file and email.
thanks a lot sir............... any code for increase kb of picture but not change it size like(width=100, height=120... I want this is as is)
I am facing a problem run time error '5'
Invalid procedure call and argument
how can you save only specific sheets in a single pdf eg sheet1,sheet 3, sheet5 in one pdf
I tried but the file is not saved in the same folder, it is saving in the documents folder all the time, please advise.
How to use this same code using command button
How you save sheet1 and sheet3 in one PDF.
HOW CAN I COMBINE THSES PFDS ?
@trumpexcel Do I understand by this that having covered 36 videos is enough to have a VBA coding expertise?
It would give you a strong foundation and you would easily be able to work with basic and intermediate vba codes. The more you work with it, the more expertise you would gain. This course covers almost everything you need to know about VBA in Excel
what is the difference of inserting a module by adding through insert menu and right clicking at any sheet in VBA project?
No difference, both are same or alternatives
Is it whole complete course for vba
Hi, how to create PDF file with protected password?. Please help
Can we make PDF uneditable ...???
I received message " Run time error 5 " while running program, please inform mistake.
I am getting run time error 5 while running code. Please inform how to correct.
Im struggling :(
Respected Sumit, Hope you will be fine, i have sent you an email kindly reply me. I want to learn you more. YOU ARE GR8 !
try this but not save & print
Vba is better than excel but when will u upload that video in which we can see vba is far better than excel.. Plzz
Not working
I wish I could actually see the video. It is so blurry. I can see what he is typing
-- Export and Save an entire Excel workbook as PDF
-- Export a specific worksheet as PDF
I work but not success. NO PDF FILE IS EXPORTED
i have same issue waste of time