|
-
Nov 21st, 2000, 11:58 AM
#1
Thread Starter
New Member
I used the Macro record function in Excel to create the following code.
Workbooks.OpenText FileName:="C:\Business\UserDocs\Schd_C_All.txt"
Range("A1 11").Select
Selection.Copy
Windows("SchedC.xls").Activate
Range("K38").Select
ActiveSheet.Paste
Windows("Sched_C_All.txt").Activate
ActiveWindow.Close
The problem is that when I run my macro the following line does not work. What is wrong with my code?
Windows("Sched_C_All.txt").Activate
PLEASE HELP!
Thanks!!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote