Thomas_Meyer
asked on
How to the macro that writes specified data to a text document?
Hi,
help me with a macro that creates a text file and insert the desired information? Here is a list of requirements:
1) I need a macro to check whether there is a path "\\S2\HomeS\PP 2010\Test"
2) if the path does not exist, the macro must be stopped. If the path exists, the macro check if the directory exists in the text file Usc.txt.
3) If not, the macro creates it.
4) Macro credited to a text file (into a text document to add new rows, do not overwrite the original line):
- The number of rectangles in "A1" on the first slide and insert a comma after the number
- For the first comma insert date and time in the format: "dd-mm hh:mm" and by inserting an additional point.
- The second comma insert user's name Environ ("UserName")
- The line may then look like this:
Regards,test.ppt
TM
help me with a macro that creates a text file and insert the desired information? Here is a list of requirements:
1) I need a macro to check whether there is a path "\\S2\HomeS\PP 2010\Test"
2) if the path does not exist, the macro must be stopped. If the path exists, the macro check if the directory exists in the text file Usc.txt.
3) If not, the macro creates it.
4) Macro credited to a text file (into a text document to add new rows, do not overwrite the original line):
- The number of rectangles in "A1" on the first slide and insert a comma after the number
- For the first comma insert date and time in the format: "dd-mm hh:mm" and by inserting an additional point.
- The second comma insert user's name Environ ("UserName")
- The line may then look like this:
457,18-02 19:34,thomas.meyer
Thank you very much for your help.Regards,test.ppt
TM
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
TM