RefreshAll

Hello,

I am using the "Get External Data" function in my Workbook to extract CSV text. The CSV sheet gets updated periodically so I recorded a macro to automate the RefreshAll. It works great but would like to modify the macro so the "Import Text File" selector window doesn't appear every time. There is only one CSV file to extract from called "Dumb_Data" (I know it's a silly name, wasn't my choice lol).

Here is the code I have...

Sub ExtractPriceBook()


Application.ScreenUpdating = False


    Sheets("PriceBook").Select
    ActiveWorkbook.RefreshAll
    Sheets("Invoice").Select
    Range("A1").Select
    
Application.ScreenUpdating = True
    
End Sub

Re: RefreshAll

It works like a charm!

Thank you so much for your help!!