Save Special in VBA

[MJN1965]

Hi Bill, I have used your Podcast 1812 - Increment Invoice, it isexactly what I was looking for. The only issue I have is I am using Vlookup to to get part descriptions & pricing on my invoice. When the VBA saves the copy Invoice, I am getting #NA where the vlookup's where. how do I get the saved document to bring the lookup results over a paste special values or something different ?? thanks for your help.

 

[ChrisFoster]

Who is Bill?

Can you post the code you are using please?

 

[RoryA]

Who is Bill?

That would be Bill Jelen, a.k.a. MrExcel.

 

[MJN1965]

Hi Chris, this is the code...
Sub SaveWithNewName()
Dim NewFN As Variant
PosttoRegister
ActiveSheet.Copy
NewFN = "E:\My Stuff\MPM Ltd\Invoices\" & "Inv-" & Range("E8").Value
ActiveWorkbook.SaveAs NewFN, xlOpenXMLWorkbook
ActiveWorkbook.Close
NextInvoice
End Sub

 

[MJN1965]

images attached of the issue, view of main Invoice &then of what is saved.... this may help..
The description, VAT & price are via Vlookups....