Posts by Braga • 103 points

• 1

  votes

  3

  answers

  4302

  views

  A: Picking tabs name in a closed spreadsheet

  Sub Clean_column() Range("A:A").Select Selection.ClearContents End Sub Sub Pega_name_worksheet() '-- TAKE THE NAME OF WORKSHEETS INSIDE THE WORKBOOK Application.ScreenUpdating = False…

  vba excel-vba

  answered 5 years, 2 months ago Braga 103

• -2

  votes

  1

  answer

  1247

  views

  Q: Share workbook with VBA

  I need to share a workbook on the network, but when running the code the file goes to the folder C:\Documents\. What would be the solution to this problem? Private Sub btExecuta_Click() Dim…

  vba excel-vba

  asked 5 years, 5 months ago Braga 103

• 2

  votes

  1

  answer

  282

  views

  A: How to make a VBA print

  Suggestion Depending on the situation it is better to use the formula below than to create in VBA: =EXT.TEXTO(C5;E5;F5)…

  vba excel-vba

  answered 5 years, 8 months ago Braga 103

• 2

  votes

  1

  answer

  90

  views

  A: How to "kill" a class in VBA - Excel

  This is a code I just created for another user. Converting dates. According to what you mentioned above, if I understand correctly you want to script while performing such a procedure, right? If…

  excel vba

  answered 5 years, 8 months ago Braga 103

• 1

  votes

  1

  answer

  961

  views

  A: Excel VBA changes the date format to mm/dd/yyyy

  Following model below, converting dates: Dim CData As Date Dim CData2 As Date {'--- MODELO 01} Sub DataCompra1() [C8].Select CData = [C8].Value If CData = "0" Then MsgBox "INFORME A DATA" 'Exit Sub…

  excel excel-vba

  answered 5 years, 8 months ago Braga 103

• 0

  votes

  2

  answers

  2049

  views

  A: VBA Code Adaptation to fetch photos from a folder

  I created the code for you, I hope it works. CREATING AND UPDATING IMAGE LIST FROM WINDOWS FOLDER. LINK TO DOWNLOAD THE COMPLETE FILE:…

  excel image macro insert

  answered 5 years, 8 months ago Braga 103