Search:

Type: Posts; User: Susy

Search: Search took 0.02 seconds.

  1. Re: (excel) Someone made me a macro, but it only works sometimes, locate the error? H

    126307

    I double clicked on the area shown by the arrow, and also tried to right click and selected 'view code', but it just opens up that blank screen with nothing in it?
  2. Re: (excel) Someone made me a macro, but it only works sometimes, locate the error? H

    Thanks so much, I will try this!

    As for the code on that 'front' page. Curious thing, but even double clicking or right clicking and asking to view the code turns up a blank page. Is there a way...
  3. Re: (excel) Someone made me a macro, but it only works sometimes, locate the error? H

    126241



    There is a sheet that you use to put in the information. That sheet is called "macro" I have included a screenshot. I am not sure how to get the code of that sheet?
  4. Re: (excel) Someone made me a macro, but it only works sometimes, locate the error? H

    126213

    This is one that did not work, but then works sometimes? This is an example of the files that come in.


    This one is what it should look like (the format) once it runs through the...
  5. Re: (excel) Someone made me a macro, but it only works sometimes, locate the error? H

    Sub sadek()

    Dim myFile As String, textline As String
    myFile = Sheets("Macro").Range("C6").Value
    Open myFile For Output As #1
    For i = Sheets("Macro").Range("C4").Value To...
  6. Re: (excel) Someone made me a macro, but it only works sometimes, locate the error? H

    This is the code of the macro


    Sub sadek()

    Dim myFile As String, textline As String
    myFile = Sheets("Macro").Range("C6").Value
    Open myFile For Output As #1
    For i =...
  7. (excel) Someone made me a macro, but it only works sometimes, locate the error? How?

    I am not well versed in vb, so everything might be over my head.

    I receive several files each week in .xls format with specific information (ie, the column headings are the same, the information...
Results 1 to 7 of 7



Click Here to Expand Forum to Full Width