Excelguru Forums » VBA Programming
109 FOLLOWERS
A forum to get free help with Excel, Power Query, Power Pivot and other Microsoft Office products. This section of the forum offers help with programming In Excel including VBA, VB.NET and XML (Ribbon Customization).
Excelguru Forums » VBA Programming
2w ago
Hi
I have a vba line something like below, which reads English words No problem
Worksheets("Sheet3").Range("D4").Speak < Speaks whatever word is in cell D4 in English
Is it possible to enter foreign words in cell D4 ( in my case Armenian ) and have it pronounce it in the native language ?
Example Armenian "Բարև" pronounced as Barev which means Hello
I dont want to imitate the words in English as the pronunciation is not correct.
Any Help would be appreciated.
Thanks ..read more
Excelguru Forums » VBA Programming
2w ago
Hello everyone, I have very, very limited knowledge of VBA and I generally just find code does something similar to what I need and try to modify it it to work for me. Not for this one though lol .
In this instance I have a button in a report summary, I would like to click the button "Send Email to Team" and have it highlight and copy a range from the report, open a new Outlook email, enter the "To", "subject" and Text in body and then paste the selection as a picture.
I have the code that...
Read more ..read more
Excelguru Forums » VBA Programming
1M ago
Hi all,
Hope all are well.
Can someone please help with a solution for my post in below link? (Giving link to avoid post duplication in multiple forums)
Visit post
Many thanks in advance ..read more
Excelguru Forums » VBA Programming
2M ago
Hello,
I need help accessing external PDF files and printing them. I currently have the following workflow:I have to fill out a PDF form with form details and save it as a new PDF. Since I don't (can't) use Acrobat, I have to print the PDF using a PDF printer. With this I want to save the new PDF at a specific location.Almost everything works except saving again.
I can view or print the PDF.
- Create and save FDF file
- Rename FDF file to PDF
- Open PDF
But don't print PDF with save...
Read more ..read more
Excelguru Forums » VBA Programming
2M ago
Hello,
I need help accessing external PDF files and printing them. I currently have the following workflow:I have to fill out a PDF form with form details and save it as a new PDF. Since I don't (can't) use Acrobat, I have to print the PDF using a PDF printer. With this I want to save the new PDF at a specific location.Almost everything works except saving again.
I can view or print the PDF.
- Create and save FDF file
- Rename FDF file to PDF
- Open PDF
But don't print PDF with save...
Read more ..read more
Excelguru Forums » VBA Programming
4M ago
Hi Excel Gurus,
The below code which works well to generate the email alerts on the 90th day anniversary of the hire date. BUT, the only thing I need help with is the “subject body”
I want to turn the outlook email subject body into HTMLBODY so I can bold the cell values to distinguish from the rest of the script. I don’t know how to do that!
Currently I have it in regular body as you can see in the highlighted orange below.
Could someone please help me turn it into HTMLBODY mode ...
Read more ..read more
Excelguru Forums » VBA Programming
10M ago
Hi,
I would like some help some VBA to strip out some rows in the attached sample file.
The sample contains multiple door access entry and exits times, which over the day can be quite a lot of information.
Overall I will use a pivot table to break down the information to date/department/user with Min and Max time.
What i'd like to do is to minimise the data by removing the rows that are not required, so the end result will be 2 rows for each person when they scanned in first (min time)...
Read more ..read more
Excelguru Forums » VBA Programming
11M ago
Hi,
I am not very good at coding, trying to get the following code to work.
Intention is to mass send Outlook emails with PDF attachment (name =subject header) from excel list.
Example
Subject Header = 3127: Hundred Palms - To remove debris, $15000
PDF file to attach = 3127 Hundred Palms - To remove debris, $15000
I face problem when there is a new revision to the same quote - from Q23/3127 to Q23/3127a.
The PDF file cannot be recognised and be attached to Outlook.
I...
Read more ..read more
Excelguru Forums » VBA Programming
1y ago
(Excel 365 32-bit)
I have a macro that starts up automatically.
However it starts processing even before Excel is fully visible. In other words, it's running during the Excel Splash Screen.
Is there anything I can do to have the macro wait until Excel is completely started ..read more
Excelguru Forums » VBA Programming
1y ago
Based on a data validation selection, I have this code opening up a "Job Qualification" Workbook, grabbing the correct job qualification, copying it, then pasting it into my current "Open Workbook". Each location/Plant will have a variety of job qualifications and I don't want to build out 100 different modules for each plant or have to change when a qualification changes.
Is there a way to change the code from loading/running each individual module to go and open the Job Qualification...
Read more ..read more