Search results for query: *

Hi link99sbc I am home right now..I will do as you sugest tomorrow.. Thanks for your help Newbie2223

Hi I have search the Forum for a macro that will either Sign the staff member out or remind them to Sign out. The proble is staff are just closing the window without actually entering the "SOF" command to sign the session out correctly...or shuting down windows without sending the SOF command...

Hi Skip I have found a work around...and it works. Re your question Exactly what procedure runs when the workbook opens? I truely have no idea how the spreadsheet Auto updates..I assumed it was the macro that I found within the worbook..eg the Selection.QueryTable.Refresh...

Hi Skip The problem is that this worksheet's macro run's when it's open....that's the way the I.T depart. set it up. So I thought I would add my auto saving to a .txt file at the end of the I.T worksheet update. However my Auto saving part doesn't work. But if I run the whole macro manually...

Hi PHV and Skip PHV... I'll have a look at the DoEvents Skip...The Refreshable spredsheet was built my someone else ( IT ). I have to work with the output..which I am trying to Automate to try and work smarter for me. The Other Sheets are just a intro, to what the workbook does..so rubbish to...

Hi All I have 2 macro that work well..the only problem is that I manually wait a 1minute to ensure that my worksheets have update befroe saving the Data to a .txt file. Is there a way to make sure Refresh has stopped on the last sheet before continuing the macro I have added 'Pls Help in my...

Hi PHV Don't I fell like a idiot..I was testing from home....you are 100% correct. Thanks so much for your help Cheers Newbie2223

Hi PHV Thanks for your reply. I tried the code .however I get RUN TIME ERROR 9 Substring out of range When I run it It does write worksheet 3 to the .txt file...but not 1 and 2

Hi All I found this piece of code that works on the Active Sheet The problem I have is that my excel workbook was create by someone else and populates over 5 sheets..once I open the workbook. I would like to build a macro to auto copy sheet 3, 4 and 5 only How or what do I have to add to get...

Hi All I found this piece of code that works on the Active Sheet The problem I have is that my excel workbook was create by someone else and populates over 5 sheets..once I open the workbook. I would like to build a macro to auto copy sheet 3, 4 and 5 only How or what do I have to add to get...