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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Edit Notepad File and Run Excel Sheet Macro

Status
Not open for further replies.

deltaair

IS-IT--Management
Nov 3, 2005
43
CH
In my company there is a program that pulls information from various systems. This "information pulling" I have to execute every Monday and Thursday for 7 days in advance. Its like forecasts and stuff. I used to enter each day's commands in the system manually, but I discovered a "macros, ability" in the system.

However, this works only if the user constantly updates the dates in the macro and then it pulls information. I edit these macros in notepad in Windows. The system has capability to take the current date, but it cannot increment the date for 7 days. So I have to run that program by changing the date again and again.

Is there a way to automatically link up the current date in notepad and then increment the date. I have to do notepad or an independent program because, this macro is in a .CKY form which is only for the system.
 
As you know Notepad is a simple text file. You can create a text file in Excel and write it out to a Notepad file. Use the script to run the 3rd party app as a template and just get the date from Excel.
 
This may be a naive question but how do I make the the 3rd party app run as a template.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top