Hello. "Macros.xls" is where I store all of my macros. I get another file daily which contains the data that I would like to run the macos on. I have written a simple macro that copies data from my daily file and pastes into the same file in the same sheet. The problem I am having is that when it gets to the paste command, it is pasting it in the Macros.xls file, instead of in the daily file. Is there any way to force it to paste within the daily file? The name of the daily file changes daily, so I'd rather not hard-code the daily file name into my macro. Any suggested code or tips would be helpful!
--~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
