Answer Questions

• thukralz Interactions with Outlook

  I've developed a workflow application in Excel, which starts off with a form, which users complete whenever they have a data/report request. I then want the application to do two things: From the user end, I want their request to automatically email to me when they click FINISH on the form, so they don't have to worry about sending it themselves. Second, when I receive their request in my inbox, I want my application to look through all my messages, select all new requests, take the information in the email and log it somewhere. I have been successful in achieving both of these things and have tested it on my own machine. The problem is, as soon as Outlook detects that another program (i.e my Excel application) is sending mails on ...Show All

• Ujjwal Das Testing for a Null date/Time field

  This is driving me mad, it should be all so simple, I have a date/time field on an Access form that I want to test if it is unfilled (null), if so put a check in a checkbox field, so .. if me.reminded = null then is what I'm doing, but it seems that the field is NEVER null (even though it is, str(me.reminded) gives an "Invalid use of Null" error) Someone help before this laptop goes through the window Thanks a million Hi See IsNull Function e.g. if isnull(me.reminded) then ...Show All

• Dan Morris what is wrong with this formula? *9 Views & no one knows?*

  =IF((Weeks!D(B1+6))="",1,2)   whats the error with this D(B1+6) is ment to respresent a cell with D    = the value of B1+6   what am i getting wrong Hello Milkshake, What I was trying to say was, suppose you had these two bits of code: Code version 1 f Sheets("Weeks").Cells(B1Value + 6, i).Value = "" Then Sheets("Add Details").Cells(x + 2, "G"). Value = 1 Else Sheets("Add Details").Cells(x + 2, "G"). Value = 2 End If Next x Code version 2 colOffset=7 ' G being the seventh character of the alphabet ie column G If Sheets("Weeks").Cells(B1Value + 6, i).Value = "" Then Sheets("Add Detail ...Show All

• ozhonetech iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this Not sure if this is related, but I get a cannot read memory at location 0xXXXXXXX (varies) after I have 8-10 browser pages open, no matter what site I am at. I've learned to live with it, but sometimes, because of pop-ups, it still gets me. When it happens the mouse become slugggish and nothing it responsive. Then 6-8 minutes later, I get the error message. I've gone through several versions of IE and also several complete me ...Show All

• TerryYoung IsError function from VBA6.3 to v6.0

  Hi All, I'm having problems with a small VBA script that I wrote in v6.3 but need to implement in 6.0. Excel 2002 -> 2000. The following code works fine in the later version: For i = 2 To LastRow ' select the next row based on loop vString = "A" & i If IsError(Application.VLookup(Range(vString).Value, vRange, 31, False)) Then Y = "NEW" Else Y = Application.VLookup(Range(vString).Value, vRange, 31, False) End If ' write the result to the active workbook Cells(i, 31).Value = Y Next i But won't work in the earlier version as there's a type mismatch at the If Iserror ... line. Any ideas why or thoughts on a workaround Thanks, Steve. ...Show All

• JimmyS Gantt Chart component/library

  Hi, I am looking for a component or a library or a framework to draw Gantt Charts much like MS Project. Either a free or a paid solution will do. I need to be able to incorporate it with my .Net application (written in C# 2005). I have searched around and found several solutions which more or less come close to what I am looking for. But I would like to hear from someone who might have researched it in the past and know about some good components or libraries out there. Basically, I would like to simulate MS Project's project management charting solution, but in a simplified version. Thanks in advance for any pointers. Mehdi I understand you didn't find a good Gantt Chart component yet, with a l ...Show All

• OmegaMan "Bizzare" Sendkey Code in Excel

  Following is my code... Range("A1").Select 'Select cell A1 Application.SendKeys "BIZZARE{ENTER}", True 'Enters BIZZARE in A1 and focus goes to B2 Application.Wait (Now + TimeValue("0:00:02")) Application.SendKeys "{UP}", True 'Again focus on A1 Application.Wait (Now + TimeValue("0:00:02")) 'Range("A1").Select 'Just in case {UP} doesnt work Selection.Copy 'Path 1 Range("B2").Select 'Path 1 ActiveSheet.Paste 'Path 1 Application.SendKeys ("^C") 'Path 2 Range("B2").Select 'Path 2 Application.SendKeys ("^V") 'Path 2 My code wanted ...Show All

• createdbyx Count and display in cell

  Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger Hello, Try the following code: You could ...Show All

• tlc660 read line from table cell for vba in ms word

  Hi, I need to read a line in ms word table cell. There are 3 line in a cell and I'd like to read line by line and put a line in a string variable. Would anyone be willing to help me here I'm so desperate with the answer since I tried everything and none are working. What I did so far: If (Mid(theTable.Cell(caseStartRow, 2).Range.Text, 1, _ Len(theTable.Cell(caseStartRow, 2).Range.Text) - 2)) = chrs$(13) Then objFile.WriteLine ("") objFile.WriteLine ("") End If Please help. Thanks so much!! Here's an example of code that will do this: Option Explicit Public Sub main() Dim strCellText As String Dim strCellTextLines As ...Show All

• Ofer Elboher vlookup

  Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata Hi, How about some like this Dim rngLookupValue As Range Dim rngtable As Range Dim lngColIndex As Long Dim blnRangeLookup As Boolean Set rngLookupValue = Range("O2") Set rngtable = Workbooks("Consolidated list of supplier.xls").Worksheets("Sheet3").Range("$A$5:$F$218") lngColIndex = 6 blnRangeLookup = False vntResult = Application.WorksheetFunction.VLookup(rngLookupValue, rngtable, lngCol ...Show All

• AlexBB CurrentRegion Property to Specify SourceData in PivotCache Method

  I'm fairly new to writing VBA macros to create pivot tables in Excel, and I could use some help. I would like the macro I am writing to be able to use the Currentregion property in order to specify the SourceData for the PivotCache method, where the source data is located on a sheet named "macro". Any feedback warmly appreciated. This syntax works: ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:=Worksheets("macro").Range("A1").CurrentRegion) _ .CreatePivotTable TableDestination:=Worksheets("pivot").Range("B2"), _ TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion10 Note: It's pretty easy to figure these out ...Show All

• Voodoo45 Adding a command button to the toolbar or menu bar in Excel?

  Hi I'm wondering is it possible to add a command button to the toolbar or menu bar in Excel using VBA I came across an excel file before in work that somebody had setup this way but not sure how to go about it! I basically have two buttons that I would like to have added to the toolbar or menu to make the sheet tidier and enable the user to see all the data without having to move the buttons etc. http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_buttons.jpg Any ideas folks Thanks, Scott From the VB Editor's Object Browser: Function GetOpenFilename([FileFilter], [FilterIndex], [Title], [ButtonText], [MultiSelect]) Inside the procedure you posted, "Import ...Show All

• polska2180 VBA Module to DLL

  How does one convert a VBA Module into a DLL (I'm thinking this is an alternative to compiling into EXE file). Some of my VBA modules are quite complex and I would like to protect them with something other than a VBA Project password. ChasAA Thanks Jon, I'll have a look ChasAA The book "Professional Excel Development" by Bullen, Bovey, and Green covers this. Although the book concentrates on Excel, the VBA-DLL thing should be valid for any application that hosts VBA. There's a link to the book on my web site: http://peltiertech.com/Excel/xlbooks.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://Pelti ...Show All

• rock.aut Expiry dates on Code signing certificates - One Year?

  Hi, I am not a certificate expert, so this may be a simple question. We have purchased, for the past few years, Class 3 code signing certificates from Verisign. These expire every year, and we have to then acquire a new certificate, individually open, resign and republish all previously signed apps (usually Excel workbooks). This is a major hassle as we have a lot of signed apps. Recently, we decided to use MS Certificate Server to sign our code as all of the apps reside within our intranet (we are not developing commercial software). Our Operations team has created a key that can be used, but we still have this one year expiry date issue, and they have quoted the following: For certificates that are issued by Enterprise C ...Show All

• winstonSmith MS Access 2007 Media Player Control Full Screen

  I have loaded a mediaplayer control unto my form and I control the source by setting the URL property to a video file. The url's are stored on a table and when the form opens, a list box is filled with the data, so all a user has to do is click on the title. I am using this approach for a clinical research study. The hope is to set code that will administer the videos based on questionnaire responses. Does anyone know vba code to make the Window Media Player control go to Full Screen that I could insert into an event like the List_AfterUpdate Nevermind. I overlooked the ability to change this property in the property window for this control. Sorry ...Show All