Programming

Who is in a network shared Excel file
I retreived this code from a post and it works good as long as I am the one who has it opened originally, but if someone else opens the file first, I have a 'read only' copy and this code gives me an error. Is there a way to modify this so I can see who has the Excel file open? Sub UsersList() Dim users, msg As ... 29 Apr 2010 12:25

Check for other open wokbooks
I was using the line below at the end of my code and all was well. Until someone had other Excel workbooks open (besides the one I had created) and the code ran doing what it was supposed to do and closed excel completely. I do want the Excel to close down, but only if my workbook is the only workbook open. ... 28 Apr 2010 18:37

Excel Export to Access via VBA
Hi all. Hopefully someone can point me in the right direction. Here's what I want to do. I want to be able to click on a command button and export whatever logs that have been entered into the spreadsheet to be exported into an Access db with the same field names as the spreadsheet. I've read several postings on... 28 Apr 2010 17:29

Help with sorting data
I have a spreadsheet with 26 columns of info that's approx. 1000 rows long. I need to sort by column L and then Column I. When done sorting I will have multiple names (different every report) in column L and multiple medical conditions (different every time) in column I. The goal is to keep one row of each n... 29 Apr 2010 08:59

Textbox (Object) Right Click Menu - Disable Cut
I am looking to disable the right click Cut event when dealing with Text boxes (Drawing Objects). I have seen code that disables the right click cut. The following code works on the page, but not when a textbox is selected: Dim TheCmdBar as Office.CommandBarControl for each TheCmdBar in Applicaiton.CommandB... 28 Apr 2010 16:20

Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!
Thanks Dave. I was thinking of actually using both versions by inserting an: If Application.Version>12.0 then Use xl2007 syntax ElseIf Application.Version<12.0 then Use xl2003 syntax End If "Dave Peterson" wrote: xl2007 still supports the old syntax. So you could create the macro (recor... 28 Apr 2010 16:20

Pointing specific textbox
Hi, Could someone tell how to initialize or place the cursor in a specific box on a userform, when I open the userform containing 4 text boxes. By default it goes in the first one. Thank's ahead. ... 28 Apr 2010 17:29

Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!
I have this line of code in my macro. Someone with Excel 2003 can go past it. BOReportWS.Sort.SortFields.Clear Is there a way to get it to run in xl2003? 'BOReportWS.Sort.SortFields.Add Key:=Range("A3:A" & BO_DownloadWS_lastRow) ... 28 Apr 2010 14:02

SUMPRODUCT is not working
Hi all, This formula sometimes works and sometimes shows #VALUE! error. Please anyone advice. Thanks. ... 28 Apr 2010 15:11

Using vba find
I couldn't understand why the find method wasn't working in a macro until I realised that the range of cells I was searching didn't contain actual text, but the result of formulae referring to text in another worksheet. Is there a way of using find so that it will identify if the result of a formula matches th... 28 Apr 2010 12:54