Answer Questions

• rdleeper Projects, objects & modules

  I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named "Microsoft Word Objects". Within this folder is what looks like a file named "This Document". What does "Project" represent What does "This Document" represent What is the difference between "This Document" and the "Project&q ...Show All

• Mr. Scott X Visio VBA Show/Hide Subordinate

  Hey all, I have been working on a macro that will show/hide subordinate in Visio. This is the psudo code that I have come up with. Dim ShapeSelect as Visio.selection Set ShapeSelect = Visio.Activewindow.Selection If ShapeSelect.property = "show" then ShapeSelect.property = "hide" Else ShapeSelect.property = "show" End If Again this is just psudo code so dont hold me to any of the methods. If someone could give me some code to accoplish this task it would be very much appreciated. If you just know the code to set the shape to hide/show subordinate, I can write the rest of the code from there. Thanks in advance for all the help. ...Show All

• Philipp Lamp VB to MSWORD BookMark

  Hi, I am trying to get a currency held in a VB variable from an access database to move accross to MSWORD and keep the decimal point and commas in the bookmark. If i try to transfer over 15.36 for example i get the decimal point, but for numbers like 150.00 once put into MSWord i get 150. Is there any way to keep the decimal places even if its 0 and add the comma's in automatically. It can be hardcoded in using strings but i think there must be a much simpler method of achieving the same result. Hi Have you tried formatting the value using the Format function to get what you want Peter Mo. ...Show All

• sqlguy12 Outlook Contacts

  I have a load of contacts in Outlook, however when i go to send a mail none of them come up. Therefore i have to copy and paste them when i am writing a new mail. I have checked that the contacts folder is selected. This is a works email system, the Global address list using Exchange works fine but my personal one doesn't. Can anyone help If you work for a company, you might want to check with your IT department to see if there's a settings issue; this seems like a pretty basic issue. Otherwise, you might want to contact Microsoft Product Support for Outlook and they'll get your problem explained and/or help you fix it. Hope this helps. --ISV Buddy Team I found t ...Show All

• sd_dracula Buddy program?

  Hi, I signed up for the buddy program about 2 months ago, and have yet to be connected with someone. I emailed budsup@microsoft.com initally, someone contacted me and I was working with her. I thought it was resolved by her email stating: " As a matter of fact, Ibrahim, I matched you up a moment ago with a Microsoft Buddy…the trouble seems to be that there was a different name in the system than the one you’ve given me here…" But I never heard back from her, or my buddy after that. I followed up with her but received no response, and then sent an additional email to budsup@microsoft.com, and heard nothing back. How can I go about being matched up I guess there was some confusion over what name/email I signed up with but I didn' ...Show All

• watch is For Each Next Loop

  I have a very simple For Each Next loop, where I want to loop through all the worksheets in the active workbook and simply select cell A1. It just isn't having it, giving me the error 'Select Method of Range Class failed'. Here is the code: Dim Wksht As Worksheet For Each Wksht In ActiveWorkbook.Worksheets Wksht.Range("A1").Select Next Wksht Cheers for any help! KeithyBOY, In order to select a cell the worksheet needs to be active, you can't select a cell in a inactive worksheet, here's the code you need Dim Wksht As Worksheet For Each Wksht In ActiveWorkbook.Worksheets Wksht.Select Wksht.Range("A1").Select Next Wksht Just to nitpick: I'd sugges ...Show All

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

• TheViewMaster ISV Royalty Program - OA2007

  1) Are there different types of ISV programs If so, what are the differences between the programs   2) How does the Royalty program differ from other ISV programs 3) Does each program offer different benefits to the end customer   4) How does the Royalty program differ from other ISV programs to the end customer     5) Does Microsoft have a brochure or a list of the benefits for the end customers   6) If I was to have a techincal problem with a soultion and I can not get in touch with the ISV that sold me the soultion will Microsoft be able to help me       7) What are the benefits from buying solutions from an ISV to an end user ...Show All

• johnny_no1_boy Restrict editing of activity based on date comparison

  Hi (again!) thanks to the help of many forum members i have built a system for our users.  I have a facility that allows users to do an end of month submission and it writes the date selected into a field called 'datelastsubmitted' in 'tblusers'.  the reason i am doing this is that i do not want users to then be able to go in and edit any activity that they have entered prior to that 'datelastsubmitted' value.  When they open up an activity to edit (as opposed to creating a new one) i want to be able to restrict them from editing the activity if the 'datelastsubmitted' value is more recent than the 'activitydate' value.  this form is based on a query between linked tables so datelastsubmitted and activitydate are a ...Show All

• shibin Visual Basic In Excel - Popup or Splash Screen

  I have created a simple program in VB inside Excel, When processing it takes a while so I created a form to display while processing, how do I get this form to show while the process is going but still allow the previous form to do its work, then the popup (splash) screen closes when the process has completed Nick Getz This is built within excel, so I assume Visual Basic for Applications, unless you can help me export it into Visual Basic 2005 Express Addition, whcih I downloaded after making significant progress on this application. Thanks. Is this Visual Basic 2005 Express you are talking about, or within Excel, as a VBA (Visual Basic for Applicatons) project   As you're using the VB within Ex ...Show All

• Cameron D delete blank line in table cell

  Hi, I have 3 paragraphs in a table cell. Each paragraph separated by a blank line. I'd like to delete the blank line so that all paragraphs aren't separated anymore. Example: line1 sentences paragraph line2 sentences paragraph line3 sentences paragraph Wanted: line1 sentences paragraph line2 sentences paragraph line3 sentences paragraph Code so far: For tblIdx = 1 To ActiveDocument.Tables.Count Set theTable = ActiveDocument.Tables(tblIdx) If Mid(theTable.Cell(2, 2).Range.Text, 1, 23) = "Scenario and Conditions" Then With Selection.Find .Text = "^p" .Replacement.Text = "" .Forward = True ...Show All

• Can-Ann Running a macro if new mail if from a specific address

  Hello, I'm currently trying to write a macro that is run when new mail is received in Outlook 2002 (possibly XP not sure though) I would like the macro to check if the new email is from a specific address (in this case sales@falcontrunking.co.uk ), delete the email, and display a message saying "There is a new message in the Sales Inbox". I know how to run a macro when a new message is received and I know how to show a message box saying "There is a new message in the Sales Inbox" but I don't know how to check if the new message has been received from a specific address. Can anyone help me Sorry. I'm running Outlook 2003 here, and I shouldn't have assumed that the NewMailE ...Show All

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

• grsgrs Configuration Failed: Windows SharePoint Services 3.0 (Beta)

  Downloaded SharePoint Services 1.I selected Basic Button “install single server stand alone using default settings 2.Closed SharePoint Service Install and checked to start the configuration wizard. 3.Next I said yes to the popup message: The following services may have to be started or reset during configuration: Internet Information Services SharePoint Administration Services SharePoint Timer Service Choose yes to restart the services if required and continue with the configuration wizard or no to exit the configuration. 4.It starts to configuring SharePoint Products and Technologies. 5.Then I get: Configuration Failed One or more configuration setting failed. Completed configuration settings will not be rolled back. Resolve the problem a ...Show All

• Reta Method 'Save' of object '_Workbook' failed ERROR??

  In advance, I appreciate any help or suggestions... I have an Excel workbook called "PXImport" that is very simple, yet I encounter the SaveAs auto-recover dialog box appearing regularly with a generic name like "90FBE46L". This causes the entire workbook to stop executing. PXImport is linked to a local data source that changes in real-time. PXImport is saved in 10 second intervals in order to save its current state so that several external workbooks can remotely link to PXImport. The error is in the SaveData() function. This function is called every 10 seconds. The error Msg is: Method 'Save' of object '_Workbook' failed It runs just fine about 98.5% of the time. Every once in a while everything will stop and I am greet ...Show All