Hello,
I have a feeling the answer may be no, but I'm looking to create a table - linked between Excel and Word - where part of the table is Excel data -> Word, and the other part is Word -> Excel.
I would like my staff to enter comments against each student, but have been told by many that...
I am writing a macro( late binding) that runs through a word document and highlight all the values that is contained in my cell range in Excel. I have used the find function which works fine until I add the argument IgnoreSpace:= True, which I don't understand why it's resulting in error...
If I am thinking about this in the wrong way do not hesitate to say. I am new to VBA but I am not new to programming. I want to be able to automate the creation of Word documents. That is when the document does not exist already. If the document exists, I would like just to open it.
Where I am...
I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2"...
Hi Excel Experts,
I'm coming to you with a question, I'm helping out my friend with digitalizing their tools for their business, starting with a customer list, so they can use the details later for mailings, (now everything is on paper and in the word templates, so they don't have a nice...
Hi,
I have a data set of descriptions and I need to find words in descriptions combined with numbers and letters. As an example cell A2 includes a sentence "Repair A4040D" so cell B2 should include information "A4040D". The equipment number is combination of letters and numbers max of 6...
Followed below instructions for the below code, only for step 7 there were no "Microsoft Outlook Object Library", so used "Microsoft Outlook 16.0 Object Library "
But nothing happens when code runs, at all, not even an error.
Using below code as a next best thing to figuring out how to...
Hi guys, how are you? I need your help because I want ran from boring and hard job to work with PDF and I want to convert the table from PDF to Excel.
I read different forums and watch different videos on youtube but cant find the solution.
I found only good advice to convert PDF to Word...
Hi all - I am very new to using Macros with Excel and I am looking for help. I am using code to attempt to automatically generate a word doc with upcoming deadlines/due dates in my Excel sheet. Currently, it will only generate a word doc if I manually run the code. Also, I am having trouble...
Hello All :)
Currently I have vba code:
'Some code above
If OfertomatMain.cmbUnderwriter1.Value <> "" Then
For b = 2 To 20 Step 1
If OfertomatMain.cmbUnderwriter1.Value = wudoc.Cells(b, 1).Value Then
Let underwriterstanowisko1 = wudoc.Cells(b, 2).Text
Let...
Hello,
When I copy from a Excel sheet data into Word it rounds the numbers behind the . I think all this is because of all the different cell formats all the columns have. Is there a way to copy and paste the data with all the numbers behind the . like 12.03767 ? After copying in Word this is...
Hello,
I have somewhat of an advanced question... I have a long list of names in a column in excel (range name, "Names"), what I want to do is create a code that I can run that will open a template (named "CART") and based on the list of names the code would open a copy of the template and...
Hi all,
I've got a document I'm using as a template with several sections.
Page 1 is a title page with the:
Document Title
Published Date
Updated Date
Those three items are all bookmarks.
Those three items are also included in the header of each page.
When I'm ready to finalise the file...
Hi All,
I know this is not necessarily Excel-related, however, it is going to be VBA related.
I have created a return-to-work form in word, which is sent to managers to complete return-to-work interviews for sick employees.
The document is restricted and only form fields can be completed...
I'm experiencing an issue with exporting the contents of a Word document to PDF. After pasting a table from Outlook into Excel, certain parts of the table are retained, then the new table is pasted into Word. The Word document is saved using a specific filename, the date, and a number to...
Hello MrExcel,
I have a macro that essentially exports text in 3 columns into a word document before converting to a PDF. I have had to do this as the text in 1 of the columns is well over 300 characters and can't be done in excel.
Unfortunately when i run the macro it takes about 13 minutes...
I have a pre-built Word form document that I use that has multiple fields that I fill out (customer name, dates, etc.). I usually copy/paste information to this document from other sources (Excel, Word docs, etc.).
QUESTION: I need to create a way to automate moving the required data from...
Hi, I have a file that contains two columns: A - file path and B - Title. To select a file, I double click in column A (let's say, A14), which opens an Explorer window. I make my selection and the path of the selected file is inserted in the double clicked cell. Now, to get the title of said...
I have pieced together some code using excel as a file picker to add images to embed within subject body.
Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting
Outlook seems not to have a huge support...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.