LinkBack URL
About LinkBacks
I have an existing macro that needs some adjustments. Not very excel literate. Need help. Thanks. Ginger Taylor
I have an existing macro that needs some adjustments. Not very excel literate. Need help. Thanks. Ginger Taylor
Hi Ginger
Please explain what is the issue...
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.
John
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.
Here is the file and the macro I use. When I run the different buttons (codes) it processes my file, but I have had to change the rent owed by certain dealers and I have added new dealers, and their rent does not show up on the end sort of D&C sorted tab. Also, when I run the Create Files code, it does not work. I get a run time error and sometimes an error that refers to not being able to find the path or file. I use the same file over each month. I process the file that is saved in the folder where the DEALERS and CONSIGNMENTS files are created. Everything worked fine for a couple of months, and now I must have done something. I change the name and delete the information for the previous month, but none of the columns that contain formulas. I wish there was a way to have a template already clean to use each month because perhaps by deleting out old information, I do something so that your code do not work. Mom not so good, on last legs. I stay with her now and only come home to do the bookkeeping. Thanks for having a look at this. Hope all is well with you. Ginger
John: I think I solved the problem with the Dealer rent being calculated. I finally had some time to meticulously go through how names were spelled in the RENT tab so it would match the dealer name in the combined file. Maybe this is one down. Now, I just have to figure out how to make the Create Files code work. Ginger
Hi John: I noticed that this time when I ran the macro, there were no automatic page breaks after each name's total in the D & C Sorted tab. I put them in manually, but they used to be automatic. Is this fixable? Thanks, Ginger
NEVERMIND the question about automatic page breaks. I found where they appear. Silly me. So that question is off the table. the error I get when trying to run the create files code is run time error 76, path not found.
Hi Ginger
Was unable to access the Forum yesterday. Sounds like you have most of your issues resolved. I'd assume the Files you posted are out of date. Please post Files that reflect the changes you made and detail any remaining issues you may have.
Hi Ginger
Took a quick look at your Files. As you know, the Code creates a file for each of your Consignees. If the Consignee Name contains an Illegal Character the File cannot be created. These Characters are ".", "\", "/", "?", "*", "|", "<", ">", ":", "[", "]", Chr(34).
This Consignee #G" has an Illegal Character in it's Name (Chr(34)), the Quote Mark. Fix these Names and the Code will likely run as expected.
NEVERMIND the question about automatic page breaks. I found where they appear. Silly me. So that question is off the table. the error I get when trying to run the create files code is run time error 76, path not found.
Yes, I think all is well. Am I correct that if I need to add a dealer rent or change the dealer rent that I would do it only in the RENT tab on my worksheet and that the name the way it is written in the RENT tab must match exactly how the sales slip is entered in the main file? Thanks, Ginger
Hi Ginger
This is correctThe Code takes each Name in Column A of the Rent Tab and looks for it in Column C of D & C Sorted. If it finds it the Rent from Column B of the Rent tab is applied to the Name found in D & C Sorted.Am I correct that if I need to add a dealer rent or change the dealer rent that I would do it only in the RENT tab on my worksheet and that the name the way it is written in the RENT tab must match exactly how the sales slip is entered in the main file
If the Name is not spelled correctly or does not exist in the Rent tab it won't be found in D & C Sorted and no rent will get applied.
I'll take a look at thisWhat do you clear? Only Sheet 1, the actual Monthly Sales?I wish there was a way to have a template already clean to use each month
Last edited by jaslake; 05-03-2013 at 12:59 PM.
Hi Ginger
Try the attached for creating a new, blank Month Sales Workbook. You'll need to explain your File/Folder Structure so we can get stuff in the right place. For the moment place both attached files in the same Folder. Open the Macro Book and click the Start New Month Button...follow the prompts...let me know of issues.
Hi John: Things worked well for a couple of months, then I got another run time error when running the create files code. I am searching for those scoundrel characters I am not supposed to have--no luck. I may have to ask for help again, but I shall persevere myself to see what I can do. Cheers. Ginger
P.S. Have not tried the start new month and macro book 13 yet. Mom's not so good so every moment is filled with caregiving. Hardly get to my computer except at the end of the month since I stay at her house.
Hi Ginger
Take care of Mom...in His infinite wisdom, God gave us only one...the Parent becomes the Child...the Child becomes the Parent...pretty neat in His scheme of things.
I can't help with Mom, only offer words of encouragement. I CAN help with your other issue. Lean on me as necessary.
Last edited by jaslake; 06-03-2013 at 10:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks