Answer Questions

• Mr_White what OS are included in MSDN OS subscription?

  Can I find all the flavors of Windows XP, original, SP1, SP2, ... Pre XP if I subscribe to MSDN OS I am trying to build several machines for webapp compatibility testing, and it would be nice if I could download any OS snapshot from MSDN, but it's not clear from the MSDN OS product index that anything previous to latest SP2 is available on disk or download. Any help would be appreciated. http://msdn.microsoft.com/vstudio/products/subscriptions/chart/ This page shows a chart comparison of all of the various MSDN subscriptions. Per the "b" footnote below the chart, the following OS versions are available: Microsoft Operating Systems, including Windows Server 2003 R2, Windows XP Prof ...Show All

• MicMit Can you use VBA to access a spread sheet embedded in a word doc?

  I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated. Yes thanks. Can you tell me what wdOLEVerbHide does and how it is different from wdOLEVerbPrimary Also, do wdOLEVerbs work with a msoEmbeddedOLEObject (what a non-inline spread sheet is) Hi, Something along these lines. Sub WriteToSS() Dim objSS As InlineShape With ActiveDocument.InlineShapes(1) .OL ...Show All

• Kieron Lanning File Stream issues

  I am trying to write a script triggered from an Outlook email to parse the email (as a text file) and then update an excel spreadsheet with specific data extracted from the email. The email is a form email delineated by a "/" for field breaks and "//" for end of line. However, when I create a text stream to read in the data, the returned string does not include these delineations. Here is a copy of the code I am currently using to open and read the file. I don't want to open the entire email as a new workbook, so I can't use the workbook function. Set fs = CreateObject("Scripting.FileSystemObject") Set ts = fs.OpenTextFile("file.txt", ForReading, TristateTrue) check = True Do s = ts.Readline endlinepos = InStr(s, "//") Do While en ...Show All

• Bo Yu My mini Utility_Move class, please have some suggestions.

  Hello guys, I made a class called Utility_Move. Please give me some suggestions. If there is a better, cleaner, more performance way than mine, please tell me, thank you. 'Motive: Sometimes it is eaiser to debug when you use ActiveCell as current data record or parameter. '   When the macro stopped by exception or stop sign, you can determine the running progress by ActiveCell. '   And it is easier to say Up(5) instead of offset the row index, for me at least. 'Summary: The Utility_Move class introduce 3 sets of functions. 'First set, Up-Down-Right-Left simulate the key stroke of arrow keys. '   Additionally, Steps parameter allows you to repeat number of seps to that direction. '   Negative st ...Show All

• Quinn01 Extracting an embedded document within a cell in a table in a Word document

  Hello, I need to extract and save files embedded in cells of a table in a Word document. I have bookmarked my table, I already have a a macro to find the table based on this bookmark and parse the content of it, except the embedded files inside the table cells. Here is how I parse the cell content: 'I find my Table in the Word doc based on a bookmark Set idTable = RetrieveTable("myTableBookmark") XlRow = 0 XlCol = 0 WdRow = 1 WdCol = 1 'Copy each cell in XL Workbook (CharCleaner prevents multiple lines in a Word table cell to be interpreted as multiple rows in Excel) Do     ' --> HERE I NEED TO STORE ATTACHMENT ON A REMOTE FILE SYSTEM IF THERE IS ONE IN THE CELL     Wkb.ActiveSheet.Ce ...Show All

• Shihan vlookup

  Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata thanks Andy for the reply. i tried writing something similar to what you suggested but i get error. i wrote Public LookupValue As Range Public TableArray As Range Set LookupValue = Sheet3.Range("O2") Set TableArray = Workbooks(MyPath).Worksheets("Sheet3").Range("$A$5:$F$281") ............... error here The error is Run Time error 9 Sub-Script out of range can you please help thanks namrata ...Show All

• Pedro Felix How do you create a flashing cell

  I have been trying to use macros, very little success. My first macro question is how do you get it to run besides using F5 everytime I am also trying to create a flashing cell when there has been any text entered into that cell Please any help is greatly appreciated. i'm not quite sure if one can make a flashing cell, but if what you want is to highlight (by changing color of txt or background) the cell when certain text is entered, try using Conditional Formatting. Format --> Conditional Formatting Cool, I appreciate the help. ...Show All

• cooldoger Runtime Error '2001'

  I am using the following code to use an unbound text box to display the PM Name associated with the PM Number but for whatever reason, I keep getting the Runtime Error '2001' when I run the code. Private Sub Combo59_AfterUpdate() Dim StrName As String Dim strPM_Select As String strPM_Select = "[PM Number]=" & Me![Combo59] & "" StrName = DLookup("[Plan_Center_Name]", "Plan_Center_EPMC", strPM_Select) Me![PM Name] = StrName End Sub Please help. An explanation of the error would be great or if some one can tell me what it is that I am doing wrong that would be fabulous. Thanks! Access 2002 Windows Xp Pro Sp2 And Windows Xp Media Center Edition Sp2 (I tried both. Don' ...Show All

• Amde Coding MS Project 2003 VBA for multiple Languages?

  I have been coding some macros to run in MS Project 2003 that works fine when run under English language version but when used by a user in say France using the French MUI option fails miserably. I have a work around for: ViewApply Name:="Resource Table", singlepane:=True By seraching for a view with right screen attribute eg ' Get first resource table view For Each viewObject In myproj.ViewsSingle If viewObject.Screen = pjResourceSheet Then ResViewName = viewObject.Name Debug.Print "ResTab", ResViewName Exit For End If Next viewObject ViewApply Name:=ResViewName, singlepane:=True But now have run into the problem of: projapp.SelectTaskField Row:=1, Column:="Unique ID & ...Show All

• Alvin Kuiper Odd VB error when using subforms

  Hope someone can help me debug an Access form that is giving the following error; "An error occurred while referencing the object. You tried to run a Visual Basic procedure that improperly references a property or method of an object" The main form has a subform which is used to enter 'cross reference' information into a seperate table. The subform has two fields, "parent" and "child" the subform refereces back to the main form via the "parent" field. The error occurs when you start to type into the "Child" field in the subform, when a new record is created in the cross reference table I have another near identical subform on the same form that does a similar thing but uses a different cross ref table that works perfectly. Can' ...Show All

• Naveenkm Count and display in cell

  Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger Hello, Try the following code: You could ...Show All

• John Sudds - MSFT copy file into clipboard

  I want to copy the file into clipboard because: After I finished my lab test report, i have to save it into a test report folder, and then right-click the file and copy it, and then open the original test requesting email, and then copy it into the email, and then send. It is not convient, I wrote a VBA to save the report orderly and quicky, but I don't know how to copy the report into the clipboard so that I can paste it into my email or other folders I searched the internet, got one solution as below: '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Option Explicit ' Required data structures Private Type POINTAPI x As Long y As Long End Type ' Cl ...Show All

• rogupta Error 1004 setting print_area

  I've set up a bit of VBA that formats a variable length spreadsheet for printing. The problem is that after the first time it's been run, it throws up an error message 1004 "application defined or object defined error". This is the code that defines the print_area: ActiveSheet.Names.Add “Print_Area”, ActiveSheet.Range("A1").Resize(NumRows, 6) NumRows is a variable that I calculate further up to determine the length of the printed out bit I want to use. First time I run it, it works fine, after that it throws the 1004 error. I tried clearing the Print_Area using this code: On Error Resume Next ActiveSheet.Names(”Print_Area”).delete On Error GoTo 0 just before set print area bit, but I still ...Show All

• joss1974 VBA Module to DLL

  How does one convert a VBA Module into a DLL (I'm thinking this is an alternative to compiling into EXE file). Some of my VBA modules are quite complex and I would like to protect them with something other than a VBA Project password. ChasAA Thanks Jon, I'll have a look ChasAA The book "Professional Excel Development" by Bullen, Bovey, and Green covers this. Although the book concentrates on Excel, the VBA-DLL thing should be valid for any application that hosts VBA. There's a link to the book on my web site: http://peltiertech.com/Excel/xlbooks.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://Pelti ...Show All

• nwyork VBA and Access Noobie Questions

  1. Our software developer created a software using VBA as a module in Access, We would like to let people use our software for 30 days then disable it until they enter in the right key code. Is there a way to do this We currently use a key generator to give them key codes but it only limits the number of records our software imports. I don't know how to give them full access for a time period. Is that possible If so please share! :) 2. We had another software company tell us they would like to get information from our software using an API but they said we need to migrate our VBA app to VB.Net or something like that so we can create an API. They use Java and netbeans I think. Is this true, It this the only way What program do you suggest w ...Show All