Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
auto run a macro aon a date i choose
- Thread starter HOMMER
- Start date
Will the file be open?
What program? What version?
Check this article for Excel 2000:
Brainbench MVP for Microsoft Word
techsupportgirl@home.com
What program? What version?
Check this article for Excel 2000:
Brainbench MVP for Microsoft Word
techsupportgirl@home.com
Hi HOMMER
Could use the scheduler of the operating system (at worst DOS's AT command) to start a batch file that opens up an Excel workbook.
Something like
c:\program files\microsoft office\office\excel.exe
\\Computer\Workbook.xls
If the Workbook calls your macro in Workbook_Open the macro will start.
Might be wise to include a ActiveWorkbook.Close.
Stew
"Even a stopped clock tells the right time twice a day."
- Thread starter
- #4
using excel 2000. No the file will not be open. But there is a different file that is opened that night. There is a macro that is run for that file. Is there a way of running the other macro from a different file.
example:
If I run a macro in book 1 could I with the same macro button in book 1 run a macro in book 2 at the same time?
book 2 is in a different file but under the same folder.
example:
If I run a macro in book 1 could I with the same macro button in book 1 run a macro in book 2 at the same time?
book 2 is in a different file but under the same folder.
I don't know why not, you'll just have to set up the whole procedure in book1 Brainbench MVP for Microsoft Word
techsupportgirl@home.com
techsupportgirl@home.com
- Status
Similar threads
- Locked
- Question