Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    1,376

    Re: Excel workbook to powerpoint with animation

    Thank you Worf, for all the great code and suggestions. This does now exactly what I want to achieve, makes it so much easier to compare the charts.
  2. Replies
    6
    Views
    1,376

    Re: Excel workbook to powerpoint with animation

    Thank you Worf for the great code. This is exactly what what to achieve.

    Is there a easy way to make the Y-scale on the *.xls-file charts to the same size while moving over to the *.ppt. Let say...
  3. Replies
    6
    Views
    1,376

    Re: Excel workbook to powerpoint with animation

    Hi Worf,

    Thank you for your great solution, this is exactly what I want the program to perform.

    A further question on the same topic: Is it possible to change the code so it read several...
  4. Replies
    6
    Views
    1,376

    Excel workbook to powerpoint with animation

    I'm not so good in VBA so I hope someone with more knowledge can help me. I have a *.xls file with nine Worksheet, in each worksheet there are two charts.
    What I want to do is to move the two...
  5. Replies
    6
    Views
    270

    Re: Create a chart in every *.xls file

    Thank you, I have already tried it, but the difference between your suggestion and the record was to big to be able to transfer it.
    Thank you for your help, it is highly appreciated.
  6. Replies
    6
    Views
    270

    Re: Create a chart in every *.xls file

    Thank you for your suggestion, it works very well.

    Could you please tell me how I should change the code if I want to set X-axis in the same range but from column A instead of as it is now a...
  7. Replies
    6
    Views
    270

    Create a chart in every *.xls file

    I have issue which I hope someone can suggest a solution for.

    I have several *.csv files in a folder, which my program can open and convert to *.xls-file. What I need to do is to make a chart in...
  8. Replies
    3
    Views
    227

    Re: Loop columns copy/paste

    Thank you Fluff, very much appreciated.
  9. Replies
    3
    Views
    227

    Loop columns copy/paste

    My question is probably very easy for someone who knows VBA more then me.

    I have *.xls file with five columns each column is x rows (let say 40000 rows ). I need to copy 200 rows from column D...
  10. Replies
    12
    Views
    479

    Re: Counting cells with number

    Thank you for your help and suggestion, now for a unclear reason it works now! (Which is the main thing.)
  11. Replies
    12
    Views
    479

    Re: Counting cells with number

    Yes but with some modification. Following code work for me:
    [/code]
    =SUM(A1:A3)
    =COUNTIF(A1:A3;">"&1)
    the , is replaced with ;
    but the same change in the original code will only give a green...
  12. Replies
    12
    Views
    479

    Re: Counting cells with number

    The output is the same, it highlight ||0,"",countif|| part of the command. So I did some tests and this =IF(A3=0;"";COUNTIF($A$1:A3;0)-SUM($B$1:B2)) does not pop a alert code but it does not fill any...
  13. Replies
    12
    Views
    479

    Re: Counting cells with number

    Unfortunately it does not work for me on the exactly same setup as the example either.
  14. Replies
    12
    Views
    479

    Re: Counting cells with number

    Yes, I have both copied and typed it my self. None work. I'm using Excel 2016 and have comma as separator with two digit decimal numbers, if that matters?
  15. Replies
    12
    Views
    479

    Re: Counting cells with number

    Thank you Alan for the suggestion, but unfortunately I get alert code:

    "There's a problem with this formula.
    Not trying to type a formula?
    ...
    "

    Just to make sure I'm clear, the numbers and...
  16. Replies
    12
    Views
    479

    Counting cells with number

    I have issue in count cells which I hope you can suggest a solution for.

    I have column with a mix of 0s and value >0. So I need to count number of zeros in between each number>0 and state it on...
  17. Replies
    14
    Views
    524

    Re: Rename_file names

    Irobbo314, sorry for the delay to answer. John_W help and solutions is great and awsome. As I can see in you code it only read out the content of the folder
    ...
  18. Replies
    14
    Views
    524

    Re: Rename_file names

    John_W thank you for answering. Yes the task is similar, I did try to change your program to fulfill the new mission by changing n and m but it was not that easy. The pattern is correct, that is how...
  19. Replies
    14
    Views
    524

    Re: Rename_file names

    Thank you so much for the suggestion, unfortunately it give me "Run-time error 5: Invalid procedure call orargument" and highlight this line in the code

    "AR(Cnt, 2) = (matches(0).submatches(0) *...
  20. Replies
    14
    Views
    524

    Re: Rename_file names

    Hi Ravi,

    Thank you for your suggestion. But I'm not really sure where I should add Name xxxx and name yyyy; in your program or i a worksheet cell?

    I don't want to rename file in worksheet or...
  21. Replies
    14
    Views
    524

    Rename_file names

    I have several hundred files in a folder which I need to rename in a specific order. I write the question as it was only 12 files in the folder.
    I need to add letter A_ to the first file name(0) in...
  22. Replies
    7
    Views
    372

    Re: Fill column with same number

    Thank you so much for the suggestions. That helps a lot.
  23. Replies
    7
    Views
    372

    Fill column with same number

    This is probably very easy for someone who knows VBA better then me. But what I want to achieve is to populate let say five rows in same column with same number then add one to that number and...
  24. Replies
    16
    Views
    655

    Re: Loop through a folder and rename the files

    Great, Thank you John_w for the code and your effort, this is exactly what I want to do. Highly appreciated. As well thank you Yongle your suggestions I have learned more VBA from these.
  25. Replies
    0
    Views
    110

    Closing a specific file

    I have folder with many files, which the code below is applied on.
    So the process is to select the folder which have the files. The code open first *.txt file in excel, do some calculations save...
Results 1 to 25 of 37
Page 1 of 2 1 2