Programming

sendkeys sends every other letter Excel 2007 to Outlook 2007
I am running a macro that uses Sendkeys to send text from an Excel cell to the body of an email in Outlook. Worked fine in Office 2003 but since upgrade to 2007 it now only sends every other letter. So, for example, if the value in the cell was "abcdefghij", then Outlook would only receive "acegi". Any ideas?... 15 Feb 2010 09:50

advanced filter date criteria
Hi My advanced filter works manually but not in macro > It is a criteria issue as column headings work I am trying to filter data where ship date is <= todays date +28 Columns("g:k").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _ "m1:m2"), CopyToRange:=Range("p1" _ ), Unique:=False ... 15 Feb 2010 08:43

Response to txtbox content if not found in the worksheets: Excel V
Hi, Everyone, I've a worksheet in a workbook that has a Search text Box created from the control box. I'd like to know the code that generates Msgbox "Data not found!!", when the search button is clicked. ... 15 Feb 2010 09:50

Workbook protection question
If you press the "Protect Workbook" button you will see a dialog box with two options: "Structure" and "Windows". What does it mean to protect "Windows"??? thankx ... 14 Feb 2010 10:41

Transfering Data From One Workbook to Another.
Dear All, I'm still teaching myself VBA, and there's a huge problem whose solution i cannot figure out. Your help would be greatly appreciated. i have an input workbook from which to extract data to another workbook (thus 2 different workbooks. The input sheet has data split up in five categories. Each category... 14 Feb 2010 08:29

Enabling Macros in a Password Protected Spreadsheet
I have a spreadsheet that contains some VBA code linkled to some combo boxes. I have digitally certified the file, so that I can run the code without getting a warning once I open it. All works fine: I can open the file, and use the combo boxes and the code beyound them. Now, the problem is that I need to pa... 13 Feb 2010 18:19

Wanted: ? UnknownFunction("vbOK") returns 1 in VBE Immediate wind
Hi, It is not a function; it is a constant. If you lookup msgbox function and msgbox constants in Help you will find out more about it. The following is a small example of its use where the users selection is returned to a variable. Sub test() Dim Response As Variant Response = MsgBox("Do you want to cont... 13 Feb 2010 19:26

Environ("Username") with Windows7 64bit
Hi all, I'm using XL2003 vba with WIN7 professional and my old vba code won't work. i create in XP some code lines to read out the user which is log on. now i want to do the same with win7 prof 64bit can someone give me hints ?? thanks in advance ... 13 Feb 2010 19:26

Export multiple Excel sheets to a single text file
I want to export (SaveAs) multiple worksheets to a single text file. probably csv. By Microsoft's design I can't do that with a straight Save As from the menu. So I thought maybe I could create a macro that would save each sheet one at a time. Unfortunately this doesn't seem to work because Workbook.SaveAs d... 15 Feb 2010 03:16

using cells property
I am using excel 2003 and trying to print an area that will vary depending on the number of players. Here is what I have now. Dim players As Long Dim pages As Long Dim rowcount As Long players = ActiveWorkbook.Sheets("week 1").Range("ad3").Value pages = (players / 3) rowcount = pages * 60 ActiveWork... 13 Feb 2010 09:19