Hi,
How could I do all those steps in title in VBA? I found some examples, but they doesn't work. I can open other workbook, but nothing more happens.. I can't perform functions in other workbook (select sheet, find first empty row..) How could I do that? My code is:
Thanks in advance!
Please Login or Register to view this content.
Last edited by etminasm; 11-03-2010 at 06:03 AM.
You don't need to select nor would I think that you need a new instance of Excel
never put an error handler in until the code is fully working
Please say what you want to copy & where to. Your code isn't very clear
Last edited by royUK; 11-03-2010 at 05:40 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I have sheet "Parts" in workbook "SCE template incl lists v7.xls"
I run Userform (AddParts) from original workbook. In that user form I need to write in new part number, price etc. And when I press "Add" button, this part should be copied to "SCE template incl lists v7.xls" sheet "Parts" in first empty row". And then save and close..
Assuming the txtArt and txtDesc are values coming from another sub, try this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi royUK,
as you said, I have deleted excel instance and select workbook and it worked. Super.. Thanks, for helping!
Hi JBeaucaire,
Thanks for another code fore it. It looks so nice, short and easy understandable. Very nice, I will use it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks