Answer Questions

• Deepak Kapoor ReadAll reading in first 254 characters only. Help

  I have been using this code for sometime under previous versions of MSWord. However, the ReadAll function does work properly in Word 2002 with VB 6.3. I try to read in all the text in a text file and it will only read in the first 254 characters. Any help will be greatly appreciated. The following is my code: Const ForReading = 1, TristateFalse = 0 Dim fs, f, ts ChangeFileOpenDirectory gTemp_Dir Set fs = CreateObject("Scripting.F ...Show All

• DhawalMehta Require Basic Excel Sorting Macro To Be Made For Me!!! (Pretty Basic, But I Have NFI!)

  I was wondering if someone could make me some code for Excel 2000. I want it to start at C1, check if C2 is the same as it, and if not insert a row between. Then check if C3 is the same as C4 and if not insert another row. So if my data looked like the left list it would turn out like the right list. Apple                       &nb ...Show All

• Amirc Progress Bar

  Hi all, I am using a macro in excel and i added a Form too. i added the form through the excel workarea code (insert ->form) i have 2 questions: 1. can i add a form from VB, is there any difference between a form from VB and a form from Excel VBA 2. i want to use a Progress Bar on the form. i found it but i dont know how to use it. any help thanks, S Jon Peltier wrote: ...Show All

• Daniel Moth Security Warning

  I’m using an ‘Ole1.CreatLink (Path)’ to a .WMD video file, followed by DoVerb to start the video. Before the video will start, Windows (XP service pack 2) gives the Open File – Security warning as though I was accessing a file from the web. This destroys the flow of my product in the eyes of the user. How can I prevent this The .WMV file is just a file I created using Microsoft Movie Maker. Per the support engineer: ...Show All

• ?二 excel vba

  Hello, I plan to extract the document's pages. but it's not working properly: Dim wsList As Word.Application wsList.Cells(rowList, 8).Formula = wb.BuiltinDocumentProperties(wdPropertyPages).Value when when i run the code, all word documents return "2" instead of the real pages number; and some excel file don't even return the number. What's wrong with the code Try this: Fir ...Show All

• SAMI_12 VBA WORKSHEET

  COMPILE ERROR END IF WITHOUT BLOCK IF Sub EnterDates() Columns().Clear Dim EilDownloadSheet As Worksheet Set EilDownloadSheet = Workbook.Worksheets("Name of worksheet") Dim startDate As String, stopDate As String, startCel As Integer, stopcel As Integer, dateRange As Range On Error Resume Next Do startDate = InputBox("Please enter start Date: format (dd/mm/yy)", "Start Date") If startDate = &q ...Show All

• solution dll jump to other slides of a ppt by selecting slide number from a combobox

  can anyone tell me how jump to other slides of a ppt by selecting slide number from a combobox how will u first additems to the combobox and then how will you switch to the slide number selected in that combobox thanks in advance amzzz Hey thanks for trying atleast!! I wasnt hoping anybody would respond.....but thanks Actually wat I came across is all vba components come live only in slideshow mode I dont know ...Show All

• Kedar OUTLOOK When trying to open Outlook, I get the following:

  Microsoft Visual C++ Runtime Library Runtime Error! Program:C:\Progra~1\Micros~3\Office10\OUTLOOK.EXE Any ideas Thanks I'm having the same problem - it started when I installed Office XP Professional on my new computer that already had a trial version of Office 2003 on it. After that, Outlook crashed before opening completely. The Microsoft Knowledge base directed me to uninstall Off ...Show All

• 51ChevyTruck printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro

  Hello all! I'm Jim from Western NY. Forgive me if I have posted in the wrong forum. If I have, just let me know and I'll comply. Here's my question: I am wanting to develop a macro for excel which will read (from a worksheet) a list of hyperlinks to pdf, .doc, and .xls files and print them using the appropriate application ( acrobat, word, excel). Theoretically, I know I would have to use some kind of for-next and/or case s ...Show All

• rpk_isv format field

  hi all how can i use the format function such that the number of dicemal points depends on value read from table any ideas thnx Per the support engineer: We can use Format function to do it. The sample shows how to format a string of a format from a variable. Dim s As String Dim y As String y = "#,##0.00" s = Format(4313413.9234, y) MsgBox s ...Show All

• morlando AppHung in SQL Server (SQLEXPRESS)

  Good morning, the below is the error I keep getting each time I try to create/connect to a database using Visual Studio 2005.  I upgraded from VS 2003 Professional to VS 2005 Professional.  My OS is XP.  Programming language is C#.  szAppName : devenv.exe szAppVer : 8.0.50727.42 szModName : hungapp szModVer : 0.0.0.0 offset : 00000000  Hi Brent, Here's the latest from the su ...Show All

• PrimeTime Application Error

  Hi experts, We have an application written in VBA. The application is failing with the following log entry in the event log. Faulting application: appname.exe Faulting Module: VBE6 Version: 6.4.99.72 Fault Address 0x000dc6f2 Event ID: 1000 The application is running on Windows XP SP2 with Office 2003 SP2. Help would be much appreciated. Thanks Steve Hi Lee, The error dialog box is a standard Microsoft ...Show All

• Pabs Integer values cannot be gathered when reading Excel file

  Hi, I have a problem while trying to get Integer values in an excel sheet. Here is the code: I can gather string values, but on the dataset the integer values cannot be gathered. Thanks for your help...         Dim MyCommand As System.Data.OleDb.OleDbDataAdapter         Dim MyConnection As System.Data.OleDb.OleDbConnection         MyConnection = ...Show All

• Dakiar VS2005: Any more CTP or RC builds to come?

  VS Release Team, I've searched these forums and have even researched a number of blogs, but I haven't been able to find out when the next VS2005 drops will be. I'm currently using the July CTP for VS2005 Pro, and am tracking a number of issues with my current development project that I'm hoping will be resolved in future RTM builds, either within Visual Studio itself (e.g., Forms designer), or as a result to fixes in the Framework. Could somebod ...Show All

• MarieG Execute an access DB macro from VB.NET

  Hi, I am having problems trying to execute an access DB macro from my VB.NET APP. Any help is welcome. Thanks Mike Hi, Thanks for the code. I have it working now. The only part that I could not get to work was the "CloseCurrentDatabase"; however, the quite command worked great. Thanks Again Mike Mike, One way this can be done is to include the reference to Microsoft Access obje ...Show All