document

I am pulling down some data and then delimiting it into different columns. Everything looks fine and I then save the document, however, when I re-open the excel document the data appears scrambled....data is not in the correct column and I am not sure why this is happening. Has anyone else...

Hi all, I already have a word document with mail merge linked to the excel spreadsheet. Now I created a button in this spreadsheet and I want to be able to click and open the word document. I have tried several times, but it will only open the word document with no mail merge. I tried all the...

Hi, I have an excel which is the source document containing the following data. Column A - Process Name Column B - Date Column C-G - data I want the code to read the Process Name in column A (source) and open respective excel document (destination) read the date in Column B (source) and go...

I have been trying to figure out why Chase transactions do not down load properly into Excel. After a couple of hours I downloaded the document into word with using past with document formatting and it showed me that Chase places a question mark in front of the number if the number is negative...

I work regularly on a particular type of Excel document that requires me to insert images so that my colleagues can understand what I'm referring to (related to mechanical design and a picture speaks a 1000 words as they say). In order to keep the document neat and tidy, I insert comments and...

I'm try to save a mail merge document on word into individual files. I have been using the VBA code below, it works to save the individual files., But it changes the font and doesn't copy over the format of the document correctly i.e tables header and footers etc - could some please help with...

Let's say I have an Excel spreadsheet with 3 columns (Name, Wife, date of death). Let's say I want to create a Word document that takes those three columns worth of date and prints it to the document like this: John Doe married Jane Jones and he died 1 Apr 2014. Sometimes, however, the person...

Good morning, Hoping all you wonderful folks out there can help me, I am trying to find a vba script to open a word document and copy the contents and create a new email message and use the document contents as the email body, is this possible using vba? Thanks

I have a large number of RTF documents that I am opening using Access. I would like to reformat the document and then copy them into a control. I am able to open the documents, and go though all the paragraphs in the document (using the paragraphs object). I found that my macro's are missing...

I'm having a hell of time with this -- I'm sure it's something simlple I'm missing -- but from an Access application, I'm trying to combine up to 4 word docs into one word doc, and then convert it into a pdf. I thought I would simply copy and paste each word doc one by one into a new doc...

I hope someone can help. I may get tongue-tied if I attempt to describe this issue so hopefully the scenario below will help illustrate my challenge. Worksheet 1 Cell A Folder Location Name 1 Folder Location Name 2 Folder Location Name 3 Etc... - Multiple records below which also contain...

Hello I want to implement an online calculator from a webside into an excel document. https://icmphilly.com/ortho-applications/prosthetic-joint-infection-pji-risk-calculator/ I want to be able to set those parameters in the excel document and get the points and the risk from the calculator...

Hi. Looking for VBA code to save the print area to a new excel document and to be prompted for the file path. I have PDF sorted but can’t seem to get to export to excel document. Thanks. Private Sub CommandButton8_Click() Dim sPath As String Dim sFile As Variant Dim ws As Workbook On Error...

I am not sure if this is the correct place. I have an excel document that has 35 rows. I need to import it into a word document but I need to limit it to a specific amount of lines per page. I also need it to link so that when I update the excel document it will update into the word document.

Hello, I am a beginner with macros and am having trouble. I have created a macro that creates a new sequential Invoice number upon opening a protected document. My issue is that several people in the company will be using this same document. How can I make sure that If several people have the...

Hey, First post here and I can usually find the help I need after some googling. Today I have failed since I could only partly find what I was looking for. First I tried power query and failed but then I ended up at VBA which most likely will fix the problem for me, but I just don't have the...

I tried following a previous post but the instructions did not work. I have a workbook with 3 worksheets. Worksheet #1 has a list of Document #'s to choose from when logging in a new document. At present, we are cutting and pasting the next Document # in sequence into 1 of the 3 worksheets to...

I understand this is an Excel forum, but I just came across something related to what I'm trying to do in Word through Google on this forum, and I'm hoping people continue to be extremely helpful here. This forum has been a life force for me in completing projects. I am trying to craft a VBA...

Hi All, Could someone please assist with the below query as I couldn't figure out the way to do it. I have two columns(A&B) with document numbers (same numbers exist in column A due to multiple versions- draft, version 1, final etc) and Titles. Some document numbers have same titles, which...

All, If I even change a name of a query or something in the last step, the query refreshes all previous queries and it's very slow. Is there a way to stop this behavior that doesn't result in me just completely forgetting to refresh older ones? It's 3-4 minutes I have a few joins which make...