ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto run macros when opening CSV files (https://www.excelbanter.com/excel-programming/278078-auto-run-macros-when-opening-csv-files.html)

[email protected]

Auto run macros when opening CSV files
 
Does anyone know of a way to automatically run a macro when I open a CSV
file in Excel.
I know how to use run a macro when I open an excel file, but this won't
work for CSV's.
I know i could just create a macro and press a key once the csv is open
but would like to know if this could be automated all together.

Is there a way to re-programme the file open option for CSV's ?

Rafael Ortiz[_3_]

Auto run macros when opening CSV files
 
Have you tried naming the macro Auto_Open()

MRO


wrote in message
...
Does anyone know of a way to automatically run a macro when I open a CSV
file in Excel.
I know how to use run a macro when I open an excel file, but this won't
work for CSV's.
I know i could just create a macro and press a key once the csv is open
but would like to know if this could be automated all together.

Is there a way to re-programme the file open option for CSV's ?





All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com