You said on these save as PDF video you again put another video email to client do you have that code for that email to client buttons
@fluffymub
5 жыл бұрын
Hi James, when I run the code to save worksheet as a PDF, it brings up the save dialogue box with "false" as the filename and does not capture the invoice number as you have done in your video. If you have any ideas how I could fix this please? Regards Pat.
@jalia1998
5 жыл бұрын
I am not sure what you're saying here, could you please be a bit more specific?
@abt92online
2 жыл бұрын
i made that Formula As You do in Video .. But After Finished this when i try before save sheet its working but when i try to save that sheet its error like Macro . and if i click on no its as to save my file and after when i open file again that button is not working.
@jalia1998
2 жыл бұрын
save the workbook as XLSM
@abt92online
2 жыл бұрын
@@jalia1998 i do but still there is error macro even I done same as you shown in video and thats work 100% but when I tried to save its showing error and after save and close sheet but when I reopen it .. that pdf button is not working . Am using ms 2016
@jalia1998
2 жыл бұрын
You may have to enable and trust the document. Google how to do that
@abt92online
2 жыл бұрын
Okey will try
@poeticnight9339
4 жыл бұрын
Excellent....! Great...! How I save user form as PDF with full scale...?
@abdulmajidkhan2136
4 жыл бұрын
how can i use this button to select my selected data to be a pdf?
@fadreen
6 жыл бұрын
Hi James i tried as per your video but when i click the button the command directly goes to msgbox(File not Saved). Any help on this please.
@jalia1998
6 жыл бұрын
this sounds like you don't have a valid path. I cannot say for sure without your code, but that is what I would look at first.
@abdurrahmaniif4646
5 жыл бұрын
CAN I USE THIS VBA CODE IN MS OFFICE 2007. PLEASE REPLY ASAP. THANKS.
@jalia1998
5 жыл бұрын
I'm actually not sure, but a way you can test is to record a macro saving as pdf.
@ErdmanA88
7 жыл бұрын
yea.sooo im supposed to read that off a video? you could have retyped it and explained it line by line. i can barely read any of that. any way we can get the code in the comments dawg?
@geeasprisal4721
7 жыл бұрын
Can I get the code? The dropbox link isn't working. Thanks
@shreeramitsolutions3418
7 жыл бұрын
AAPKO VBA CODE RUN ACHCHHE SE AATA H TO PLEAE MUJHE BHI THODA BATA DIJIYE
@sincronex
8 жыл бұрын
how would you do this if you want to select certain data from file to save as a like name and you want to choose the location automatically? great video nothing the less
@jalia1998
8 жыл бұрын
I dont know what you are asking here?
@sincronex
8 жыл бұрын
so to like automatic save with name of client and invoice number: but an error happens if it picks up the name invoice number used
@jalia1998
8 жыл бұрын
I can create a video for this today. it may be a few hours.
@shashankyadav5549
6 жыл бұрын
Hello sir, helpful video but sir where is VBA coding?
@rajeshdebnath8673
6 жыл бұрын
Sir code not visible, need zoom
@ashvinbhaipatel9364
5 жыл бұрын
Hi sir PDF cord very useful but PDF size 367 kB upload 100 kb
@jalia1998
5 жыл бұрын
I don't understand what you're asking?
@michaelhernandez572
8 жыл бұрын
Is there anyway I can get this vba code?
@sankarmondal89
4 жыл бұрын
Private Sub cbSaveAsPDF_click() Dim sPath As String Dim sFile As Variant Dim ws As Worksheet On Error GoTo errHandle sPath = ThisWorkbook.Path & "\" & "Invoice" & Me.Range("g7") sFile = Application.GetSaveAsFilename _ (InitialFileName:=sPath, _ FileFilter:="PDF Files (*.pdf), *.pdf", _ Title:="select Folder and File Name to save") If sFile = "False" Then MagBox ("Please Choose A File Name") Exit Sub End If Me.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=sFle, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=Files, _ OpenAfterPublish:=True Exit Sub errHandle: MagBox ("Document Not Saved") End Sub
@Bumbus977
8 жыл бұрын
This video was very helpful, thanks :) But I can't find next video with email to client, could you send me the link?
MY GOD WHY DOES NO ONE JUST PUTS THE CODE IN THE DESCRIPTIONNNNNNNNNNN
@mehrdad18
5 жыл бұрын
Hi, where can i get the code file?
@jalia1998
5 жыл бұрын
Hello, I no longer have the code for this file. My apologies.
@mehrdad18
5 жыл бұрын
@@jalia1998 Thanks men it worked ;)
@ishakkezzim5498
5 жыл бұрын
hi Sir , This vidéo was very helpful , Thanks , That did not work for me. I get this message: Expected: Line number or Label or Statement or end of statement. #(InitialFilename:=sPath, _ #FileFilter:="PDF Files (*.pdf), *.pdf", _ #Title:="Select Folder and File Name to save")
@farahdebouky6255
6 жыл бұрын
Thank you very very much
@mohdzuber2194
7 жыл бұрын
document not save
@mnalaka5068
4 жыл бұрын
Excel - Find save as - select Pdf - select which sheet you want to ( All, 1, 2,3 etc) - Press Ok ..You have pdf file on Excel, just 30 seconds.
@hiranimuzahid5998
3 жыл бұрын
Hii can you send this vbn file
@nemilshah1945
7 жыл бұрын
pls provide the code file
@sigtelengineering1146
7 жыл бұрын
Share the Codes Pls.
@Snokes
5 жыл бұрын
@@jalia1998 is this still available and does it work with Microsoft word?
@sankarmondal89
4 жыл бұрын
It's not working
@jalia1998
4 жыл бұрын
Must be something with your implementation
@sankarmondal89
4 жыл бұрын
@@jalia1998 Compile error. Sub or Function not defined.
@sankarmondal89
4 жыл бұрын
Finally, it's working now! After a lot of efforts............
@mikemurphyiv
4 жыл бұрын
@@sankarmondal89 Hello, I received the same compile error. What did you do to fix this?
@mikemurphyiv
4 жыл бұрын
@@sankarmondal89 Hello, I received the same error. What did you do to fix this?
Пікірлер: 72