Search:

Type: Posts; User: benjibasson83

Search: Search took 0.01 seconds.

  1. Re: VBA Macro gets slower with every execution

    Hi I confirme I albready set up something that just closes and reopens the file. On each cycle thus every two minutes


    I let you notice that there is only one unic instance of Excell by looking...
  2. Re: VBA Macro gets slower with every execution

    Hi,
    I still have no solution:
    1) why excell stil fill fill fill fill 220 Mo of ram for no ground at all without cleaning althought there is only one instance ( booth file.txt and external...
  3. Re: VBA Macro gets slower with every execution

    For me, nothing at all justify this
    https://www.vbforums.com/images/ieimages/2021/06/3.jpg
    after only 2880 cycles VBA still fill extra ram althought there is no new dim variables at all
    althought...
  4. Re: VBA Macro gets slower with every execution

    Hi, if I change to an API timer, I cannot use userform because it will not respond at all. Worst: I cannot close excel by the red cross. the unic way to stop an running API timer is to do ctrl alt...
  5. Re: VBA Macro gets slower with every execution

    Hi
    to enable the one minutes event I do

    'Programmation de l'évènement toutes les 1 minutes
    Tps = Now + TimeValue("00:01:00")

    To disable it I do

    Sub StopTempo()
    On Error Resume Next
  6. Re: VBA Macro gets slower with every execution

    Hi,

    I have no nexs and the problem still occure

    VBA is alw&ays taking more and more ram and crash
    after 12 hours It take 224Mo instead of 30Mo ant crash

    How to free ram without restart...
  7. VBA Macro gets slower with every execution

    I have a macro that reads (once per minute) last line of a .txt file to store in a string variable It close .txt file. It Check if there is a jpg file witch finish with last line to display it on...
  8. Application.OnTime false but fail to stop

    Hi,

    My macro's userform have two buttons:
    One to start the Tempo module every minutes
    Another to stop the Tempo module. I am using
    Application.OnTime way

    When I start it run
    ...
  9. Re: error '1004' after 240th searsh / replacement

    Hi
    I don't know if it will help... maybu any sub doesn't like we close an userform to load manually another?

    Here is the sample of the prodbis.csv
    http://dl.free.fr/geLnMnALn

    Cheers
  10. error '1004' after 240th searsh / replacement

    Hi, I have an issue with a macro vba Excel 2010 :
    Every minutes the main macro is running to searsh the last line of an txt file to print the right picture on an userform
    Then every 5 cycles it...
  11. Replies
    3
    Views
    856

    Re: Pivot Table Macro Error

    Thanks for your answear.
    Dawn I didn't see that the argument appear twice.
    version 14 work on the excel 2010

    however the argument xlpivottableversioncurrent doesn't work :
    It display Running...
  12. Replies
    3
    Views
    856

    Pivot Table Macro Error

    Hello,

    I'm trying to automate pivot table using a macro I recorded from an Excel 2013
    However, once i execute this macro on another PC with Excel 2010 it is always showing an error on this line ...
Results 1 to 12 of 14



Click Here to Expand Forum to Full Width