word

I'm using the code below which works great provided the word "Remove" is somewhere on the sheet in column F. However, when the code runs on a worksheet where the word "Remove" is not present it removes the first row of the worksheet which is the column headings and also removes my alternate row...

When I run spreadsheets I create tables and charts in them. I format them as desired, then cut/paste them into a Word document. But I have found that the Word document and Excel file are "linked," which I don't want. The last time I copied the Word doc onto a usb driver to work at from home...

Hello, I'm setting up a macro for a button on a worksheet, worksheet 1 in workbook X. What I would like when this button is clicked, is to check all cells in column A for the word "Copy" Next step is that if this word is found, another workbook, Y, is opend. Finally if the word "Copy" was...

Hello, I am using the code below in Excel to open a PDF File in Word andextract the data as text only into Excel. The code works perfectly fine as itis, however, I want to loop through all pdf files within the folder instead ofhardcoding the filename in pathAndFileName variable. My goal is...

Hi I inserted a picture in a sheet. I moved the picture over a table. After that I can not see the contents of some cells. Can I put the picture in the background and move the text in front, like in Word? Thank you very much

Does anyone have a suggestion on how I could create a situation where clicking on a particular word in a cell initiates a Find for that word? I have a list of customers and it would be helpful to be able to click on a particular customer and then see all the other locations in my workbook that...

Hi, I am not sure if this is possible, but I have a macro that is building onboarding schedules in Word and filling in details based on an excel spreadsheet. The current problem I am having is that the locations of the meetings do change every couple of weeks. These locations are in Outlook...

Hello, I have a column that has different words. I need to find out how many of each word is in that column. For example, there might be 50 of the word banana, 7 of the word apple, 23 of the word orange, etc. What is an easy way to figure this or formula to use, I have over 150 cells to check. I...

Hi all, I have created the below loop and find and replaces instances in word. I have created an excel spread sheet and some of the data that's being replaced is currently formatted as currency in excel. The find and replace feature works perfectly and replaces everything correctly. The only...

Hello there, I hope this finds you all well. I'm back again, and I was hoping for some advice. As part of my work, I produce reports in Microsoft Word. Maybe about 30 pages long, largely the same text information, with an amount of financial information pulled across from a default...

Hi, I have the following formula which almost does what I want it to. =SUMPRODUCT(COUNTIF(B8:DG22,B8:DG22)-1)>0 However, in the range B8:DG22, which is made up of 5-digit numbers and the word "Blank", I want it to tell me if there's any duplicate entries in the range but ignore the word...

Hello, Is there a VBA code that can select a workbook and run different macros on condition? For example: If sheet 1, cell: A15 says the word "Blue" Go to Sheet 3 run macro for blue Or If sheet 1, cell 15 says the word "Red" Go to Sheet 2 run macro for red Or if Sheet 1, cell A15 says...

This is probably an easy one but, I have two excel 2003 worksheets in a single Microsoft Word doc.. Is there a way I can link them? Or at least a sum on one page to another? What I have is a long spreadsheet that I wish I could fit on one sheet but it is way to long. I had to put the information...

Hello, I have a range of cells (J7:J38) that the user will type text into. I'd like to know the best way to count the cells that share the same input. For instance, let's say that the user types in "dog" in 17 cells, the word "cat" in 7 cells, the word "squirrel" in 10 cells, and "hippo" in the...

'******* EmpFolder is a Global Variable containing Folder Path ************************* Sub BatchConvertDocxToPDF() Dim objDoc1 As Document Dim strFile As String, strFolder As String 'Initialization strFolder = EmpFolder & "" strFile = Dir(strFolder & "*.docx", vbNormal)...

I use the following formula in column M to find duplicate values in column L =COUNTIF(L:L, L2)>1 The formula works correctly with returning values of TRUE or FALSE I would like to add an exception to this formula. I would like a value of FALSE to be returned when the word "offline" is found...

I generate a Word Document populating the bookmarks within it from excel and then tried exporting to PDF. Constantly getting error even after adding Microsoft Word Library 16.0. What am I doing wrong here? The code points to wdExportFormatPDF as Variable not Defined. <code style="margin: 0px...

Hi Folks I need small macros removeing Last 5 character of the Word In Exp: AT_1833 I need AT only. Removring _1833

Hello everyone, this is the code I am using to open a word document using excel vba: Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True objWord.Documents.Open "C:\Users\dmargraf\Documents\Makro Aufgabe\Testdoc Word.docx" I need to open...

I am looking for a way to see if the workbook name contains the word "Template". If so, I want the macro to prompt the user to save the file. I have the code listed below, but it does not seem to give the correct response. How do I get this to work? If ThisWorkbook.Name = "*Template*" Then...