I am trying to get data from one workbook and put it in another.
What is the VB code to get this done?
I am trying to get data from one workbook and put it in another.
What is the VB code to get this done?
It depends what you are actually trying to do. Can you zip a copy of your spreadsheet and attach it to your post and tell us what particular data you want in the new workbook? This would help anyone trying to answer your question.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
all i'm trying to do is pull data from certain cells on one workbook to use in another one
Can you be more specific? How do you determine which cells you want to copy over? Is it variable, or do you want the same cells pulled over each time? Do you NEED VB, as your request seems to be easily accomplished using a formula?
ok, how it works is I have a list of vehicles, each with a corresponding unit number. i want to be able to search thru the list of vehicles in another workbook and find whichever one is selected in a combobox on the first workbook to get information from the first workbook. seeing as how i will have to do a do..while loop, i can't really use a formula to find the right unit.
all i really need is the VB syntax to open another workbook and grab data from particular cells.
so does anyone know how to accomplish this?
ok well i figured something out, but i am getting an error for some reason and can't figure out what it is.
now when i change the name of the workbook to a different file, it will work. when i change it back and try to run the code i get a runtime 1004 error.Please Login or Register to view this content.
anyone got any clues?
edit: nevermind, figured it out. had that extra apostrophe in there
Last edited by enphynity; 05-25-2007 at 05:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks