I don't know about the VBA but a good man helped me about this code and it was working good, I have to attach it every month to the new excel file.
this month it gives an error, but i can't understand why ?
may you please check and tell me ??
thank you in advance
Last edited by nasser; 06-23-2012 at 01:47 AM. Reason: Change Thread name according to Forum Rule's
not sure but try to replace original with Sheets("original")
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
it was sheet1 and i replaced it to original.. sheet1 was working for the last months
as you wish...
Nasser,
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Sheet1 is the Code Name and original is the Name of the sheet. They are not the same thing. You can use the code name in the way it is used in the code, but not the name. In your case the code name of the sheet is still Sheet1, no matter that name is different - i.e. original. You must use the code name or change your code as suggested by john55.
If you are pleased with a member's answer then use the Star icon to rate it.
Buran,
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc
I had the thread open, before your request. I saw it only after I post my reply. sorry, no intention to violate the rulesOriginally Posted by arlu1201
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
nasser 
Register To Reply
Bookmarks