| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto run Macro when file is replaced daily?
I have a process in Access that transfers a query to a spreadsheet in Excel
every day, replacing the spreadsheet named "PROCESS.txt" each day. I am trying to find out if there is a way when a file is opened with a specific name, such as above "PROCESS.txt" to program the macro DLYPROChdr to run automatically? I know to do it in the original workbook will work, but if the workbook is replaced daily, won't it also replace the macro? Or maybe I've confused myself. I have a macro that builds the headers in the spreadsheet and formats the columns. I want it, every morning when Access transfers the spreadsheet to Excel as PROCESS.xls to run that macro automatically when the file is opened from it's designated folder. Hope someone can help me... ????? Thanks!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto run Macro when file is replaced daily?
Sorry, not sure why this posted....ignore this one, the 2nd post is the right
one..... "Tasha" wrote: I have a process in Access that transfers a query to a spreadsheet in Excel every day, replacing the spreadsheet named "PROCESS.txt" each day. I am trying to find out if there is a way when a file is opened with a specific name, such as above "PROCESS.txt" to program the macro DLYPROChdr to run automatically? I know to do it in the original workbook will work, but if the workbook is replaced daily, won't it also replace the macro? Or maybe I've confused myself. I have a macro that builds the headers in the spreadsheet and formats the columns. I want it, every morning when Access transfers the spreadsheet to Excel as PROCESS.xls to run that macro automatically when the file is opened from it's designated folder. Hope someone can help me... ????? Thanks!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto run Macro when file is replaced daily?
Sorry, not sure why this posted....ignore this one, the 2nd post is the right
one..... "Tasha" wrote: I have a process in Access that transfers a query to a spreadsheet in Excel every day, replacing the spreadsheet named "PROCESS.txt" each day. I am trying to find out if there is a way when a file is opened with a specific name, such as above "PROCESS.txt" to program the macro DLYPROChdr to run automatically? I know to do it in the original workbook will work, but if the workbook is replaced daily, won't it also replace the macro? Or maybe I've confused myself. I have a macro that builds the headers in the spreadsheet and formats the columns. I want it, every morning when Access transfers the spreadsheet to Excel as PROCESS.xls to run that macro automatically when the file is opened from it's designated folder. Hope someone can help me... ????? Thanks!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I get old replaced excel file | Excel Discussion (Misc queries) | |||
| Auto Create an Excel Backup File on a Daily Basis | Excel Discussion (Misc queries) | |||
| Auto run Macro when file is replaced daily? | Excel Programming | |||
| Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
| Macro to copy daily text file | Excel Programming | |||
Linear Mode
