Macro append excel files
hello everybody,
I got 50 excel charts, each one with 10.000 lines and same variables, that i need to append. I would love to do it automatically. I'm on mac or PC, and i tried several macros i found on internet but no one worked. One of them is this one:
How can I do ? DO you know what is the problem in this macro ? or is there an other one ?
Please Login or Register to view this content.
thank you very much
Last edited by JBeaucaire; 06-12-2016 at 01:35 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
It would be simpler if you SHOW us the problem in a workbook.
Attach a sample workbook. Make sure there is just enough chart data to demonstrate your need using BEFORE sheet and an AFTER sheet if needed to show the update you're trying to complete or automate.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks