strname

Hi, The below code breakdown: creates a pdf of 2 tabs ('Total' & active sheet) creates a new folder names the new folder based on the cell B4 value and stores the pdf in the folder location where the excel was launched from. FYI, Cell B4 is a date value. What I would like it to do is, Read...

Afternoon, Hope the forum can help. I've had a macro running successfully for a number of months which finds the latest / newest file and imports the data into a workbook. This month it has stopped identifying the latest/newest file which includes the string "TRAN_SUMMARY-M-". I took the...

Hi I would like to Bold alternate words for eg Name : MR.EXCEL Country : USA Dim strName As String, strCountry As String, Dim mpStart As Long strName = "MR.EXCEL" strCountry = "USA" With Worksheets("sheet5").Cells(14, 1) .Font.Bold = False .value = "Name : "...

Hello everyone, I'm encounter an issue with Excel when using the formula below. I have a button with the VBA code on it and it works perfectly but if my list consists of more than 15 entries, Excel crashes when trying to auto-create the tabs after the 15th entry. Is there any way to modify the...

Hello. I have this code wich works fine for every sheet, I'd like to make it to save all sheets with one click only. I need all the sheets in the workbook to be saved separately with the sheet name and the year given in a cell like the code shows. It works like a charm but I have to go on page...

I am modifying a macro in Excel 2010 that copies data from one sheet and pastes it in a format that works with a pivot table. The data in the source worksheet is spread out over several rows. The macro pastes the data from numerous columns to single columns. The name of the source worksheet will...

Hello, So far I have this but I can not get it use the next line inside of a table. It always uses the next row after the end of the table. Any thoughts? strName = InputBox("What is the Estimate #") strName1 = InputBox("What is the Prospects Name?") strName2 = InputBox("What is the Prospects...

Hi I am trying to write a macro to save selected worksheets from the workbook to individual pdfs. but I only got the macro to work to print all the worksheets from the workbook including summary tab and notes tab. I only want to print the tabs that are employee statements. Each individual tab...

This code works great. It creates a new sheet every month. I just want it to stop adding once we get to 2019. Any Ideas? Sub AddMonthWkst() Dim ws As Worksheet Dim strName As String Dim bcheck As Boolean On Error Resume Next strName = Format(Date, "mmm_yyyy") bcheck =...

Hello, I am trying to create a spreadsheet for people who are not that familiar with excel, if at all. I am trying to create a macro that would give them a list of available selections in the filter to choose from and then action their selection. Anyone have any suggestions? THANKS in...

Hi All Can anyone help me please, as I have been trying to sort this out for ages, with no success. strName = ActiveCell.Value  strName = Left(strName, 10) ActiveCell.Offset(, -5).Formula = _ "=IFERROR(INDEX('[TEMP.xlsb]MASTER'!$A:$A,MATCH(TRIM(""*...

Hello, I am trying to create a Macro that will insert the answers to two questions. The trick is that I need the the first question to go into the next empty cell in Column B and the second answer to go in the cell right next to it in Column C. I have the first part down but I can't figure...

hi all... how to modify this code : i want spesicifik find in only cell AD, row 14 Sub SearchAllSheets() Dim ws As Worksheet Dim rFound As Range Dim strName As String On Error Resume Next strName = InputBox("What Name?") If strName = "" Then Exit Sub For Each ws...

Hi, I'm doing large mail merge with lots of pictures, and I used macropod advices (thanks macropod), but I have problem when I need to send created word document to someone. It has no images. I'm using Office 2016 (Win). Here are my VBA code and formula for placing images. Images, source excel...

Good afternoon. I have seen a few posts that half answer this question, but none quite go the whole way... I have found the code below which helpfully returns the username of the person executing it. What I would like to do now is filter the rows where the username matches the contents of...

Hi All, We have some old code that we use to basically create a mail merge from a data set as individual letters. I didn't write the code but i need to find away to password protect the each file with a specific password for example say Field1&Field2. Could anyone help with this? Sub...