Search:

Type: Posts; User: jonnyp138; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    143

    Re: Document Content to Body of Email

    I have found the following which seems to work but if it is ran more than once i.e in a loop until all escalations have been dealt with then the 2nd time round I get a runtime error saying the...
  2. Replies
    5
    Views
    143

    Re: Document Content to Body of Email

    The email is an escalation email and they just want the content of the word template inserting into the body of the email if that makes sense
  3. Replies
    5
    Views
    143

    Re: Document Content to Body of Email

    Edit - This would need to keep the Word formatting rather than just copy the text over
  4. Replies
    5
    Views
    143

    Document Content to Body of Email

    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...
  5. Re: SLA Breach Calculator different SLA Times

    Anyone able to help with this?
  6. SLA Breach Calculator different SLA Times

    Good afternoon,

    I have to find a way of working out if incidents have breached SLA which I am having trouble seeing as some priority incidents are 24*7*365 such as Priority1 and Priority 2 yet...
  7. Replies
    1
    Views
    228

    Excel Line Split

    Can anyone help with a vba script that will strip each server host and ip address from column B into a new line in a new sheet and apply the solution from column A next to each server in the new...
  8. Replies
    6
    Views
    296

    Re: VBA Consolidation

    This worked an absolute treat, thank you
  9. Replies
    6
    Views
    296

    Re: VBA Consolidation

    Thank you so much for the time and effort you have put in here I will try it out when back at work Monday and let you know
  10. Replies
    6
    Views
    296

    VBA Consolidation

    Hi there, just wondering if someone can assist, basically I have a spreadsheet containing approx 150,000 lines of event information along with each time a note was added to that particular event ID,...
  11. Replies
    0
    Views
    219

    Slow Datasource Connection

    Hi all, I have a weird issue that I just cannot put my finger on, basically I have an excel dashboard which when I run a macro it will connect to an Access DB and pull out requested data, the issue I...
  12. Replies
    1
    Views
    377

    Slow Datasource Connection

    Hi all, I have a weird issue that I just cannot put my finger on, basically I have an excel dashboard which when I run a macro it will connect to an Access DB and pull out requested data, the issue I...
  13. Replies
    4
    Views
    141

    Re: Excel Pull from Access

    Unfortunately the amount of data I am pulling is too much and I need to add a SQL query to only pull what I need however my SQL isn't up to much, can you tell me where I would modify the above code...
  14. Replies
    4
    Views
    141

    Re: Excel Pull from Access

    Thank you.
  15. Replies
    4
    Views
    141

    Excel Pull from Access

    Hi All - I currently have a vba macro setup to import data from MSACCESS into Excel using the following command which works great

    Set ShDest = Sheets("Excel Sheet Name")

    Set cnn = New...
  16. Replies
    0
    Views
    102

    Update Link Question

    Hi, not sure if this can be done but will ask anyway, so I have a workbook (master) in a cell there is a formula that literally points to a cell in a daily planning sheet (daily) which is in a folder...
  17. Replies
    5
    Views
    167

    Re: SQL Connection Question

    excel 2013 also
  18. Replies
    5
    Views
    167

    Re: SQL Connection Question

    Bear in mind this wasn't my sql, as I said I inherited it
  19. Replies
    5
    Views
    167

    Re: SQL Connection Question

    Sub SQL_Updater_Testing()
    Call Unhide_Extraction
    Sheets("Extraction").Select
    Range("A4").Select
    ActiveCell.FormulaR1C1 = "=TODAY()-5"
    '

    ActiveWorkbook.Connections("CCENTDBASP006...
  20. Replies
    5
    Views
    167

    SQL Connection Question

    Apologies if this is the wrong place to ask this but I have inherited a spreadsheet which pulls data from a SQL database and all works fine apart from when the query has been ran and the data is...
  21. Thread: Text Extract

    by jonnyp138
    Replies
    4
    Views
    223

    Re: Text Extract

    Perfect - Thank you very much!
  22. Thread: Text Extract

    by jonnyp138
    Replies
    4
    Views
    223

    Re: Text Extract

    Thanks that is a lot better than I was getting, only snag is when the ID is on the last line it comes up with an error?
  23. Thread: Text Extract

    by jonnyp138
    Replies
    4
    Views
    223

    Text Extract

    Hi there, I have a data dump in a table format, in one of the columns each cell contains numerous strings, the string can be of varying lengths and can contain different words each time, however...
  24. Thread: Vlookup Help

    by jonnyp138
    Replies
    5
    Views
    182

    Re: Vlookup Help

    You sir are a genius, so simple but I would have never thought of that, you just opened up a window of ideas for me, thank you!!
  25. Thread: Vlookup Help

    by jonnyp138
    Replies
    5
    Views
    182

    Re: Vlookup Help

    I want it to show up in AB(first free cell from row 13:46) as this is the due to start date so just by looking at this planner at the beginning of the week I can see any tasks that are due to start...
Results 1 to 25 of 50
Page 1 of 2 1 2