I started working with excel about 2 months ago. My supervisor requested that I create a button ("Browse") that pulls a saved file (an xls. file pulled from a database, then saved to my computer), then takes that file and pastes the information into a different tab.
Can someone help me out here? I've been looking things up on forums all day trying to figure this stuff out but due to having very limited experience, I don't understand alot of the lingo involved ect.
You are looking for a "macro".
A macro can do that
Click on star (*) below if this helps
Haha. I know that much. I'm saying, how should I go about creating the macro? Can I just record it somehow? Or, does someone have a macro code I could look at to base mine off of? I assume this is incredibly simple for someone who knows what they're doing...
Perhaps you might upload sample data
bump bump bump Please help!!
if the file name is always the same, and it is always in the same location, you could try and use the learn/record macro function, then create a macro button to activate it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The file is not always the same. I want to click a button and have it open my file folder, then I want to be able to browse for the specific file I need, open it and have the information paste into a specific tab. Can someone please give me a macro that can do this?
Sample code:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks for help tiger--It gets to this line
.Sheets(1).Range("A1").Copy wsDest.Cells(Rows.Count, "A").End(xlUp).Offset(1)
Then a "debugger" pops up. I'm not sure what the criteria is--I just want the page to copy and paste the entire the into "Sheet2". Is that possible?
What is the exact error you're getting? That code is simple enough that is shouldn't cause an error.
If you just want to copy all of the contents of the chosen workbook sheet1, then use (replace ... with desired destination location):
Please Login or Register to view this content.
you're saying replace the line I posted with the one you just did?
the desired location is "sheet2" on the page I'm on when I actually run the macro
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks