Answer Questions

• SWB108 A Important Question about a program

   Recently I was promised a laptop by someone who is associated with microsoft he said it was part of the waterfall charity program. was he feeding me garbage I've done some research on our Intranet and have not found any mention of a "waterfall charity program." Sorry. -brenda (ISV Buddy Team) ...Show All

• Randy Cragin design web browser.

  where should i start from to design my own web browser. thanks In Visual Studio 2003, there is a browser object that you could add to the tools. I don't know how much this has been added upon in the new release. You might want to try and see if VS 2005 would be a better choice for development of your web browser rather than VBA. ...Show All

• PAQUOT excel vba

  Dim rng As Range Dim rngSelect As Range Set rngSelect = Selection For Each rng In rngSelect.Rows Selection.Offset(2, 0) = rng.EntireRow.Select 'need to add each modified range to selection Next rng I want all modified ranges to be selected in code I need like all rows in different locations selected so I can cut and copy to clipboard Hello MarcusLCox How about building an array of range addresses as y ...Show All

• DaFeiFan Installing VBA6.0 on XP

  Good morning and hello.   Ages ago I received a SDK 6.1 containing the latest release of VBA 6.0. I happily and without problem installed this on my laptop running Windows ME and all was well. I have since updated my laptop to one running Windows XP Home and when I went to install the SDK I was confronted with an error stating that "....You first must install Microsoft Visual Basic 6.0 Service Pack 3 to install the VBA ...Show All

• Vladimir Sapronov tables

  Hi, I'm trying to write a few procedures in VBA concerning tables - is there any way of accessing the text contained in the tables without actually having to select it in the document akso, is there way through which I can detect where I am in a table, i.e if the cursor is in cell (2,3) is there any way of detecting this same about foot/end notes - Is there any way of finding out which footnote I am editting (for instance, if I should want to ...Show All

• soccerjoe5 Important MS Partner Question

  I'm giving serious thought to joining the Microsoft Empower ISV program, but I want to know for sure what version of MSDN and other software I'll get once MSDN Universal goes away.  The Empower ISV website has been recently revamped, but it STILL lists MSDN Universal as the version partners receive.  Since MSDN Universal is no more in about a month, what does that mean for active/new partners I coul ...Show All

• beach_bum Accessing OLE object properties (powerpoint 2020)

  Hello, I am trying to achieve the following in powerpoint 2002: Create a menu button that will add a ShockwaveFlash Object with certain property settings. Not being to familiar yet in using VBA, I would appreciate greatly a helping hand here. The code, shown below, is obtained via a macro and is attached to a menu button "FlashImport". It will show a little square representing the object on the slide. Now, while the object is ...Show All

• aeshaw Date Problem

  I have a date field on an Access form and I do not want the user to be able to put in a date that occurs in "last week's reporting period" (explained below). Our reporting period goes from Monday to Sunday........so for example since tommorrow is Monday (the start of the new reporting period), I do not want the user to be able to put in a date for the prior 'Monday to Sunday' period. I wanted to see if there was a way to enforce ...Show All

• etrek vba in excel

  the table may have more than thirty lines of data, so i need to scroll thru the table until an empty cell is detected. I deleted those extra lines. works ok, just need to change code to name files A1, B2, C3, etc, but do not know how to do so, Hope you can help, will be very much appreciated. i have tried the for next loop but kept looping and looping even past an empty cell. Thanks again John Thank ...Show All

• Jeff A James excel vba

  Dim rng As Range Dim rngSelect As Range Set rngSelect = Selection For Each rng In rngSelect.Rows Selection.Offset(2, 0) = rng.EntireRow.Select 'need to add each modified range to selection Next rng I want all modified ranges to be selected in code Thanks !!!! What I'm trying to do is take different selected rows, remove the first two columns from the selection set but leave the rest selected I ne ...Show All

• Smitha Saligrama Access 2003 - programming arrow keys with combo box

  On an Access form, I'd like the up/down arrow keys to be used to navigate the values in a combobox, similar to how a listbox behaves. So, for example, if there are five values starting with "M", the user could enter "M" and then press the down arrow key to get to the other entries. Since it's a combo box, the user could also just continue to enter text. I assume I need to program the keypress event to do this, but I'm not ...Show All

• John Cole Outlook - Looking up email configuration settings

  Hi, I would like, if possible, to query the email setup settings within outlook 2003 and later. More specifically, I'm actually interested in querying the users email settings to see if they are connecting to Exchange Server and if so, extract the Exchange Server address. Any comments will be very welcome.   Many thanks, Mike Coxeter Hi Mike, Here's some info from our supp ...Show All

• Robert Johnson Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• Walter Sobchak Why Excel 2003 keeps PivotItems with zero record count after refresh?

  After a pivot table is refreshed, if some pivot item is no long exist in a pivot field, the pivot field drop selection still show that pivot item to allow user to select.  Selecting this kind of pivot item will lead to no data showing at all. This is no good. I perfer Excel will remove zero record count pivot item from the pivot field drop down selection box after a refresh. (I don't mind Excel keeping zero record count pivot item inte ...Show All

• Andrey Basko Reading data dll into excel

  I have recompiled a Visual Foxpro table into a DLL using VFP9. It is registered and VFP reads the DLL correctly. The DLL is just a table with code that performs a lookup based on two values and returns a value for use. In Excel, the following code is in a module: Declare Function spec_Field_Value_Function Lib "spec_search" (cThisSize As String, cThisValue As String) Public Function spec(Shape As String, Property As String) As Variant ...Show All