Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: davefish
  • Content: Threads
  • Order by date
  1. davefish

    Looping through a word doc to delete rows

    I have a word table that is populated by Excel VBA as shown below:- wordDoc.Tables(4).Cell(2, 1).Range.Text = " " & Range("O19").Value & " Way Flush Mounting, Programmable Alarm Annunciator." 'Product code wordDoc.Tables(4).Cell(5, 1).Range.Text = Range("O25").Value 'Window size...
  2. davefish

    Excel Sheet view zooms in slightly when running code

    Hi, I have a workbook that builds a graphic based on cell values. Each graphic is a .png in the same folder as the Excel file and this works okay. However, when the code is first initiated, the sheets view zooms in about 5% then resets and I can't find out why? I'm am using Excel O365 on...
  3. davefish

    Late binding

    I have a few Excel programs running in Excel 2010, but will not run in Office 365 Excel 16 due to reference library issues. Can I just change the highlighted code below? Heklprequired please Sub ExportQuoteToWord725() 'Opens document template and fills out fields to create a quotation...
  4. davefish

    searching for text in a word table from Excel

    I have an Excel SS that allows the user to make selections for a configurable product and once done produce a quote. I can successfully gather the data and launch a word template that works, but now I am asked to add or delete specific rows dependent on the selection. This means identifying text...
  5. davefish

    Dynamic part number creation...Should I use Select case, if statement or combination

    I have a part number string that needs to be dynamic enough to handle null values for certain components. This takes the form UC625-16-[highlight #FCE94F]4UN[/highlight]-GN-HH-R-048-M3-T where if 4UN is a null value it's removed from the string. Similarly M3 & T can be removed in the same...
  6. davefish

    Finding a datakey and copying data from that row to another sheet

    I have data that is extracted from a source using a query. This data has a datakey at column "J" and if it's populated by the character "H" then columns "A", "C" and "E" of that row, are copied to a row in another sheet. I have two issues that hopefully someone can help with:- a) I can loop...
  7. davefish

    change background of a range of cells based on value

    I have a number of cells in a row range that I wish to change background colour if anything it typed into any cell in the range. if a number of text is type into Range A11:H11 I would like the background to change from red to None. I have tried to record a formulae but cannot get this to work...
  8. davefish

    CHR(10) line feed spacing

    Using ALT-Enter in a cell I wish to reduce the line feed spacing but cannot find this via formatting. Is there anyway to apply an Alt-Enter with a variable line space via VBA?
  9. davefish

    Test if worksheet is present

    I have two worksheets that are created during calculations that need to be deleted after processing by Macro. Deletion need to be carried out when a Form control button is activated, but when the sheets are not present, as they are in some instances I get errors. The code I am using is :-...
  10. davefish

    Paste without selecting cell

    I am trying to paste a set of value to a sheet without it taking focus. The issue is .Range("A1").Select but if I remove this I cannot paste correctly. Can anyone advide the best way to work around this? Sub Copy_CTO() ' ' Copy_CTO Macro Application.EnableCancelKey = xlDisabled...
  11. davefish

    Delete cels with selection

    Hi, I ma trying to delete a bunch of cells on a hidden worksheet, but the only code I can get to work has a .select suffix that causes the worksheets to be viewed. Is ther anyway I can get around this using the code or similar below:- Sub Clear_BOM() ' ' Clear_BOM Macro...
  12. davefish

    Trigger code when a Cell is entered with a specific Value

    I have read thread707-938434 and this is very good at triggering a piece of code when exitiing a cell. However, what I'm trying to do is trigger code on entering a specific value in a field from list. The code within the trigger would only be as shown below If [C10].Value = "Guest" Then...
  13. davefish

    select a range using relative references

    Not using VBA for some time I cannot remember how to select a range of cells using relative references. I have used :- ActiveCell.Offset(1, 2).Range("A1:B8").Select but wish to replace ("A1:B8") with a script similar to the offset value as my cell referecne will change file by file. Can...
  14. davefish

    pulling values from a xlsheethidden sheet

    I wish to pull some data from an excel sheet that's hidden using the following code. The problem I have is that the sheet is displayed for a short period of time, and that's something I need to rectify. Can anyone help with this? Public Sub costit() Sheet3.Visible = xlSheetVisible With...
  15. davefish

    Collecting data from outlook folders

    Hi, I'm trying to analayse the number of read emails in sub-folders of the "IN" box and like-wise the "Sent" Folder including their respective dates, in order to trend number of mails sent and recieved. unfortunately, I have no clue in Outlook VBA on where to start with recpect to the correct...
  16. davefish

    Access report or Query?

    Hi, I'm new to access and what's it's capable of, but I wonder if anyone can help. In Excel I'm running a formula to ascertain the working days between two dates, eg, excluding weekends. I pull the data from access then use the =NETWORKINGDAYS function to get here. It would be a lot simpler if...
  17. davefish

    Excel to word bookmark problem

    I have some code that I wrote in Excel 2000 that opens a word document and places data from a specifc cell to a bookmark in word. I need to use that code but with office 2003 and I can't get it to work. It fails when trying to Goto the bookmark no matter what I try. I recorded a macro in word...
  18. davefish

    Copying data to cell in different tables

    I have a document with links to a database and wish to break these links when the document is closed. I do this using the following code:_ Private Sub Document_Close() If ActiveDocument.Name <> "Test.doc" Then ActiveDocument.Fields.Unlink End Sub However, I wish to preserve one link, namely...
  19. davefish

    Macro/Mouse problems

    One good starting point for code is the Marco recorder, unfortunately I can't seem to get mine to record mouse movements and clicks. Is is just me, or is anybody else having this problem? If so, can any of you Guru's out there suggest a fix? DaveFish
  20. davefish

    Comparing a value in word table

    I have a table in word with many cells, some of which are related by catagory. I need to identify the text in one of those cells, and depenadant upon the entry, change the second. Although I can write to a given cell using:- With ActiveDocument.Tables(1) .Cell(1, 1).Select...

Part and Inventory Search

Back
Top