Hyperlink To Specific Location In Word Doc?
I have an Excel file to distribute to users. This file must contain Hyperlinks to a Word file which i will enbed in a sheet of the Excel file itself. My question is this: Is it possible to produce Hyperlinks that go to the specific part of the Word document? So far, i am only able to Hyperlink to the first page of the Word doc, by doing a macro.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Spreadsheet That I Have Variable Data In And I Want To Transfer Specific Parts Of The Workbook Into A Word Doc
I have a spreadsheet that I have variable data in and I want to transfer specific parts of the workbook into a Word doc. Not a problem with the Excel part, I can select each and every cell that I want, copy them and then... Recording a macro hasn't done the trick as the code I have only copies and doesn't paste. I know I can edit the code to open Word but the problem is that when in Word, the data needs to go to very specific places, some of it goes in the header, most goes in the main body, I can't see how this could be done as there are no cell refs as in Excel! is it possible to paste to say halfway in a sentence, in a macro?
View Replies!
View Related
Generate A Word Doc
I have a macro here that is not working becuase User-Defined Type not Defined. I think i understand it but i want to make sure and if there is any advice for the macro below even better. what is in red below is what i think i need to identify as Type /end Type. these are named cells from my data page. Sub Makeworddoc() ' create a word doc Dim wordapp As Object Dim data As Range, message As String Dim Notes As Integer, i As Integer Dim Participant As sting, POC As String, phone As String, Email As String, Staff As String Dim Contact As String, When As String The rest of the macro is ' Collected information from worksheet Set data = Sheets("data").Range("A13:G13") Notes = Sheets("data").Range("notes") ' updated status bar Application.StatusBar = "Creating Word Doc." ' assign current data to variables.............
View Replies!
View Related
Insert MS Word Doc On Condition
I have a workbook with about 8 sheets that is used for pricing vehicles with options. On the first sheet is the list of about 40 vehicles. I would like to insert a command that IF the quantity of vehicle X = 1 (all others would be blank) then insert a MS Word document that contains the proposal. The MS Word document could be a worksheet if necessary.
View Replies!
View Related
Automatically Merge Data From Userform Into A Word Doc
I have created an Excel spreadsheet that collects info from a userform; we are using this as a issue log. However, at the same time, upon completion of the log, the engineer then needs to fill out the essentially the same information in a Word form for sending off to the customer. I was thinking that perhaps this could be done by using a mail merge but from past experience this generally isn't very user friendly or quick. Is it possible to automate this somehow using VBA such that when Enter is clicked on the form, not only does it fill in the next available line in the log spreadsheet but it also opens Word and populates the required fields with this same info?
View Replies!
View Related
Macro To Open Word Table Doc And Paste
I am trying to have Excel 2007 open a Word Table, Select All, then Copy and paste to the open workbook. Here is what I have so far: Sub Comments() Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True objWord.Documents.Open "R:JohnstonOfficeProductionSO COMMENTS.doc" Selection.WholeStory Selection.Copy Right now I and getting an "Type not defined" error and the Dim oData As New DataObject step. Also if delete the code to clear the clipboard, I get an error at the WholeStory step.
View Replies!
View Related
Change In Macro To Open Blank Word Doc
The following code opens Word correctly, but has too many tool bars open. I only want the tool bars to be opened, just like when you click on the Word Icon at the bottom of the screen. I do not want the following 3 tool bars to open . . . Drawing, Reviewing & Microsoft Office Live Add-In.
View Replies!
View Related
Create Hyperlink From 2 Cells, Then Open Word
The purpose of this endeavour is to create a cell that when the user clicks on it, it will open up a Word file that THAT particular cell represents. FIRST STEP: Take the values from Column D (Tract Number), then add a ".doc" extension to it, then put the UNC filepath (\serverdata eports) in front of all of that and put it in Column E. See me example below: File path plus Tract Number plus Extension \serverdata eports 7-5-065-085 .doc .... to generate something like this: \serverdata eports7-5-065-085.doc SECOND STEP: Use the value (only when the user clicks on the hyperlink) from the cell in Column E and start up Word.
View Replies!
View Related
Generate A Folder Within A Specific Location
I am trying to generate a folder within a specific location (For now lets call it C:Jobs) that will be named as per the adjacent cell (Column H on attached) Obviously if the folder already exists I want the code to stop. But this code will have to generate a different folder for each row within the spreadsheet.
View Replies!
View Related
Save To Specific Location As Cell Name
I've been searching for ages trying to work out how to do this but have so far only managed to confuse myself. i have office 2007 and I have found some code to convert an excel sheet to PDF, however I need it to saveas the contents of cell (e6) and save to a location on our network drives (C:TEMP).
View Replies!
View Related
Add Custom Menu At Specific Location On Toolbar
I would like to use the attached "menu maker" file I found on Ron De Bruin's site using a Sheet to build the menu, yet be able to place it before the Help menu as suggested by this site [url] by finding the position of Help. I have amended the code yet receive a "Compile error: Variable not defined" error.
View Replies!
View Related
Extract Data From A Specific Location In A Text File
I have been trying to work this out by looking at other posts (mostly concerning Binary Access) but can't figure it! The source text files I am using can vary in length from 4,000 characters to well over 100,000 characters. However the data I am looking for always starts 40 characters from the end of the file and is 10 characters long! I need my macro to pick out this data and store it as a string (so it can be added to an array and exported to a worksheet later)
View Replies!
View Related
Insert Row At Specific Location And Auto Fill Formulas From Above
What I need is to insert a row at row 59 and autofill the formulas including drop down list from the above row. This is what I have so far (Thanks to Reafidy and shg). Sub ChkDates() Dim c As Range Dim DelRng As Range Dim ArcRng As Range Dim i As Long Dim l As Integer Application. ScreenUpdating = False Worksheets("Report").Activate For i = 60 To 8 Step -1 Set c = Cells(i, 33) If IsDate(c) Then ..............
View Replies!
View Related
Hyperlink To Specific Data In Another Worksheet
I would like to link from worksheet A to worksheet B using the following scenario: Worksheet A has the following cells, each of which is linked: a b c d Worksheet B has the following cells which worksheet A is trying to link to: a b c d The problem arises when I sort or add rows to worksheet B: b a d c I want "a" in worksheet A to always find "a" in worksheet B, no matter where it is. The columns will not change but it will move to different rows.
View Replies!
View Related
Delete Specific Word From String
I want to delete a specific words from string but i have a problem with the code below. For example, i wan to delete the word "Inc" only but the problem with my code is that it is deleting from "Incorporated" too and i want only the code to delete only if it finds the word "Inc" only.
View Replies!
View Related
Search For A Word In Specific Columns
I am trying to create the ability to search for a word in specific columns. In my case below I want to search D5:E500 but it's not working. It searches the whole ppage. Private Sub searchfind_Click() Dim searches As String searches = searchfirstname & searchlastname If WorksheetFunction.CountIf(Range("D5:E500"), searches) = 0 Then Exit Sub End If Cells.Find(What:=searches, After:=ActiveCell, SearchOrder:=xlByRows, SearchDirection:=xlDown, _ MatchCase:=False, SearchFormat:=False).Activate End Sub
View Replies!
View Related
Get Cell To Display A Specific Word
I am using the formula below to calculate the number of days left to do something, when there are no days left I want the cell to display "Begun" in red italic text. Is it possible to do that via this formula or is a macro needed? =IF(ISBLANK(E2),"",IF((E2-I2)<0,"",E2-I2-10&(" Days")))
View Replies!
View Related
Extract All Occurences Of Specific Word
Cell in excel containing large amount of text. Contains the following text one or more times (including the speech marks): "Provide Dwd/Dwl Number: DWD*****" What I need to do is extract all of the DWD values from this cell, load into an array and dump them into another cell. It's the extraction bit that I need to sort out. In my mind the way that the code should work is: Find all instances of 'dwd' For each instance of 'dwd' check the next/proceding character. if the character is a space, check the next one if the character is not a number or space, break and go to the next instance of 'dwd' if the character is a number add it and the next 5 characters to a temp variable (varTemp) loop take the value of varTemp, prepend it with 'dwd' and add it to the running list/array Loop Output the full list of DWDs
View Replies!
View Related
Delete Rows :: Where Specific Word Appears
I have a spreadsheet that I need VBA Code to do the following 1) Delete all rows where the word totals appears in Column B for eg "Totals for Vehicles Stocked in 0706" "Totals for Vehicles Stocked in 0707" etc 2) Delete all rows where the value in col m is less than 45 I have written the code, but cannot get it to work-see my code below Sub Del_TOTALS_Underaged() FinalRow = Cells(65536, 2).End(xlUp).Row For i = FinalRow To 1 Step -1 If Cells(i, 2).Value >= "Totals" Then Cells(i, 1).EntireRow.Delete If Cells(i, 13).Value < "45" Then Cells(i, 1).EntireRow.Delete End If End If Next i End Sub
View Replies!
View Related
Calculate If Specific Word Found In Column
I would like to use the following code to see if the word "reservoir" shows up in any of the rows in a certain column. If it does I want to insert the formula = SUM(D7:D257)*0.1 into cell C2 and if it doesn't then I want to put a 0 into cell C2. I've tried many routes but can't get past the error if it can't find the word. Range("B7:B257").Find(What:="Reservoir").Activate
View Replies!
View Related
Determine If Specific Word Exists In Range
I am attempting an If Or formula and keep retuning a #Value error, I can't for the life of me figure out why. This is the formula that I have written. =IF(OR(H44,H45,H46,H47,H48)="Other:","True","False") Cells H44,I44,J44 have been merged into one cell (H44), and the same for 45,46,47,and 48 - Could this affect the Formula?
View Replies!
View Related
Delete Range Names Containing Specific Word
the active sheet contains a number of defined named ranges. i would like to delete range names beginning with "Sales", yet the number of defined ranges changed from sheet to sheet = for example, Sheet1 may have 3 defined ranges (Sales1, Sales2, Sales 3), Sheet 2 may have 1 (Sales 1). Is it possible to included a wildcard search in the following code? Sub DeleteRangeNames() Dim RangeName As Name For Each RangeName In Names ActiveSheet.Names(RangeName.Name).Delete Next RangeName End Sub
View Replies!
View Related
Macro To Find A Specific Word And Insert Cell
I have a large spreadsheet with about 18000 rows or data and about 60 columns. I need to a macro to find a specific word in a column like "charge" and anytime that word is found in the column to insert a blank cell in front of it. Currently the sheet looks like this:Fee AChargeFeeChargeFee AChargeFeeChargeFee AChargeFee AChargeNeed to get it to look like this: (so I can sort and subtotal)Fee AChargeFee AChargeFee AChargeFee ACharge a macro to the for whichever column I choose.
View Replies!
View Related
Pull The Entire Row If It Finds The Specific Word
The following sub will look in the file ("FY09 SOF"), in column "A", search for the strings that begin with "2109", "3009", or ends in "-1", and copy the entire row. It will then paste these in the file ("FY09 PR Log Blank"). I also need it to look in column "C" in the ("FY09 SOF") file and pull the entire row if it finds the word "Payroll". For some reason it will pull everything needed except the "Payroll" rows. What am I doing wrong? Sub get_data() Dim wb As Workbook, wbDest As Workbook Dim ws As Worksheet, wsDest As Worksheet Dim lngCalc As Long Dim FoundCells As Range Dim FoundCell As Range Set wb = Workbooks("FY09 SOF") Set wbDest = Workbooks("FY09 PR Log Blank") Set wsDest = wbDest.Worksheets("Paste all here, then sort") With Application .ScreenUpdating = False..........................
View Replies!
View Related
Formula To Calculate How Many Cells Show A Specific Word
How can I create a formula to add up how many cells in a column show a particular set of text? For instance; the column in my spreadsheet looks something like this: MJR DML MJR RJG RJG MJR DML I want to know how I can create a formula that will automatically tell me how many times "MJR" is listed; how many times "DML" is listed, and so on.
View Replies!
View Related
Data Validation :: Cells Should Contain Specific Word On Input
I'm trying to make the included spreadsheet as idiot proof as possible as a lot is a stake. I have most functionality working well; however, not I would like to add a little more data validation that does not exist in the normal cell validation rule set. I need all the input cells to validate that the cell contains the word "BOX" upon entry, otherwise throw a warning. This is because the data entry will be done by barcode and there are a couple barcode labels on each box. The one I want will include the word "BOX" somewhere in the code sequence. Since a previous function in the Code locks the cell, they wont be able to fix the error. but it will alert them so they can make sure to scan in the proper barcode and not miss the box. Also, once I get something that works in the code, where would I put it? In the same code box as the previous script, underneath it, or somewhere else? So, bottom line, I need a script that check the cell for Text of "Box" otherwise throw a message box.
View Replies!
View Related
Color Row If Cell In Column Contains Specific Word
I've been trying to come up with a conditional that will format a row if a cell contains any instance of a given word. I know the following will format rows containing the EXACT entry of "apple" in column E: =$E1="apple" But I'd like a conditional that will find entries like "apple pie" and "crabapple" as well. I'm sure it's a simple solution, using a SEARCH function or something...but I can't figure it out.
View Replies!
View Related
Color Row Where Cells In Column Contains Specific Word
I have a spreadsheet with 12 coloums. In the last coloum are the ords "yes", "no", or is empty (null?). I need to find a way to have each row that contains the word "no" or is empty to be highlighted in red font and bold type. When the word "yes" is typed then the font is black and the type in normal. This allows me to see at a glance what orders have not been picked up or have problems.
View Replies!
View Related
Color Entire Row If Cell In Columns Contains Specific Word
how to format a row based on text that is in a certain column. For instance, if a cell in column B has text in it I need to format the entire rest of the row with a certain background color and text color. I've been searching around here for a while and I think I'm really close, but I just can't seem to nail it down. Here's the code that I've worked on so far. Sub Reformat() Dim SrchRng3 Dim c3 As Range Set SrchRng3 = ActiveSheet.Range("B1", ActiveSheet.Range("B65536").End(xlUp)) Set c3 = SrchRng3.Find("Europe - *", LookIn:=xlValues) Do
View Replies!
View Related
Interpolation Given A Variable Table Location & Location Of Data Within
I am trying to develop a spreadsheet that will calculate a cost based on a matrix. I am attaching a sample of the calculation created so far. The end result is in cell M13 and is highlighted in yellow. I kind of layed the formula out in a few different cells, so hopefully it would be easy to follow. simplify this process with maybe another formula that I might not be aware of, or maybe show me how to get this done in VB code. I think VB code would be the correct way to go just not sure.
View Replies!
View Related
Opening Word & Count Word Instances In A Word Document
I have an excel program that is supposed to count word instances in a word document. I can't seem to find the right declaration for a word document. For example to declare a workbook in excel its Dim wb As Work Book I've tried Dim doc As Word.Document 'or Dim doc As Word.Application as shown in some of the forum posts, but an error user-type not defined keeps displaying.
View Replies!
View Related
Search Arrays For Specific Values And Copy "associated" Values To A New Location
Given the following data located in Sheet1 of a Workbook - •I have seven columns (assume header row names are “A, B, C, D, E, F, G”) each containing numeric data in random order. •All columns are of the same length (equal number of rows), followed by a blank cell, but the number of rows is unknown. •Columns with header row names A-E will only contain numbers from 0 to 100, while F and G may contain numbers from -127 to +128. Here is what I would like to do – I would like to be able to analyze the data in columns A-D to locate rows that contain specific combinations of values (ex. row 41 contains the values 50, 0, 0, 0 and row 239 contains values 100, 0, 0, 0 in columns A – D, respectively, etc.). For each row that is found to contain one of these combinations (there are many different combinations required), I would like to copy the associated values from columns E, F, & G for that row, and paste them into their respective (E, F, & G) columns located on Sheet2 of the same workbook. However, I would like to paste the E, F, & G values into a specific row order on Sheet2, DETERMINED by the value of the A – D combination identified on Sheet1. Continuing with the ex. above, let’s say I would like to have the EFG values from row 239 in Sheet1 copied to row 10 in Sheet2, while the EFG values from row 41, Sheet1, are to be copied to row 11 in Sheet2. In effect, I would like to create a table of this subset of data, in a specific order, from which I could work later. I can do this manually using “ AutoFilter” to locate the data I need and then write formulas to copy the data from Sheet1 to Sheet2 in the order that I need, but every time the order of the original data on Sheet1 changes I have to start all over.
View Replies!
View Related
.txt Doc
I have a text document that list around 200,000 email addresses that have visited my website over the past 8 years. I am trying to convert those to an excel document, however when I do a simple cut and paste it fills in the information on line 1 across. I need the information to have 1 line per email address. Is there a simple converstion that I'm missing, obviously I don't want to cut and paste 200,000 individual email addresses.
View Replies!
View Related
Copy To Another Excel Doc
I could use to copy a sheet in a workbook (ideally a block of cells) and save this to an excel doc. in to a specific folder? Is there a way of re-naming the file by using the contents of a cell that is from the documeny that it is saving. eg save excel sheet x - use cell a1 on sheet x as the save as name e.g 00001
View Replies!
View Related
Protection For Limited Field In Doc
I need to attach some of my docs (either excel sheet or word sheet) to my client via email. Supposedly the excel or word sheet is to be fillled by them (certain field) but at the same time i need to protect amendment on some fields. for Example. user can fill wording within the underline colume but they cannot change my "Diagnosis" word to something else.
View Replies!
View Related
|
TRACKER
