Results 1 to 2 of 2

Thread: Create a button to load a excell file then process it
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Create a button to load a excell file then process it

    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?

  2. #2
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,781
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Create a button to load a excell file then process it

    .
    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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •