How to save the output file on the same path wherever we maintain the excel macro.. pls help Even if i move the excel to any path, the output must generate on same path
@johnson863 : The path of the PDF file is defined in the macro code. You are free to modify\define this path on your own. This will allow you to generate the report on the same path irrespective of the excel file.
Is there a way I can generate a hyperlink to all pdf files after their creation in front of data row that I first selected? I've been trying to get a vba code. I even tried generating but seems like I don't know much. I need help. Your pdf saving Macro Idea is good but I want a way in which I can get a hyperlink also to the pdf.
Hi, you can create a folder name in a particular cell and open it using the following code : Foldername = Cells(2, 3).Value ActiveWorkbook.FollowHyperlink Address:=Foldername, NewWindow:=True
Can you please put the code here in the comment? :(
Please find the code below 😀 :
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=
"C:\Report Card.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Please can u write the full code to make it generate PDF based on the name
Thank you so much Brother :)
You are welcome !
Hi, could you show the code select row generat copy text
do you have the video guide on how you did the Generate report card?
@NBH2023 - Please see the following video to see how a report card is generated
th-cam.com/video/CvqjH0Ptk-k/w-d-xo.html
Is it also possible to select a radio button via vba?
Hi, why my macro is not working? need to debug, but im not sure which one is wrong, mind to help me?
Easy to follow. Thank you.
You're welcome!
I need a help.How do i make a pop that says closed opened document so the document can be overwritten
Thank you Sir 🙏
How to save the output file on the same path wherever we maintain the excel macro.. pls help
Even if i move the excel to any path, the output must generate on same path
@johnson863 : The path of the PDF file is defined in the macro code. You are free to modify\define this path on your own. This will allow you to generate the report on the same path irrespective of the excel file.
Is there a way I can generate a hyperlink to all pdf files after their creation in front of data row that I first selected?
I've been trying to get a vba code.
I even tried generating but seems like I don't know much. I need help.
Your pdf saving Macro Idea is good but I want a way in which I can get a hyperlink also to the pdf.
Hi, you can create a folder name in a particular cell and open it using the following code :
Foldername = Cells(2, 3).Value
ActiveWorkbook.FollowHyperlink Address:=Foldername, NewWindow:=True
Thank you but much better if you show the code in the video. But you shared it here in Comments
good sir
Hi if i want to insert pdf ,how to make vba code??
Hi, I didnt get your exact query. Can you please elaborate ?
I want to name the file based on names from 2 cells, how can I do that?
Please use the =concatenate function to make your complete filename from 2 cells
I'm Judith
Thank you Sir 🙏