Posts by Edimar Alves da Silva • 26 points

• 0

  votes

  1

  answer

  32

  views

  A: 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…

  vba

  answered 4 years ago Edimar Alves da Silva 26

• 0

  votes

  1

  answer

  41

  views

  A: 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…

  excel vba excel-vba

  answered 4 years ago Edimar Alves da Silva 26

• 1

  votes

  1

  answer

  41

  views

  A: 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…

  vba excel-vba macro

  answered 4 years, 5 months ago Edimar Alves da Silva 26