Posts by Edimar Alves da Silva • 26 points
3 posts
-
0
votes1
answer32
viewsA: VBA pick up information on website
Do you speak Massao blz? I made a change to use the Children method. I changed the class as well. Follow: Sub TesteBusca() Dim IE, objElementCol, objElement, ClasseValores, ItemValores As Object Dim…
vbaanswered Edimar Alves da Silva 26 -
0
votes1
answer41
viewsA: VBA formulas with @
Selection is a generic object that can have several types. In your case it is a Range, representing a cell. To set formulas using Selection, do: Selection.FormulaLocal = "=SOMA(A1)" Formulalocal is…
-
1
votes1
answer41
viewsA: Copy Macro between VBA files
Hi, there is a simpler way. Just create a new file based on your current. Follow the code illustrating this: Option Explicit Sub MacroA() Debug.Print "MacroA" End Sub Sub MacroB() Dim ArquivoNovo As…