hi guys/gals
got a new problem i know you lot can help with :P,
i have a spreadsheet that i want to take info from a file and dump it in,
there is a few files i use so i was going to use a drop down list to name the file i want the macro to use for example
luckily the way the file is saved the only sheet in there will be the same as the file titleFileA = Range("A1").value
i now need to open the file would it be simpily
the code i have atm for a little test isSelect.C:\Users\u5563233\Desktop\"FileA".open
but it ant working ( because its S***)FileA = Range("A1").Value 'Select.C:\Users\u5563233\Desktop\"FileA".open Sheets(FileA).Select Range("a1:b30").Select Application.CutCopyMode = False Selection.Copy
any help would be mint its an ongoing project so am working my way through.
Many thanks
Kieran
Last edited by Kezwick; 10-11-2011 at 09:43 AM. Reason: Wrong Section
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks