I have a workbook consisting of 3 sheets. Using the workbook command opens the CSV file as a workbook in place of my current workbook rather than opening it in place of the current sheet I'm on. The other problem is that this just opens the data exactly as is, and doesn't preseve any of the import preferences/settings I established when manually doing it through a query. At worst I need to be able to open it in a sheet within the current workbook, but at best I just need a way to do the refresh automatically without having to manually specify the file each time.