Receipts issued and record of payments

Hello there,

Try the following,

Please Login or Register  to view this content.

To use the code in your workbook:

1. Press Alt+F8
2. Clear the macro name field and replace it with OpenDebtorsWB
3. Select the Create option
4. Between the Sub OpenDebtorsWB and End Sub, copy and paste the above code
5. Please take a minute to review the code
Anything that appears in green is a comment, you will need to change parts of the code to fit your data. The comments will tell you when and how to do this.
6. Exit out of Visual Basic
7. Press Alt+F8, this time select he OpenDebtorsWB and select the Run option

If you encounter and error on this line

Please Login or Register  to view this content.

Open a workbook in the Debtors folder and in an empty cell type =CELL("filename")
this will reveal the path for you workbook's in this folder, replace the portion of the code highlighted in red with you workbook path less the filename

Please Login or Register  to view this content.

It should end up looking something like the following

Please Login or Register  to view this content.

Let me know if this works for you!

Thanks!

Mr.rvasquez

Please attach workbook so that i can understand how it works.

Hello there,

Could you please attach a sample of you workbook and I will place the code in there? The way the code is set up it's running off your computers filepath. I suggest maybe opening LEK-157 and saving it to a created test folder or your desktop and also saving the template as a file in the same location. Then follow the steps above to add the code to your saved as template file and run it from there.

Sorry thameem127, just realized you weren't the one to originally post the question. The way this code works is it's opening a file on your computer so it's a little hard to post an example file. Give me a second and I will try and create, two example files and tell you how to save them so you can test the code yourself.

Thanks!

Hello thameem127,

Attached are two example workbooks, that mimic Marianne's question.

To see the code work, please do the following,

1. Open each worksheet individually and then save the workbook as a Excel 97-2003 Workbook (*.xls)
2. Please do not change the names of the workbooks.
3. Close the JohnDoe workbook.
4. On the thameem127(Master) workbook select cell B16 and copy and pastespecial values
5. Select the cell and copy everything right of the last \
6. Right click on the Run Macro button and then select View code
7. Replace the red text in the following line of code in your code with the copied filepath from cell B16

Please Login or Register  to view this content.

8. Exit out of Visual Basic and make sure you are not in Design Mode
9. click the Run Macro button and watch it work.

10. Open the JohnDoe workbook to see what changes were made there.

Let me know if you have any questions.

Thanks!


Sorry I just realized that I forget to attach the JohnDoe File. Here you go!