Answer Questions

• JosepMola VBA, Null value and data object not set?

  This issue is getting my nerves. In VBA, I can't just say, if MyObject = Null to determine whether the object is set or not. IsNull is pretty uesless since it will report false when the object is not set. VBA treats Null as a value, not an object that hasn't been initialized. Does anyone knows how to get around it Or maybe there is proper way to determin whether the object is initialized or not Like a simple code MyObject == Null in C# Hi, Try using Is Nothing for objects. If MyObject Is Nothing Then MsgBox "MyObject is nothing" End If Maybe you need IsObject or IsNull Andy Pope wrote: Hi, Try using Is Nothing for objects. ...Show All

• SucceedEgg 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

• Jamie Julius about macro....

  hi all. if any1 can help me... i hav simple form having 1 command button...on click event of it i hac call 1 function.... the code is as shown below.... *****code******* Function Macro2() On Error GoTo Macro2_Err ' all data DoCmd.TransferSpreadsheet acImport, 8, "tableimport", "D:\hetal\vb\tempxl.xls", True, "" Macro2_Exit: Exit Function Macro2_Err: MsgBox Error$ Resume Macro2_Exit End Function Private Sub cmd1_Click() Call Macro2 End Sub ******* after running and clickin on button.. i m getting error like...." Object required".... so... how to add macro object on form... error is for line... DoCmd.tran... line of above code... plz help me... ...Show All

• cedubose WMI / Office2003 Critical Updates

  An attempt to download and install critical updates for Office2033 failed (Error Code: 0x57E) on two separate events, once using the Automated Updates and once through the Windows Update Website. Also, I'm having a new and continuous issue with the WMI feature of my XP(SP2) Professional operating system. I am using a home network with three computers and a router to access the Internet. I've ran WMIdiag.exe, executed the error fixes and continue to receive the exact same msgs each time I run it. Don't know if the two are related but would like to have the Critical Updates installed. Any suggestions out there ...Show All

• mrotoloni Take out the ability to input values on combo box?

  How do I take out the ability to input values on a combo box For instaance, if I want the user to select the month in other words, before i put anything in it, i was referencing something that wasn't there yet. Thanks, that helped a great deal. Now, how do i make it default to the first item Hi You can set the property "style" to fmStyleDropDownList I had the listbox down right but i had it before i listed all my items. What do you mean Great, thank you very much for your help. I had the listbox down right but i had it before i listed all my items. You can set the ListIndex property to 0 in VBA code Combox1.ListIndex = 0 ...Show All

• DanaBoim 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

• TobsTec LCS 2005 Users Staus issues

  Hi we have been installing LCS 2005 standard and have twice come up against this issue, Im sure its simple but we cant fathom it out We both login with Office communicator but it shows us as status unknown, we are both reg with the server. even though we are both online i cant msg him and we both show unknown to each other thanks Tobez wrote: Hi we have been installing LCS 2005 standard and have twice come up against this issue, Im sure its simple but we cant fathom it out We both login with Office communicator but it shows us as status unknown, we are both reg with the server. even though we are both online i cant msg him and we both ...Show All

• Kirk Evans Using ApplyCustomType with variable numbers and types of series

  Using our excel charting tool, users can create line/bar charts with varying numbers of line and bar series. e.g. They can generate a chart with revenue as a line series on the left axis and interest income, trust income and fees as bars on the right axis. I would like to apply a chart type using ApplyCustomType that would set the fonts and color scheme to our company standard, but it seems like the number and types of series in the Custom Type must match the number and type of series in the chart the user is creating. I created a standard template with one line and one bar series formatted the way I want it, but when I save that as a user-defined type and apply it, it makes the first series a line and every other series a bar regardless o ...Show All

• Hugo Soares VBA Powerpoint - identifying textboxes by type

  Hi everyone, I'm writing an add-in for Powerpoint 2003. I'd like to know how I can identify textboxes by type if such a thing exists. For example, when reading a TextFrame, how do I know if I'm reading the title textbox, the subtitle, or a the big textbox with bulleted points depending on the slide model I've found the Shapes.Title property, but that only gives me the title if it exists, not the value of the subtitle or the default big textbox with bulleted points that you find on a default slide. Is there some property somewhere that I'm missing Thanks a lot, Pete I might not have explained myself very clearly with my first post. What I want is a way to know for sure that I'm reading the big, default t ...Show All

• farsh "variable" to make Macro not associated with one specific sheet in workbook

  Hello, I am recording a macro program in order to pull specific data points out a spreadsheet in excel. Currently the beginning of my macro looks like this: Range("G20").Select Selection.Copy Sheets("Sheet1").Select Range("C3").Select ActiveSheet.Paste Sheets("An32 CD45").Select My problem comes with that last line of text. Does anyone know how I can insert some kind of variable or line of text that doesn't make this macro work only on sheet "An32 CD45" I want it to be able to pull the numbers from any page I ask, but when I try to run the macro on another page is still only pulls the numbers from "An32 CD45." Thank you for any help you can give. L ...Show All

• Quiztar Assigning new series to chart

  Hello! I have previously posted questions in this field but I have never gotten an answer. I really really need help with this. I have never programmed before and now I am supposed to do this VBA application for Excel. What I want to do is simple enough but I have trouble implementing it and since and really do not know anything about programming I do not know what is wrong. The problem is that I am supposed to replace the existing series for a chart with new series. I have the new series but when applying them to a new chart it does not work if I have not manually erased the old chart series. This does not seem like an obstacle but this code have to work for other applications. I try to change the series in a loop. Code: Do Wh ...Show All

• Justin Pyfrom Please Help with Access 2003 and ActiveX Controls

  Hello everyone, I am having a major problem and I can not find a resonable answer any where, so I hope some one here can help me out. I have been working with Access 2000 for a long time and have always been able to Insert the ActiveX control "Microsoft Common Dialog control, version 6.0". I now have made the jump into Office 2003 and Access 2003 which when I try to Insert the ActiveX control "Microsoft COmmon Dialog control, version 6.0" I get the following error: "You dont' have the license required to use this ActiveX control." Can I assume that Office 2003 Professional does not have the Design Time License for this control now If that is the case what do I need to get the License. Please someone ...Show All

• PSamuel precisely position embedded charts in worksheet

  I am embedding 4 charts into a worksheet and would like to position them into a nice 4 quadrant view. However, when recording a macro, the position of the chart at the end of Chart.Add, etc routine is arbitrary. Similarly, when I record manually repositioning the chart and then replay the macro, the results differ. Here is the code for creating 2 of the 4 charts. The recorder uses the ActiveSheet.Shaped("chart 1").IncrementLeft nnnn and .IncrementTop nnn statements to perform the repositioning. Any suggestions for predicatably positioning embedded charts within a sheet KC Charts.Add ActiveChart.ChartType = xlLineMarkers ActiveChart.SetSourceData Source:=Sheets("Cancellation - Swap Analysis"). _ Range(&q ...Show All

• Part Time Australian SendKeys open application

  Hi! I try to open a program from a macro in Excel and login (the Bloomberg professional, (not the website)) using SendKeys. With some help from other programmers I got the following code. It does not work at all though and I am lost. Can someone please help me with this My problems are: 1) I get error on the WaitFor …line. ”Sub or Function has not been defined” 2) If I delete the WairFor line I get error on the AppActivate("1-BLOOMBERG") line. “Illegal procedure call or argument” Sub bbg_login() AppActivate("1-BLOOMBERG") Application.SendKeys "{BREAK}",false WaitFor timevalue("00:00:01") Application.SendKeys "user_Name", false Application.SendKeys "{ ...Show All

• ceilidhboy Emails via Excel

  Hey Ladies and Gents, I am a bit new to the world of visual basic so please be kind. I have been set a mini-project here at work and need some assistance. What i am trying to achieve is for a user to click a command button in excel, opening up a new mail message in outlook. This new mail message will include filled areas in to, subject and main body with a hyperlink to the document in which they have just updated. I have managed to produce the following code so far: Sub Button1_Click() Dim theApp, theNameSpace, theMailItem, myAttachment, MessageBody, subject 'create a new Outlook Application Object, 'direct it to the proper NameSpace, 'create a new Mail Item and set the attachments collection Set theApp = CreateObject( ...Show All