dde data copied from sheet1 to sheet2

Hello Chuckb74,

Welcome to the Forum!

I revised your macro The_Sub. It nows checks if cell "A1" on "Sheet2" has any data. If not, this is first cell the data is pasted into. Otherwise it will use the next empty cell in column "A".

Please Login or Register  to view this content.

Hello CB,

It only copies cell "A1" from "Sheet1" over to "Sheet2". The headers in column "B" on are safe.

Maybe like this:

Please Login or Register  to view this content.

It replaces Leith's code exactly, which has a place (I guess) for you to plug in some of yours.

Allow me to answer my own question. I pasted all of it in and replaced what was their and it is working nicely.

I have another question. Is there any way to know if your macro is running? Is there something I can check some sort of status? My reason for asking is I am now opening up the time to 30 minutes between the macro firing and posting the information to sheet, so I would like to be able to check and know that macro was running, possibly via a countdown feature showing the time until the next posting?

One more question, remember I am a neophyte..... There are three parts to this macro Start Timer, Stop Timer and The Sub. I noticed that When I Alt-F8 and highlight the Sub and choose run it obviously fires the macro and logs the data to sheet2, well does this automatically start the timer? Or is it just a preliminary logging of the data and the timer just keeps running. I know I am starting to ramble and I apologize. I guess my question is what actually starts the macro running and how can I know where I am in the timing of the macro.

Update 8-31-09 I am running the macro in the workbook this morning and it appears that my questions above are my overriding concerns, macro running status and on/off of the macro itself? Another question is can the macro be running in multiple instances, i.e. this morning the second 30 minute logging of data into sheet 2 occurred 3 times within the same minute.

So the good news is it is working it just needs some tweeking and I obvioulsy need to understand macros at a higher level.

Thanks all
CB

Hello chuckb74,

The problem is the procedure StartTimer is being called again in The_Sub. Remove the StartTimer statement and it should work fine. StartTimer setups up the timer to automatically call The_Sub every thirty minutes. Once the timer is intialized and started, it will run at the assigned interval until you stop it.

Please Login or Register  to view this content.

Another Macro related question.

When Load the workbook I get a security alert about the macro's and the links I have been just enabling both of the settings. Well now all of the sudden EXCEL is locking up when I enable both the links and the macros? Any suggestions?
Thanks