Xcelnewbie
New Member
Hi all - i would like to ask for your help in developing a function that will do the following:
- convert an excel form into pdf
- automatically opens up an email in lotus notes with the pdf as an attachment
I've tried to record a macro that will perform these tasks and below is the "code" that was generated:
Sub Macro1()
'
' Macro1 Macro
'
'
ExecuteExcel4Macro "PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)"
Sheets("Main").Select
End Sub
I'm hoping you could help me enhance the code. Thank you.
- convert an excel form into pdf
- automatically opens up an email in lotus notes with the pdf as an attachment
I've tried to record a macro that will perform these tasks and below is the "code" that was generated:
Sub Macro1()
'
' Macro1 Macro
'
'
ExecuteExcel4Macro "PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)"
Sheets("Main").Select
End Sub
I'm hoping you could help me enhance the code. Thank you.