I must very often "open csv file" in Excel 2013 (local install) with the following parameters.
How can that be automated this so I don`t have to always pass through this import wizard?
I don`t know if it is possible but for me, the best option would be to setup something so all I have to do is to right-click on the file -> "Send to" -> "Import that csv"
65001 : Unicode (UTF-8)
My data has headers
Delimiters = Comma
Columns data format:
C date YYYY-MM-DD
N date YYYY-MM-DD
V date YYYY-MM-DD
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…