Posts by Braga • 103 points
6 posts
-
1
votes3
answers4302
viewsA: 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…
-
-2
votes1
answer1247
viewsQ: 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…
-
2
votes1
answer282
viewsA: 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)…
-
2
votes1
answer90
viewsA: 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…
-
1
votes1
answer961
viewsA: 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…
-
0
votes2
answers2049
views