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!!!

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!!!

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!!!