Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Search For:

Type: Posts; User: Epidemic

Page 1 of 3 1 2 3

Search For: Search took 0.02 seconds.

  1. Re: Importing a CSV file with dates in European format

    Actually the file is supposed to be is a csv, however, I forgot I was having a problem with that and did change the CSV files extension to Txt for the above code to work.

    The problem with .CSV...
  2. Re: Importing a CSV file with dates in European format

    I think I found a solution but I don't understand it

    the sub called open text sub was recorded using text import where I told it to import the file with the third field in day month year format. ...
  3. Re: Importing a CSV file with dates in European format

    No I have not. How does that work. wouldn't I need to specify a region/local I am not sure what I am saying true to there.

    I would need it to read the file as if it was Europe and then via...
  4. Re: Importing a CSV file with dates in European format

    I thought this would be an easy one for someone. Perhaps I did not explain my problem.

    I have a macro that opens up a CSV file form another software package. This CSV file is used to generate...
  5. Importing a CSV file with dates in European format

    I am trying to open a CSV file and the dates are in European format. This causes my macro to have all sorts of problems.



    starttime
    30/06/2015
    1/7/2015
    2/7/2015
    3/7/2015
    4/7/2015
  6. Replies
    3
    Views
    224

    Re: Open file error

    So the On Error Goto is not capable of handling this? I need to know so that I don't fall down this path again.
  7. Replies
    3
    Views
    224

    Open file error

    For x = 1 to 10
    On Error GoTo Skip_Missing_Data_type
    Set WB = Workbooks.Open(RawWBPth(x)) ' Opens file from calculated location Raw Path
    ' bunch of code
    ' bunch of code...
  8. Replies
    1
    Views
    239

    Subscript error

    Public RawWBName As String ' Name of active raw report.
    Public KPIReptName As String ' Kpi report name is the name of this workbook.
    Public RawWBPth(1 To 5) As String ' Path and...
  9. Re: Code jumps out for some reason to previous Subroutine.

    oops,

    I tried your code it still is a not able to run unless I have the sheet active.



    With Sheets("magicindex")
    FirstRow = .Row
    LastRow = .Range("A" & .Rows.Count).End(xlUp).Row...
  10. Re: Code jumps out for some reason to previous Subroutine.

    Thank you. I am still not sure why the first method did not work but this one does work. I make some work arounds where I activated the sheets and jump around. I will go back to try and...
  11. Re: Code jumps out for some reason to previous Subroutine.

    Ok this works sorta, I am not sure why but it appears that the sheet has to be active to function. I thought the with sheets statements should take care of that. I get a 1004 error until I make...
  12. Code jumps out for some reason to previous Subroutine.

    I have been trying to figure out why my macro jumps to the former subroutine when I perform this line of code.

    Sheets("MagicIndex").Selection.Copy
    ...
  13. Replies
    3
    Views
    467

    Re: Change the x axes on all charts.

    Ok This is my Newest code. I don't know how to do this if my sheet is inactive but If the macro is launched on my active sheet and I "select" everything I need to, it works. I don't particularly...
  14. Replies
    3
    Views
    467

    Re: Change the x axes on all charts.

    BTW this is the recorded macro



    ActiveChart.Axes(xlCategory).Select
    ActiveChart.Axes(xlCategory).CategoryType = xlCategoryScale
    Selection.TickLabels.NumberFormat = "m/d H"

    ...
  15. Replies
    3
    Views
    467

    Change the x axes on all charts.

    When the user changes they source data from days to hours I need to have the macro make change the axes to reflect the change in some 12 separate graphs.

    Below is my entire code thus far. Of...
  16. Re: Why cant I directly set Wrap on a range of cells?

    Thank you,

    It drives me nuts because I can not spot errors like these. I get hung up on these details all the time.


    My programs are awesome, My programming sucks.
  17. Why cant I directly set Wrap on a range of cells?

    I would like to simply reference this range of cells and change one formatting attribute.



    Sheets("flaggedSite report").Range(Cells(RowV, 2), Cells(RowV, 6)).WrapText = True



    I get a...
  18. Re: how can I make a range of cells the same on an inactive sheet using cells functio

    Very intersting. I will play with these that copy resize thing sounds like what I need.

    Although I think alketraz's Idea is good as well. Thank your folks for your assist I would be coding...
  19. how can I make a range of cells the same on an inactive sheet using cells function.

    This does not work
    Sheets("flaggedSite report").Cells(lastrow + 1, 1) = Sheets("GS 1").Range("D4:H10")

    This Does work
    Sheets("flaggedSite report").Cells(lastrow + 1, 1) = Sheets("GS...
  20. Re: How do I perform statistical analysis on Day of the week and for the last X weeks

    Feel like I am talking to myself. But I did figure out what was wrong from post 2 I had to reverse the logic for the if to be true.
  21. Re: How do I perform statistical analysis on Day of the week and for the last X weeks

    Ok fail the =sum(if statement works but not the STDev(if
  22. Re: How do I perform statistical analysis on Day of the week and for the last X weeks

    Ok I have progressed a little but not the way I wanted.

    I found that I can do a logical test in another column and use that to feed my statistics formula.

    In column "I" I made a test to test...
  23. How do I perform statistical analysis on Day of the week and for the last X weeks.

    I was working with formula array but when I put the And in all hell broke loose.

    I have named ranges
    Graphdaterange has all of my dates
    GS1 has the value I want to analyze

    Ultimately I want...
  24. Re: Error when attempting to change font color on secondary axis using VBA.

    Well my solution although not all that graceful was to create a template and I call that template.



    ActiveSheet.ChartObjects("Chart 8").Activate
    ActiveChart.ApplyChartTemplate...
  25. Re: Error when attempting to change font color on secondary axis using VBA.

    My Bad, I am working with MS excel 2013
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno