Good day everyone, arif here to have your suggestions
Good day everyone, arif here to have your suggestions
Hello khaiberians,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi there, I'm a newbie and just started today! Welcome and looking forward to learning alongside you!
Hi, I am using below macro to save file in pdf in the name of cell value. But it is not always working and not working in all pcs. The problem I face while selecting command button in upper 04 commands.
//
Sub LC_Approval_PDF()
Application.ScreenUpdating = False
With Sheets("LC_Approval")
.Visible = True
Sheets("LC_Approval").Select
Range("b37").Select
'Create and assign variables
End With
Dim saveLocation As String
Dim sheetArray As Variant
saveLocation = Range("b37").Text
'Save Active Sheet(s) as PDF
Sheets("LC_Approval").Select
Range("b37").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=Range("b37").Value, OpenAfterPublish:=False
Sheets("LC_Approval").Select
With Sheets("LC_Approval")
.Visible = False
End With
End Sub
//
Last edited by khaiberians; 01-04-2021 at 11:32 PM.
Please assist me
Last edited by khaiberians; 01-20-2021 at 08:12 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks