Answer Questions

• george_v Compatibility Issue Excel 2000 and Excel 2003

  I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up. So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I live in the US and the customer lives in the UK. When he runs the macros it immediately goes into the debugging window and highlights a bit of code that simply references the path of the existing folder to a variable. The exact code is: DestFolder = ThisWorkbook.Path & "\" There is a compile error with a message that the data fold ...Show All

• Orest Bolohan Marking a location for return

  Once upon a time I had a macro that would mark a spot within an MSWord document, with a second macro that would return the cursor to that marked spot. I would like to recreate these two simple macros. Any ideas as to how to go about doing this Thanks in advance. Hi, No idea if this is what you had before but using the macro recorder I generated these 2 routines. Sub MarkSpot() ' ' MarkSpot Macro ' Macro recorded 31/01/2007 by Andy Pope ' With ActiveDocument.Bookmarks .Add Range:=Selection.Range, Name:="MySpot" .DefaultSorting = wdSortByName .ShowHidden = False End With End Sub Sub ReturnSpot() ' ' ReturnSpot Macro ' Macro recorded 31/01/2007 by Andy Pope ' On Error GoTo ErrReturnSpot Selecti ...Show All

• Al-Arabi ADO Recordset CursorType Property

  I want to create an updateable recordset, whereby the values in a particular field in the recordset once opened are changed to something else if certain conditions are met. However, I do not want these updates to change the underlying datasource, otherwise I would be in trouble! I would therefore need to set the recordset's cursor type property prior to opening the recordset, of which there are 4 constant values: adOpenForwardOnly, adOpenKeyset, adOpenDynamic and adOpenStatic. I'm guessing the last one of these is the one I need, but can anyone confirm this is the case before I start Are there any other recordset properties I need to consider as well Cheers! Keith Hi Derek, To be honest, I ...Show All

• NoobestNoob How To Open A File On Another Computer On A Home Network

  I need some code to use the OPEN statement. The file I want to open is on another computer on my home network. Anyone know what the file string should look like Thanks The basic format for a local/remote resource is "file:///" For example, if you're looking to browse the directory "C:\TEMP\", you'd use the path "file:///C:/TEMP/". Hi Easiest think to do is to set up a drive mapping in windows which loads each time your computer starts,then you can use a drive letter to refer to the computer. Otherwise, turn on the macro recorder and open the file from My Network Places and the recorder will correctly record the path for you. ...Show All

• SuperSaiyanZero Excel Time Help

  Hi all, This is my first time posting here , hope i will be able to find the answer i am looking for. I'm very new to vba so please bear with me. Here goes, this is the problem i'm having at the moment with my formulas and vba. I am currently desinging a roster for my workplace and the problem i am having is to work out the night shifts. these night shift start at 23:00:00 and end at 06:00:00, now because there is a change in date between 23:00:00 and 00:00:00 im finding it very difficult to find the appropriate formula. Let say the shift worked is starting at: 22:00:00 and ending at 07:00:00, what i would like excel to do is to calculate how many hours are worked from 22:00:00 to 23:00:00 and from 06:00:00 until 07:00:00 in on ...Show All

• comfixit HTTP request - simple problem

  I have a small server application (PHP) that is envoked with a URL and writes the attached parameters to a file. I want a client application to do the HTTP work. How do I call an URL from VBA without launcing a browser The URL (requested by a client application, not a browser) looks like http://www.test.com/fileWrite.php var1=234&var2=26&var3=4 Hi Derek, Thanks, that did it! Kristjan Hi, You can use MSXML's XMLHTTP object to make requests. Here's an example: Private Sub Command1_Click() Dim HttpReq As New MSXML2 .XMLHTTP40 HttpReq.open "GET", "http://XMLSampleServer/CatalogServer.asp", False HttpReq.send MsgBox HttpReq ...Show All

• markovuksanovic Help Building a Custom Annotation Report View for BSM

  Hi, I am trying to make a custom report for MS Business Scorecard server. I have implemented the sample report from the white paper on building custom report. When I alter that code to output annotations it crashes the report or portal its self. The code is the same except I added the GetTheAnnotations()function and created a new PMServer() which is part of the Server class. Please suggest how to access the annotation with the scorecard API. This is the code used: using Microsoft.PerformanceManagement .Scorecards.Extensions; using Microsoft.PerformanceManagement .Scorecards.Client; using Microsoft.PerformanceManagement .Scorecards.Server; output.Write(HttpUtility.HtmlEncode(GetTheAnnotations())); ...Show All

• DavidR100 Help !!!

  Hi, I want to show shape custom properties when I choose an Item of Combo Box in Visio 2003. I have this code so far. Private Sub ComboBox1_Change() Dim visShape As Visio.Shape Set visShape = ActivePage.Shapes.Item(4) Select Case ComboBox1 Case "hardware devices" visShape.Application.DoCmd (1312) Case ... End Select End Sub The problem with him is that this display the Custom Properties of the Selected Shape. I want to display this shape wich I want in this case : Set visShape = ActivePage.Shapes.Item(4) I think this is very close to the right code,and I don't know what's wrong with this code. I'll be greatful to you if you have any ideas about this !!! Tnank you in advanced! ...Show All

• koder monkey Loop causing MS Word freeze

  I tried to run a simple loop I created as a macro employing a user form that contains a label and a command button. I want the label caption to alternate between OFF and ON as the command button is clicked. There must have been an error of some sort as when I ran the macro it froze MS Word completely. No compile error ever appeared and the macro DID begin to run without protest. I looked at the task manager and everything under MS Word was "not responding". I ended the macro under the task manager and MS Word completely shut down! Here is the code. I realize it is not structured correctly, but should trying to run it cause MS Word to to freeze up and require a shut down via the task manager Surely it can't have creat ...Show All

• alexfriends RunTime Error '13' Type Mismatch

  Hey, I have thsi code that I just cannot figure out. Anyone have any ideas why I'm getting a RunTime Error '13' Type Mismatch Here is the VB code: Dim CommunityMapTable() As Byte (Global Variable) Private Sub LoadCommunityCombobox() Dim I, J CmbCommunityDescription.Clear ReDim CommunityMapTable(CommunityLookupRec.CommunityCount) J = 0 I = 0 While I < Val(CommunityLookupRec.CommunityCount) If Trim(CommunityLookupRec.CommunityEntry(I).CommunityDesc) <> "" Then CmbCommunityDescription.AddItem Trim(CommunityLookupRec.CommunityEntry(I).CommunityDesc) CommunityMapTable(J) = CommunityLookupRec.CommunityEntry(I).Community J = J + 1 End If I = I + 1 Wend CmbCommunityDesc ...Show All

• Roy mm Microsoft Platform Test for ISV Solutions

  Hi. My company is getting ready for the "Microsoft Platform Test for ISV Solutions". Can I find more detailed directions and resources to set the designated application for the test i.e. to pass "managed code" tests- I know that the application is free from 'DllImport', but I'm not sure that: This is enough. One of the components I'm using works with unmanaged code. Further more, the document provided by Microsoft (" Guidelines for products that appropriately target Microsoft platforms and technologies " version 0.93) Declares that: Note: It is acceptable for assemblies sourced from third parties that are installed with the application under test to ...Show All

• James_Steven implemnting cache in best possible way

  I am working on how to implement caching in the best possible manner when we are implementing 1. optimistic concurrency (1 st scenario: we can live with stale data. 2 nd scenario :we cannot live with stale data) 2. pessimistic concurrency Here I also want to cover scenarios like when two thread of the same application accessing the same table in database by using different queries and when both have these query results in different cached objects.So what strategy should I use to make the cache stale ,at what moment of time. Please share your views on the above. Regards Sorry short of time so just a quick answer... 1. At what moment of time should we i ...Show All

• etones [ADO Excel] How to use ADO retrieve Excel Worksheet name and some information

  I want to retrieve Excel worksheet name and total count of sheets Dear Johnson, I have used the above in my excel file by copying this into visual basic editor. Actually I want the all woksheets name of my file in a sheet. Suppose if i have one file named c:\a.xls having four different sheets. Can you please tell me how to apply this code into the file. I am new to this thing please advice me in full, means i have to just copy the thing which you will give me. Please write sub () and endsub in this code also so that i can understand in full. Because I have already tried the above but error is coming Sub a() Dim mExcel As New Excel.Application, wb As Workbook, ws As Worksheet, YrXlsFil ...Show All

• engloon 1004 Run-time error

  I tried doing a search for this error message, but couldn't find one related to my problem, so here goes. Running Excel 2000 here and this macro (snippet below) has been running fine on several machines. Suddenly, this one machine in particular has been getting a 1004 Run-time error (With statement). I have an idea what the problem is, but the thing that gets me is this code still successfully works on several other machines at my work place. I know the code is sloppy, as you'll see below. I'm simply trying to fix something that was already in place before I got here. I'll definitely clean it up once I get it working. Any ideas Thanks in advance for the help. -------------------------------------------- Sub maketable() ...Show All

• Selectis One COM Add-in for all versions of Office (2000 and up)?

  If I create a COM Add-in for Office XP, will it also work for Office 2000/2003 Or do I need to create a new Add-in for different versions of Office Is there any reason to use COM Add-in vs. traditional XLA or DOT file beside having one dll that works for both Excel and Word A com add-in for office must implement the IDTExtensibility2 interface. It will work in office 2000, XP, 2003 as long as the objects, properties and methods you use are compatible between all versions. Basically, microsoft suggest that you build a version of your add-in for each version of office you want to use. There's a good article on this issue at http://blogs.msdn.com/omars/archive/2004/04/26/120047.aspx which might hel ...Show All