Sub or Function not defined VBA

Question

1.00/5 (2 votes)

See more:

I used the same method for my invoices and now that I want to apply it to the billing statement it gives me Compile error: Sub or Function not defined. Even I run it it highlights the NEXTBILL. I am not sure how to fix it. I am trying to Save my worksheet as a separate file but before it does that I want it to register on my registry.I want it to save it as the title BillingStatement with the statement #. Please advice

Sub SaveStatementWithNewName()
Dim NewFN As Variant
PostToRegister
ActiveSheet.Copy
NewFN = "C:\Users\iaquino\Documents\Billing Statements\" & Range("K4").Value & ".xlsx"
ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook
ActiveWorkbook.Close
NextBill

Posted 14-Dec-15 7:25am

Member 12196950

Add a Solution

Comments

Richard Deeming 14-Dec-15 14:06pm

Sounds like the method NextBill isn't defined; or it's defined in the active workbook, which you've just closed.

Member 12196950 14-Dec-15 14:56pm

Yes, so what im trying to do is save a copy of all previous invoices. Then create file name with billing statement and billing #. So I changed the NExtBill to NextBillingStatement.

ZurdoDev 14-Dec-15 15:13pm

1. Reply to the comment so that the user is notified.
2. Did you resolve your problem? If so, please post a solution so this no longer shows unanswered. If you did not resolve your problem then what is the question?

Member 12196950 15-Dec-15 11:00am

How do I correct the error. What I am trying to do is, save each bill on a separate workbook after I enter it and before I clear it. I was able to do this with the invoices but I can not figure out how to fix the error. I also want the bill to post the information on the register tab before saving it as its own workbook, I am very new to this VBA program.

RedDk 16-Dec-15 14:13pm

'Been a long time since I looked at VBA code but one thing strikes me here and that is the string NewFN is using a non-8dot3 path directory. So, you might try reconstructing that using whatever DIR /X (commandline output) tells you it's "short name" happens to be. Something like: "Billin~2", etc.

Just a thought.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)