Answer Questions

• Greg Van Mullem 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 Hello bennett1016, You are probably experiencing this error due to an ActiveX control on a web page that you are visiting. Essentialy what the message states is that the instruction at the executing address (here its at 0x62304320) tried to read from the same memory block that is currently executing. In basic terms it tried to read 2x at the exact same moment on the same location which cannot be done. I would contact the si ...Show All

• GSK_phili beforeClose event bringing up compile error...

  Trying to figure out how to use the beforeClose event and can't manage to get it working   Here's details of the error msg and code:  Private Sub Workbook_Open()     Dashboard.Show End Sub Private Sub Workbook_beforeclose()     Sheets("IRE").Visible = xlVeryHidden     Sheets("UK").Visible = xlVeryHidden     Sheets("GER").Visible = xlVeryHidden     Sheets("MASTER").Visible = xlVeryHidden End Sub The error message is saying: Procedure declaration does not match the description of event or procedure having the same name Any ideas You've defined Workbook_BeforeClose as a procedure which takes no para ...Show All

• leahcimp Run Time Error 9 when Calling a Userform

  Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to run on the computers that get the run time error on them when I try running the code on them. I get the run time error when I try to load or show any userform in the workbook and I get it if I try to run code that is in the userform module. However, if I paste the code into a regular module and run it, the code runs fine. Does anyone know what co ...Show All

• Bt1982 Problems upgrading from Office 97 to Office 2003

  Hi all Finally we have upgraded from Office 97 to Office 2003. When I have upgraded my Access databases I have had an error because MSCOMCT2.OCX was missing. I have Microsoft DTPicker controls on most of my forms. I have copied MSCOMCT2.OCX and MSCOMCT2.TWD into C:\windows\system32 directory, but I still cannot see the time and date picker controls in the tool box. My original controls come up with an error that there is no object in the control. Have I missed something Brain in gear now! I have remebered to register the Control! ...Show All

• DevboyX Filling data from one sheet to another (excel)

  Hi, Maybe someone can help me out with this code. I have one worksheet, that I get everyday that is long and one cell is filled with customer numbers. On another sheet, I have a list of all of the customers and there coresponding customer number. I would like to have a little code that each day I can execute and the daily sheet will populate the customer number cell with the accual customer name. I don't really know where to start, any help would be appreciated! Hello, Have a look at the VLOOKUP and HLOOKUP functions these let you lookup a value based on an unique index (your customer number). How you apply the function really depends on how you want the lookup to work. Have a look a ...Show All

• blowdart Activate a workbook based on a value in a cell in another workbook

  I want to activate another active (open) workbook only if its name is the same as what I have recorded in a cell in my workbook. If it does return the same name then it is activated, otherwise a message box displays. Example: In my Reports workbook on a worksheet name “formula” in cell B33, I have the value “JulyData”. This represents the name of another workbook (i.e. JulyData.xls) Before a routine is run to import data into Reports.xls I want to verify that the name of the source workbook is actually “JulyData.xls” (as verified to B33 on my “formula” worksheet) and not “AugData.xls”. If it is “JulyData.xls” then I want the procedure to make it the active workbook and start importing data from s ...Show All

• JimBobJoe Using macro to enter usrname + pswrd

  Hi! Is it possible to use a macro to login to another program What I want to do is to have my macro open a program that requiers user name and password. I want the macro to write the user name and password so that i can open the application automatically. The application is Bloomberg (not sure if that makes a difference or not, but I have paid for a Bloomberg account so I do not want to hack the program etc. I just want to be able to open it automatically). Any help appreciated! Thanks! try application.sendkeys ...Show All

• Cherva Comparing and filtering data in Excel?

  I’ve been given the task of comparing two sets of employee data, both of which are in the same layout/format, and am required to filter out those which are duplicates i.e. should leave only new starts. I have been told that a Vlookup function can be used to achieve this but don’t know how it can Would this be easier to accomplish using VBA If yes, could I have a brief structure of the code required To elaborate, the spreadsheet contains a unique employee ID and other details such as department, manger, email, etc. One set of data is from the previous months upload and the other is the latest data pull. I need to compare this months data with last months and see who is present that wasn’t before. Any help is much appr ...Show All

• boxelder Right-click menu icon

  Hi there, Can you tell me how to add an icon next to a custom right-click menu item Like the little scissors next to the "Cut" item, I would like to place an image next to my custom menu item. Any help would be great. Thanks. Hallo, a quite similar question. I programmed an exe from which the icon is shown in the taskbar if it is activated. There is also a right-click menu with 2 items (close, configure) available. Can you tell me how to add icons to this menu items Best Regards, Hi, The menu item you create should have a faceid property. You set this to an integer value that represents the built in icon you want to use. You can get free faceid viewe ...Show All

• Liebethal bracketing "ifs" and "ands" and "ors" in VBA over Excel

  How would I write this in VBA if (code1 = 13 and answer1 = 15) or (code1 = 14 and answer1 = 16) then do ...... it seems not to like brackets and if answer1 has several possbilities if (((code1 = 13 and answer1 = 15) or answer1 = 20) or answer1 = 24) .... where do the brackets go  Thanks again, Hamish             A "dialogue", to show a simple message with a couple of buttons, is the Msgbox function. Type Msgbox("<Your message>",<the type of buttons you want>) to display a pop-up box with some option buttons. Use it in an if statement like a function. Eg: If MsgBox("Do you want to continue " ...Show All

• Prime Digits sending emails from MS Word with variable subject line

  Hi, I've searched these forums but have not been able to find exactly what I need. I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code (    .Subject = "New subject"   ) What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in the toolbar. The email address is always the same but the subject line shows the customer's name and his account number (so that's different all the time) Is there any way I can get the VBA code to copy the first line of the report (which has the customer's account number and name) and use that in the subject ...Show All

• Stas Kravets Sort rows within a range

  Hi My problem is the following. I have a (100rows x 10columns) range to which some numerical output is written. I need to access each row in this range and sort it descending. Any suggestions Any help is much appreciated. Thanks. Thomas Do you mean you want to work through each row in the range, sort it left to right, then move down to the next row and sort it left to right, and so on Hi again I have written a solution that works. If any of you have comments, they are also much appreciated - I have just started with VBA. In a "Do While Loop" statement, this is the code: *** Range(Cells(Counter + 1, 6), Cells(Counter + 1, 6).End(xlToRight)).Sort Key ...Show All

• 2lazydba Creating a new number style using macro for MS Word

  Hi, How can I create a new number style for numbering list of items in word document other than the existing ones which are (a,b,c,..), (1,2,3,..), etc. The needed number style may be like (a, c, g, y, m, o,...). Is it possible to have a custom list to be used as a new number style, if so how can I create it and use it a. Item1 c. Item2 g. Item3 y. Item4 .... Thanx. ...Show All

• JennyMQuinn Can't Edit the View >> A working ArithAbort method

  Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however this can not be relied on, if it happens when the user doesn't have the access window in focus, it fails and the pop up appears. That pop up is way beyond many of my users to even press cancel and looks very unprofessional :) any ideas many thanks martin Hello! I do a hook on reply. I need create a linked ...Show All

• Drokker How do connect an Excel file from Remote Server

  Hi All, I am creating one application in Excel. In this application One Excel file will be in the Remote Server.When one persone get log in then the file immediately has to link with this excel file which in the remote server. Now my question is - Is it possible to connect the Excel file from the remote server using VBA. Please any one help me to do this. i am searching this in lots of way. if not is it possible Access file. Kalidas hey, i didn't taught it was so complicated, and i'm too a newbie to VBA programming. But i'll do my best. So, first of all i guess that the two PC's should "see" each others. First of all i suppose that on the server in singapore you have a shared folde ...Show All