Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. Public Function PROC_VAZOES(dia, bacia, indice_coluna)
  2.  
  3. Dim path As String
  4. path = "'Y:File Path[Relatorio_previsao_diaria_" & Application.Text(dia, "DD") & "_" & Application.Text(dia, "MM") & "_2019_para_" & Application.Text(dia, "DD") & "_" & Application.Text(dia, "MM") & "_2019.xls]Diária_4'!$B$1:$I$173"
  5.  
  6. PROC_VAZOES = Application.VLookup(bacia, path, indice_coluna, False)
  7.  
  8. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement