Replies

Hi Joe

Thank you very much, I did not realise it can be solved this easily, but then of course you have to now about the solution first. Any case I found a few files of more than 25MB that caused the problem. As you said after deleting them the problem was solved.

Thank you again for the help, I realy appreciate it.

Joe

Is there a specific place where I can see incoming mails? or where must I search for it?

Regards

Hi Joe

Yes I can access my mail through Outlook Web Access, but pardon my silly question, how do I take action once I opened my mail box through Web Access?

Sorry if it is a silly question but I would really appreciate the help.

Regards

Hi

Sorry for taking so long to come back, but I was out of the office for a time.

We are both using Excel 2007

When we transfer the file with a pendrive then everything works fine.

When my colleque send the file to me then everything works, when I send it back to him the same problem occur, but when I tried to attach the macro again to the button on his machine I get a message that the button is locked for editing.

Upon further investigation I realise that the only difference between our computers is that my machine is 64bit and his 32bit.

I do not know if that is the answer to the problem and if I can do anything or change any setting to “not lock” the button if the file is send by email from my machine to his. As I said earlier when transferred by pendrive the the button do not lock up, or send from his machine to mine also no problem. It is only when send by email from the 64bit machine back to the 32 bit where the button lock up.

Regards

Rory

Thank you for the reply.

I want to copy about 10 cells at a time. Can you explain briefly how you set this up, I have never done it and do not know how or where to set it up.

I understand what you say about using this to trigger the copy routine, but will it be able to copy at intervals and not every change. I can use the previous procedure (calculation event on the worksheet) that I posted in the APIclock workbook WITHOUT the clock to copy every single change without a timer. The problem is that the data I want to copy can change 20 times a second and I do not want to copy all that. I want to copy at set intervals to reduce the quantity of data copied.

If your suggestion can not work here it will be a drawback, but if the only problem with the clock I posted will be the Undo button then I can live with that since I use more than one computer and I can use one where I hardly use Excel or Word on to accomplish this.

My problem is that I do not know how to inpcorporate the code in the APIclock workbook with the code that Andrew wrote, unfortuneately my knowledge as far as VBA code is concerned is a bit limited or if compared you, Andrew, Hans, etc, then it will fall into the category of Severely Limited.

Rory

Thank you for the advice.

A few questions on this since I have never used it before: Can you copy 6-8 columns of information in a record that will span a few thousand records to be analysed? Can you set intervals for the recording of information? When you talk about servers are you refering to the server I connect to or to the data suppliers server. Where I am I have to connect via a wireless connection or a mobile modem to a service provider in order to get to the info I am after. I would appreciate a bit more detail on this since I have no experience with this.

Thank you

Hi Andrew

Here is the workbook with the results and with some additions and changes I made.

If you look on the Record sheet you will notice that records are printed and then a few seconds later it print again. This is on 1min intervals, any reason for that?

It does not happen all the time, so I was wondering why it is doing that.

I would appreciate it if you can make any changes or enhancements to do it to the attached workbook. I do not take it for granted that you are going to spend more time on this but if you are going to I would much appreciated it. I can not tell you how much I learn here from you, Hans, Steve, etc, etc. I can assure you I do not take you guys for granted and do really appreciate the guidance and education here in the Lounge.

Hi Andrew

I found a new clock that I posted over the weekend in another post. The clock does not crash the system or stop running when you change workbooks, etc.

More importantly I found another script that execute code when a formula result change.

Have a look at the attached workbook, you will see that the results on the left, the yellow cells get copied to the green cells everytime the clock in A5 change.

Maybe we can use similar code instead of the Change Event

One other question: in the case where we specify intervals of say 10 seconds is it possible to have it print at round numbers like 10 sec, 20 sec etc or in the case of say 15sec intervals, 15, 30, 45, etc or in the case of minutes to print at 1:00 or 3:00 (mm:ss) etc. I do not know how much work is involved in enhancing the code but I would appreciate it if it is possible without to much hassle.

I will send another workbook after this one to show you some results of the original workbook that you coded.

Thank you again for the great work I really appreciate it.

Hi

After many hours of searching, testing etc I got hold of the script for a clock that does not seem to have any of the problems that some of the clocks have that display in an Excel cell.

Some of the problems with some clocks are that they stop running when you open a new workbook or change to another workbook. Some just crash Excel when you change workbooks.

The attached clock does not have any of these problems. If you have 2 workbooks open and use Windows > Arrange > tile Ok with one of the sheets with the attached clock in it you will notice that the clock stop running when you enter edit mode on the 2nd workbook but as soon as you press Enter it runs again. It also has not crach the workbook or Excel.

Then I must say that it contain some code that I have not seen in any of the other Excel clocks, maybe some of our wise men can enlighten us why this clock is different and if there are any other dangers or concerns in using the attached clock (I say this with the concerns from Hans mentioned earlier in mind)

Hi

Thank you, I got it running now: Tools> Macros > run Refresh macro

Thank you for the help

Hi

I did take note of it, I just want to understand how it works. I am not going to display it while I am working on a workbook. I did read many posts on other forums etc offering clocks and they work very nicely, but all I want to do here is having the clock run automatically inside a cell in the spreadsheet.

How do I activate the Refresh Macro? I thought all I have to do is changing B1=0 and then change it back to B1=1, but that does not work, the clock is not running, it only updates everytime you change B1.

Any other suggestion would be appreciated.

Hi

I know this was an old post, but I am trying to get this to work.

I am using Excell 2003. I have pasted the code provided in a module and add a now() function into A1, but I can not get the clock to run automatically. Can any body please show or explain to me what I am doing wrong.

I would appreciate it.

Thank you.

Andrew

Thank you for the briliant work.

I will study what you have done, I am always impress to see a master at work.

Andrew

Thank you for the good lesson, I learned a lot and the file works great.

I want to try a few more enhancements, if I can not figure out the referencing I might call on your supperior knowledge again.

So far the code works 100%, just a question: how do you stop the opperation and just save the workbook? So far I save it and when I close it then it boots automatically again. For now I have to force a workbook crash in order to get it to close.

Andrew

I would be greatfull if I can tap your brain once more. I am trying to copy more data as per the attached workbook.
I now have 4 pieces of data that I want to copy but I only manage to copy the first and the fourth, do you mind checking what I did wrong?
I would appreciate it very much.

I read the piece as you suggested, very interesting. I found that while you are running only this workbook there are no errors, the problems only start when you try to work on other workbooks in the same time. So for now I will run the workbook on its own on a separate computer.