macros

P

Peter

Hi,
I want to be able to run a macro (here is part of it) that copies info from one file to another. But if i change the file name (Follow_up.xls), the macro cant work. How can I run commands like this one after I have changed the file name.


Windows("Follow_up.xls").Activate
Sheets("Request for Service").Select
Range("I13:J13").Select
Selection.Copy
Windows("list.xls").Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Windows("Follow_up.xls").Activate
Application.CutCopyMode = False
Range("B2:E2").Select
Selection.Copy
Windows("list.xls").Activate
Range("B1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to run on hidden sheet 4
Macro 3
File name change 7
Filename Problem In a Macro 4
Copy of VB code to new spreadsheet 6
Can I simplify a VB code?????? 3
How to get date to move down to next cell & other referances, macr 0
Looping Macro 5

Top