Showing posts with label Code VBA. Show all posts
Showing posts with label Code VBA. Show all posts
14 December, 2020
27 July, 2020
[Free ebook]Ready to Use 101 Powerful Excel VBA Code Just Copy - Paste - Run (For Functional Users) by Anil Nahar
How to Earn 1000$ Per Month & Make your own project in excel thi books help you so much.Please read also my other published book "Ready to Use Amazing Custom function in excel".
This book is to provide basic guideline for people interested in Excel VBA programming. Collection of ready code has been used on reality platform by technical and non technical users on their routine work in corporate and not corporate world. Collection of VBA Code just paste in VBA Editor and Run Macro , no need require any technical coding language. It become smarter in excel with increase desk productivity work 10X.It just publishing for helping to easy work in excel on demand of users.
Example of Ready code :
* Convert One Cell To Multiple Rows
* Convert Text To Column
* Highlight Specific Text
* Indexing All Worksheet Name In Of Active Workbook
* Password Breaker Worksheet If you forgot
* Password Unprotected Workbook
* Unhide All Hidden Worksheets
* Image Conversion Of Selection Area
* Highlight Color Of Duplicate Value
* Data Entry Form Of Activate Sheet
This book is to provide basic guideline for people interested in Excel VBA programming. Collection of ready code has been used on reality platform by technical and non technical users on their routine work in corporate and not corporate world. Collection of VBA Code just paste in VBA Editor and Run Macro , no need require any technical coding language. It become smarter in excel with increase desk productivity work 10X.It just publishing for helping to easy work in excel on demand of users.
Example of Ready code :
* Convert One Cell To Multiple Rows
* Convert Text To Column
* Highlight Specific Text
* Indexing All Worksheet Name In Of Active Workbook
* Password Breaker Worksheet If you forgot
* Password Unprotected Workbook
* Unhide All Hidden Worksheets
* Image Conversion Of Selection Area
* Highlight Color Of Duplicate Value
* Data Entry Form Of Activate Sheet
Year:
2020
Language:
english
Pages:
137
File:
PDF, 210 KB
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
19 July, 2020
[Free Ebook]30+ Code Macro VBA 2020 PDF FULL
Read online bellow
⏬
Using the Code from Excel Macro Examples
|
How to Run a Macro
|
Excel Macro Examples
|
1. Unhide All Worksheets at One Go
|
2. Hide All Worksheets Except the Active Sheet
|
3. Sort Worksheets Alphabetically Using VBA
|
4. Protect All Worksheets At One Go
|
5. Unprotect All Worksheets At One Go
|
6. Unhide All Rows and Columns
|
7. Unmerge All Merged Cells
|
8. Save Workbook With TimeStamp in Its Name
|
9. Save Each Worksheet as a Separate PDF
|
10. Save Each Worksheet as a Separate PDF
|
11. Convert All Formulas into Values
|
12. Protect/Lock Cells with Formulas
|
13. Protect All Worksheets in the Workbook
|
14. Insert A Row After Every Other Row in the Selection
|
15. Automatically Insert Date & Timestamp in the Adjacent Cell
|
16. Highlight Alternate Rows in the Selection
|
17. Highlight Cells with Misspelled Words
|
18. Refresh All Pivot Tables in the Workbook
|
19. Change the Letter Case of Selected Cells to Upper Case
|
20. Highlight All Cells With Comments
|
21. Highlight Blank Cell in the Selected Dataset
|
22. Sort Data by Single Column
|
23. Sort Data by Multiple Columns
|
24. How to Get Only the Numeric Part from a String
|
25. Always Open Workbook with Specific Tab Activated
|
26. Save and Close All Workbooks at Once
|
27. Limit Cursor Movement in a Specific Area
|
28. Copy Filtered Data into a New Workbook
|
29. Convert All Formula into Values in Selected Dataset
|
30. Get Multiple Lookup Values in a Single Cell
|
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
17 July, 2020
[Free Ebook] 101 Excel Powerful Microsoft Excel VBA Code 2020
DOWNLOAD
Read online bellow⏬
How to Insert VBA code to Excel Workbook
This is a brief step-by-step guideline for beginners showing how to add VBA
code (Visual Basic
for Applications code) to your Excel workbook and run this macro to solve
your spreadsheet
tasks.
This step-by-step guide to be able to use the code you found in this E-Book
:
1. Open your workbook in Excel.
2. Press Alt+F11 to open Visual Basic Editor (VBE).
3. Click on your workbook name in the "Project-VBAProject" pane (at the top
left
corner of the editor window) and select Insert -> Module from the context
menu.
4. Copy the VBA code and paste it to the right pane of the VBA editor
("Module1"
window).
Then add the following lines to get your macro to work faster.
To the very beginning of the code, after all code lines that start with Dim
(if there are no
"Dim" lines, then add them right after the Sub line):
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
To the very of the code, before End Sub:
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.Calculation = xlCalculationAutomatic
These lines, as their names suggest, turn off screen refresh and
recalculating the workbook's
formulas before running the macro.
After the code is executed, everything is turned back on. As a result, the
performance is
increased from 10% to 500% (aha, the macro works 5 times faster if it
continuously
manipulates the cells' contents).
Save your workbook as "Excel macro-enabled workbook". Press Ctrl+S, then
click the "No"
button in the "The following features cannot be saved in macro-free
workbook" warning
dialog.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
DOWNLOAD
Read online bellow⏬
How to Insert VBA code to Excel Workbook
This is a brief step-by-step guideline for beginners showing how to add VBA
code (Visual Basic
for Applications code) to your Excel workbook and run this macro to solve
your spreadsheet
tasks.
This step-by-step guide to be able to use the code you found in this E-Book
:
1. Open your workbook in Excel.
2. Press Alt+F11 to open Visual Basic Editor (VBE).
3. Click on your workbook name in the "Project-VBAProject" pane (at the top
left
corner of the editor window) and select Insert -> Module from the context
menu.
4. Copy the VBA code and paste it to the right pane of the VBA editor
("Module1"
window).
Then add the following lines to get your macro to work faster.
To the very beginning of the code, after all code lines that start with Dim
(if there are no
"Dim" lines, then add them right after the Sub line):
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
To the very of the code, before End Sub:
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.Calculation = xlCalculationAutomatic
These lines, as their names suggest, turn off screen refresh and
recalculating the workbook's
formulas before running the macro.
After the code is executed, everything is turned back on. As a result, the
performance is
increased from 10% to 500% (aha, the macro works 5 times faster if it
continuously
manipulates the cells' contents).
Save your workbook as "Excel macro-enabled workbook". Press Ctrl+S, then
click the "No"
button in the "The following features cannot be saved in macro-free
workbook" warning
dialog.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
14 July, 2020
[Free Ebook]1000+ Code Excel Visual Basic Macro Examples VBA 2020
Read online bellow⏬
The examples and information in these books are for illustration only, without warranty
either expressed or implied, including, but not limited to, the implied warranties of
merchantability and/or fitness for a particular purpose.
The easiest way to search for a subject is to click on the Search tab and type in key words
in lower case. Then choose a topic to display. To turn search highlighting off:
· Click on Options
· Click the menu item "Search Highlighting Off
If on, then when you do a search and click on a topic, all matching words are
highlighted. If you change the setting, you will need to display a different topic and then
click back on the original topic to see the change.
To copy an example:
· Highlight the code you want to copy
· Right click and select "Copy"
· Or, press CTLC
Topics can be stored in a favorites list for quick access. First display the topic if it is not
already displayed. Then click on the Favorites tab and click the "Add" button
#evba #etipfree #eama #kingexcel📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
26 April, 2020
24 April, 2020
Pick Names At Random From A List – Excel VBA
In this blog post we will explore how to pick names at random from a list using Excel VBA.
Suppose we were picking the names for a draw or competition and needed to generate a list of maybe 3, 5 or any number of names from a list.
These names must be selected at random and be unique. You cannot select the same name more than once.
The macro code shown below can be copied and pasted into a VBA module and adapted for your use. Comments have been used to identify the key and more complex parts of the macro.
This macro uses an array variable to store the names being randomly selected from the list. Every time a name is selected, it is checked against this array to ensure that it has not already been selected. If it has, then another name is randomly selected.This macro demonstrates some key VBA techniques including a Do While and a For Next loop. It also uses variables including a string array and an If statement.
Macro to Pick Names at Random from a List
Sub PickNamesAtRandom() Dim HowMany As Integer Dim NoOfNames As Long Dim RandomNumber As Integer Dim Names() As String 'Array to store randomly selected names Dim i As Byte Dim CellsOut As Long 'Variable to be used when entering names onto worksheet Dim ArI As Byte 'Variable to increment through array indexes Application.ScreenUpdating = False HowMany = Range("D3").Value CellsOut = 6 ReDim Names(1 To HowMany) 'Set the array size to how many names required NoOfNames = Application.CountA(Range("A:A")) - 1 ' Find how many names in the list i = 1 Do While i <= HowMany RandomNo: RandomNumber = Application.RandBetween(2, NoOfNames + 1) 'Check to see if the name has already been picked For ArI = LBound(Names) To UBound(Names) If Names(ArI) = Cells(RandomNumber, 1).Value Then GoTo RandomNo End If Next ArI Names(i) = Cells(RandomNumber, 1).Value ' Assign random name to the array i = i + 1 Loop 'Loop through the array and enter names onto the worksheet For ArI = LBound(Names) To UBound(Names) Cells(CellsOut, 4) = Names(ArI) CellsOut = CellsOut + 1 Next ArI Application.ScreenUpdating = True End Sub
Watch the Video
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
23 April, 2020
[Free PDF ebook]Top 100 Excel power bundle userful macro codes - update 2020
📤DOWNLOAD FREE ON ETIPFREE.COM
⏩https://bit.ly/3byW7vJ
#evba #eama #etipfree
📤DOWNLOAD FREE ON ETIPFREE.COM
⏩https://bit.ly/3byW7vJ
#evba #eama #etipfree
15 April, 2020
[Free ebook]Ready to Use 101 Powerful Excel VBA Code 2020 (For Functional Users) by Anil Nahar
How to Earn 1000$ Per Month & Make your own project in excel thi books help you so much.Please read also my other published book "Ready to Use Amazing Custom function in excel".
This book is to provide basic guideline for people interested in Excel VBA programming. Collection of ready code has been used on reality platform by technical and non technical users on their routine work in corporate and not corporate world. Collection of VBA Code just paste in VBA Editor and Run Macro , no need require any technical coding language. It become smarter in excel with increase desk productivity work 10X.It just publishing for helping to easy work in excel on demand of users.
Example of Ready code :
* Convert One Cell To Multiple Rows
* Convert Text To Column
* Highlight Specific Text
* Indexing All Worksheet Name In Of Active Workbook
* Password Breaker Worksheet If you forgot
* Password Unprotected Workbook
* Unhide All Hidden Worksheets
* Image Conversion Of Selection Area
* Highlight Color Of Duplicate Value
* Data Entry Form Of Activate Sheet
This book is to provide basic guideline for people interested in Excel VBA programming. Collection of ready code has been used on reality platform by technical and non technical users on their routine work in corporate and not corporate world. Collection of VBA Code just paste in VBA Editor and Run Macro , no need require any technical coding language. It become smarter in excel with increase desk productivity work 10X.It just publishing for helping to easy work in excel on demand of users.
Example of Ready code :
* Convert One Cell To Multiple Rows
* Convert Text To Column
* Highlight Specific Text
* Indexing All Worksheet Name In Of Active Workbook
* Password Breaker Worksheet If you forgot
* Password Unprotected Workbook
* Unhide All Hidden Worksheets
* Image Conversion Of Selection Area
* Highlight Color Of Duplicate Value
* Data Entry Form Of Activate Sheet
Year:
2017
Language:
english
Pages:
137
File:
EPUB, 210 KB
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
14 April, 2020
[Free ebook] The Best Codes Macro VBA 2020 on EVBA.info
DOWNLOAD
Using the Code from Excel Macro Examples Here are the steps you need to
follow to use the code from any of the examples:
. Open the Workbook in which you want to use the macro.
. Hold the ALT key and press F11. This opens the VB Editor.
. Right-click on any of the objects in the project explorer.
. Go to Insert --> Module.
. Copy and Paste the code in the Module Code Window. In case the example
says that you need to paste the code in the worksheet code window, double
click on the worksheet object and copy paste the code in the code window.
Once you have inserted the code in a workbook, you need to save it with a
.XLSM or .XLS extension.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
07 April, 2020
[Free Ebook PDF]1000+ CODE VBA MACRO FOR EXCEL EXAMPLE
DOWNLOAD
The examples and information in these books are for illustration only,
without warranty
either expressed or implied, including, but not limited to, the implied
warranties of
merchantability and/or fitness for a particular purpose.
DOWNLOAD
The examples and information in these books are for illustration only,
without warranty
either expressed or implied, including, but not limited to, the implied
warranties of
merchantability and/or fitness for a particular purpose.
17 March, 2020
[Free ebook Download]Excel - 51 Awesome Macros: Save time and be more productive by Philippe A. Louis
DOWNLOAD PDF
DOWNLOAD AZW3
Description
In order to take your productivity to the next level, you need to apply the power of Excel Macros. Inside this book, you'll get all information you need to save time and explore new functionalities in Excel with ready-to-use VBA Codes.
Inside the book:
- Provides an explanation of how implement macros
- Send a full email model with attachment with a single click of mouse
- Automatically creates PowerPoint presentation
- Save the same file in multiple directories
- Automatically adjust chart Labels
- Macros to protect the Spreadsheet with login and password
- Control the users who access the spreadsheet.
- And much more…
Inside the book:
- Provides an explanation of how implement macros
- Send a full email model with attachment with a single click of mouse
- Automatically creates PowerPoint presentation
- Save the same file in multiple directories
- Automatically adjust chart Labels
- Macros to protect the Spreadsheet with login and password
- Control the users who access the spreadsheet.
- And much more…
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
12 February, 2020
[Free ebook]100+ Code Excel Powerful Microsoft Excel VBA Code 2020 on EVBA.info
DOWNLOAD
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
#eama #evba #etipfree
DOWNLOAD
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
#eama #evba #etipfree
08 February, 2020
[Free ebook]Advance Excel Formula (For all users) Ready to use Customize Function-Anil Nahar
DOWNLOAD PDF
DOWNLOAD EPUB
Author of "Ready to Use 101 Powerful Excel VBA Code" Successfully like by millions of users , Now going ahead to develop Custom Excel Function.
Excel having large collection of functions in-built . Mostly those functions are sufficient to complete the work. Sometimes, Excel doesn't have a pre-built function that suits a specific need, Well not to worry about it , you can create your own function called User Defined Function or custom Excel function with help of Visual Basic for Applications (VBA). You can access a User Defined Function any time just like any other Excel function.
But the main problem is you should have good knowledge of Excel VBA Programming and need so much time to writing code as desire.
This book helps you to use ready code by just copy paste and enjoy the work.
Benefits of this books :
Available readymade function which is very unique and rare.
Create new formula in easy way instead of using long formula
Without any technical knowledge use the new function
Impress your boss with fast working
#evba #etipfree #kingexcelExcel having large collection of functions in-built . Mostly those functions are sufficient to complete the work. Sometimes, Excel doesn't have a pre-built function that suits a specific need, Well not to worry about it , you can create your own function called User Defined Function or custom Excel function with help of Visual Basic for Applications (VBA). You can access a User Defined Function any time just like any other Excel function.
But the main problem is you should have good knowledge of Excel VBA Programming and need so much time to writing code as desire.
This book helps you to use ready code by just copy paste and enjoy the work.
Benefits of this books :
Available readymade function which is very unique and rare.
Create new formula in easy way instead of using long formula
Without any technical knowledge use the new function
Impress your boss with fast working
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
07 February, 2020
Free Code VBA the Office programming power solution
DOWNLOAD
👍Các bạn tải App Quản Trị Excel cài trực tiếp trên điện thoại Iphone và Android mới nhất tại đây : https://www.quantriexcel.info/p/than-gui-cac-ban-tai-quantriexcel.html
02 February, 2020
[FREE Invoice Generator Template] Save Excel Invoice as PDF
I recently had to get myself registered under Goods and Services Tax (GST) so that I can file for GST on my earnings.Once you have a GST number, you need to file your tax return every month (in India).
So every month, my Charted Accountant would reach out to me asking for sales invoices so that he can file for the GST.
In my case, there only a handful of invoices to be created, as I have only a few sources of income.
However, since this is additional work, I wanted to get this done as quickly as possible.
So to minimize my effort, I created an Invoice Generator template in Excel that allows me to have all the data in one place, and then it automatically creates PDF invoices for all the data points.
As you can see below, all I need to do is double-click on the client’s name (in column B), and it would instantly create and save the invoice in the PDF format in the specified folder.

You can also modify the invoice template to suit your company’s format (which would require you to change the VBA code a little – explained below).
It creates an invoice as shown below:

This Tutorial Covers:
How does this Invoice Generator Template Works?
In this invoice template, there are two worksheets:
- Details – This is where you need to specify the details of the sale/transaction. To keep everything together, I have created one row for each record. All the details of a transaction are recorded in the row.
- Invoice Template – This is a placeholder template of the invoice where some fields are left empty. I need to generate a separate invoice for all the sale records and the details for each invoice is picked up from the Details worksheet.
I also have a folder on my desktop with the name ‘Invoice PDFs’. This is the folder where the newly created PDF invoices are saved.
Now let’s see how this works:
You need to double-click on the client’s name (highlighted in orange in the Details sheet).
That’s it!
When you double-click on the client name, it kickstarts the VBA magic in the back end and the following things happen:
- Details for the client and the sale transaction are picked up and the invoice template sheet is populated with these details.
- A new workbook is created that has the details of the selected client (on which you double-clicked).
- This workbook is saved as a PDF in the Invoice PDF folder.
- The new workbook is closed without saving.
In case there are any changes in the invoice details, you can double-click on the client name again, and a new invoice will be created (and this will overwrite the old one).
Note that the names of the invoices are based on the month and the invoice number.
For example, an invoice with the date 15-04-2019 and the invoice number as 1 would be saved with the name April 2019_1.pdf. This helps in keeping track of the invoices in case you have too many.
You can download the Invoice Generator Template by clicking on the button below:
Modifying the Invoice Generator Template
I created this invoice template with a format that I needed for my GST filings.
If you need a different format, you’ll have to edit the template and then adjust the backend VBA code.
Let me first show you the code and explain how it works:
Sub CreateInvoice(RowNum As Integer)
Application.ScreenUpdating = False
Dim wb As Workbook
Dim sh As Worksheet
With shInvoiceTemplate
.Range("D10") = shDetails.Range("A" & RowNum)
.Range("D11") = shDetails.Range("B" & RowNum)
.Range("D12") = shDetails.Range("C" & RowNum)
.Range("B15") = shDetails.Range("D" & RowNum)
.Range("D15") = shDetails.Range("F" & RowNum)
.Range("D16") = shDetails.Range("G" & RowNum)
.Range("D18") = shDetails.Range("E" & RowNum)
End With
FPath = "C:\Users\sumit\Desktop\Invoice PDFs"
Fname = Format(shInvoiceTemplate.Range("D10"), "mmmm yyyy") _
& "_" & shInvoiceTemplate.Range("D12")
shInvoiceTemplate.Copy
ActiveSheet.Name = "InvTemp"
Set wb = ActiveWorkbook
Set sh = ActiveSheet
sh.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
FPath & "\" & Fname, Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False
wb.Close SaveChanges:=False
ThisWorkbook.Activate
Application.ScreenUpdating = True
End Sub
The above code is what copies the details of a transaction, fills the invoice placeholder template with those details, creates a new workbook, and save the new workbook as a PDF in the specified folder.
If you have a different template or a different folder location, you need to modify the below-highlighted parts of the code:

- The first highlighted section is what takes the details from the Details sheet and populates the invoice template. If you decide to modify the invoice template, you need to make sure you are picking the right details by modifying this part of the code.
- This line specifies the folder location. In my case, it was a folder on my Desktop. You can specify the address of the folder where you want the invoices to be saved.
Note that I have renamed the worksheet code name to ‘shDetails’. I have done this so that I can use the name – shDetails – in my code and it would continue to work even if you change the name of the sheets in the worksheet.
If you want to learn more about the sheet name and the code name, have a look at this (check out the section on using the Worksheet code name).
Where is the code in the workbook?
The code is placed in the back-end of the Excel workbook in a module.
To access the code, follow the below steps:
- Click the Developer tab.
- Click the Visual Basic option. This will open the VB Editor window.
- In the Visual Basic editor, double-click on the Module to open its code window. You’ll find the code mentioned above.
In case you’re creating a template yourself, you may not find the Module in a new workbook. You need to right-click on any of the workbook objects, go to Insert, and then click on Module. This will insert a new module. 

Making the Double-click functionality to Work
The above code does all the heavy lifting, but you need to connect it to the double-click event.
This means that the above VBA macro code needs to run whenever someone double-clicks on the filled cells in the client name column.This can be done by inserting the following code in the worksheet code window:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Cells <> "" And Target.Column = 2 Then
Cancel = True
Call CreateInvoice(Target.Row)
End If
End Sub
Here are the steps to insert this code in the worksheet backend:
- Right-click on the ‘Details’ worksheet tab
- Click on the ‘View Code’ option.
- Copy and paste the above code into the code window that appears.
The above code does the following things:
- Checks if the cell that has been double-clicked has the client details or not. It uses the IF statement to check and run the code only if the cell is not empty and in Column B.
- If both the specified criteria are met, it disables double-click functionality (which is to get into the edit mode) and calls the ‘CreateInvoice’ subroutine, which is stored in the Module. It also passes the row number value to the subroutine. For example, if I double-click on the client name in the third row, it will pass 3 as the value to the CreateInvoice subroutine.
- Once the ‘CreateInvoice’ subroutine is executed – which creates the PDF of the invoice – it ends.
Saving the Invoice Template as Excel (instead of PDF)
If you want to save the invoice templates as Excel files and not as PDFs, you can use the below code instead:
Sub CreateInvoice(RowNum As Integer)
Application.ScreenUpdating = False
Dim wb As Workbook
Dim sh As Worksheet
With shInvoiceTemplate
.Range("D10") = shDetails.Range("A" & RowNum)
.Range("D11") = shDetails.Range("B" & RowNum)
.Range("D12") = shDetails.Range("C" & RowNum)
.Range("B15") = shDetails.Range("D" & RowNum)
.Range("D15") = shDetails.Range("F" & RowNum)
.Range("D16") = shDetails.Range("G" & RowNum)
.Range("D18") = shDetails.Range("E" & RowNum)
End With
FPath = "C:\Users\sumit\Desktop\Invoice PDFs"
Fname = Format(shInvoiceTemplate.Range("D10"), "mmmm yyyy") _
& "_" & shInvoiceTemplate.Range("D12")
shInvoiceTemplate.Copy
ActiveSheet.Name = "InvTemp"
Set wb = ActiveWorkbook
Set sh = ActiveSheet
sh.Name = Fname
wb.SaveAs Filename:=FPath & "\" & Fname
wb.Close SaveChanges:=False
ThisWorkbook.Activate
Application.ScreenUpdating = True
End Sub
The above code saves the invoice as an Excel workbook with the same naming convention. The worksheet in the workbook that contains the filled invoice in each saved workbook is also named the same.
#evba #etipfree #kingexcel📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1