Create a button to load a excell file then process it

ITWoman01

New Member
Joined
Dec 24, 2018
Messages
1
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

Well-known Member
Joined
Aug 31, 2016
Messages
2,942
.
This macro will open the file named checkbook-register.xlsx that is located on your desktop :

Code:
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
 

Forum statistics

Threads
1,085,884
Messages
5,386,553
Members
402,006
Latest member
stringer47

Some videos you may like

This Week's Hot Topics

Top