Posts by Felipe Costa Gualberto • 131 points
3 posts
-
0
votes1
answer477
viewsA: PROCV - How to avoid the window to select external spreadsheet when non-existent
Enter the line below at the beginning of the code: Application.DisplayAlerts = False And before the End Sub, insert: Application.DisplayAlerts = True…
-
0
votes3
answers888
viewsA: Range in Excel VBA
Edit: Sub Main() 'Altere aqui de acordo com sua necessidade: Const FILE_PATH As String = "c:\temp\exemplo.csv" Dim oList As Excel.ListObject Dim iFF As Integer Dim sLine As String Dim lRows As Long…
-
0
votes3
answers888
viewsA: Range in Excel VBA
Dynamic tables are reports assembled from a data source. It is not possible to overwrite it. The logic of the flow of mounting a report in Excel is: 1 - Define a data source 2 - Point a dynamic…