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!

Recent content by johnbailey

  1. johnbailey

    VB for formatting excel graph colours

    PHV, Hi, trying to use an IF statement but haven't done one altering graphs before, I think the structure is wrong. Do you think an IF ELSE would be easier? Thanks John Range("L284").Select ActiveCell.FormulaR1C1 = "=IF(RC[-1]=TRUE,&quot...
  2. johnbailey

    VB for formatting excel graph colours

    Hi, I'm having a problem creating the VB code which formats the colours in a graph depending on the outcome of another cell. Or to be able to format the graph to begin with to react to values on a conditional format basis. Would appreciate the help. Thanks john
  3. johnbailey

    Excel linking problems between different servers

    Topjack Thanks When I open the two spreadsheets that are linked via the \\ATL05 the link does not shorten itself within the cell as per usual when a linked file is open. It also does not automatically update. Have you had this problem on your servers? Is it a glitch within excel? Thanks John
  4. johnbailey

    Excel linking problems between different servers

    I am having a problem with links between different excel files on different servers. The links revert back to the pathname of the server when I open the spreadsheet. The linking of updated date is then inconsistent. e.g K:\excel.xls becomes \\atl05\finance\excel.xls Has anyone seen this...
  5. johnbailey

    Copy Paste Files Non MS using a Macro

    Loomah, Brilliant thanks, it worked perfectly. Cheers John
  6. johnbailey

    Copy Paste Files Non MS using a Macro

    I am trying to use a macro to copy a .pdf file and then paste it to another directory. Is it possbile with the usual VBA? Thanks John
  7. johnbailey

    substitute cell contents into formula

    Thanks Hasit, The formula used =INDIRECT("'C:\["&filenameA&".xls]"&"sheet1'!a1") I am having problems with the linking, They do not seem to be permanent links and when filenameA.xls is closed, the return cell changes to "#Ref!". Is this because the...
  8. johnbailey

    substitute cell contents into formula

    Hi, Is it possible to use this code for linking between files? i.e use cell "A1" as a variable for a filename? e.g A1 = "file1" C:\documents\file1.xls hope this makes sense. Thanks
See more

Part and Inventory Search

Back
Top