Create a button to load a excell file then process it

[ITWoman01]

Hi guys
I need to load an Excel file with a button, then process and modify it and change it to txt or pdf after the changes. Can I do this with VBA?any body can help me plz?

 

[Logit]

.
This macro will open the file named checkbook-register.xlsx that is located on your desktop :

Option Explicit


Sub OpnWBTwo()
    Dim objExcel
    Dim objWorkbook As Object
    Set objExcel = CreateObject("Excel.Application")
    objExcel.Visible = True
    Set objWorkbook = objExcel.Workbooks.Open(Environ("USERPROFILE") & "\Desktop\checkbook-register.xlsx")


End Sub