Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #54.9K
Re:
hi, I want to create a pdf from excel sheet using visual basic 6.0. Can you people help me describing or sending me a ready codes regarding the same. Thanks with regards, Sayyad H.A. India. |
|
Hello everyone, I'm trying to get this Sub procedure to execute after the selected worksheet is printed. Any suggestions? [code=visualbasic] Sub Save_Printout() Dim s As String, Sh As Worksheet Set Sh = ActiveSheet Sh.Copy s = "c:\printed sheets\" & Range("M5").Value 'save location and name of worksheet ActiveWorkbook.SaveAs Filename:=s Range("A1:IV5000").Copy 'selects … |