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.
sayyad786i
0
Newbie Poster
Recommended Answers
Jump to Posthi,
try the below coding.
Public Function ConvertFile(strSourceFileName As String) As Boolean On Error GoTo ErrorHandler Dim msExcel As Excel.Application Set msExcel = GetObject(Class:="Excel.Application") Dim p As String p = "Acrobat Distiller on Ne00:" msExcel.Visible = False msExcel.Workbooks.Open strSourceFileName strMenuFilePs = strSourceFileName msExcel.ActiveWorkbook.PrintOut ActivePrinter:=p, PrintToFile:=False, PrToFileName:=strMenuFilePs …
Jump to PostIm trying to automaically save an excel file to pdf file using visual basic. So, I will manually open the excel, upon opening the excel file, it will run code to calculate a daily totalizer(this I have functioning) as soon as this code finishes, I want the excel file to …
All 7 Replies
manoshailu
12
Junior Poster
mason_bancroft
0
Newbie Poster
pbunkers
4
Newbie Poster
AndreRet
511
Senior Poster
pbunkers
4
Newbie Poster
AndreRet
511
Senior Poster
pbunkers
4
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.