Answer Questions

• JCExTel MODI Port

  I have some questions: 1.- How to distribute MODI Port with my application 2.- Found MSM (module merge) 3.- How to install "Microsoft Document Imaging Writer Port", without CD office 4.- That files use the MODI 5.- The files .MDI is better of PDF ! Tks a lot, Is it necessary to install all the applications of MS Office to activate MDIVWCTL.DLL Also, how can I insta ...Show All

• Jerry Zhang InputBox() in MS Word form textbox.

  I would like to insert a InputBox() prompt with the text being entered into protected Word form Textbox. I understand the InputBox() code and that the macro will be going into the ''Run Macro On Entry' dropdown box. Can someone point me in the right direction on how to do this. I am new to VBA. The support engineer has written a document with a “Show” button appended in the document, you can click it to show ...Show All

• MAdaikkalavan Problem sorting dates!

  Hi, apologies if this is the wrong thread, I have Access 2000 and am running a queyr that conaints the following field: Date, Time, Site, Data Date is in the format dd/mm/yyyy, time is hourly from 00:00-23:00, Sites are Various fields and Data is the values for each hour. The day format I work in runs from 06:00-05:00 the foillowing day, thereby for running over two days. This wouldn't be a problem if it wasn't for the site field. ...Show All

• st23am23 Help required.....

  Can someone help me please I am trying to create a VBA User form to open up individual Spreadsheets rather than having to have all the sheets open (as with a workspace). I have designed the user form and now need to code the command_buttons. However I am stuck with what code I need to use. If it helps, I need to program 7 buttons, 6 will open spreadsheets and one will open a MS Project file. This is fairly urgent as I have to have ready ...Show All

• gotelin (0x800A03EC): Paste method of Worksheet class failed

  I just recieved this error message when i try to copy and paste some text using the right click method in excel. Any ideas why (0x800A03EC): Paste method of Worksheet class failed Hi Mike, The engineer needs additional information before he can investigate your issue: As there is too little error information of the issue, we can’t find useful information to resolve the issue. Would you please ask our ISV ...Show All

• Don McCrady unable to register comsvcs.dll

  Hello, I have a VB application that has been evolving for several years. I have installed and used it on work stations running win95,98,NT,2000 and XP. The developement computer has evolved from a win95 to win2000 machine. Recently, I have begun to experience "an error occured while registering the file ... comsvcs.dll" when installing it on a win98 work station. winxp installs fine. I have always installed dcom98 and mdac prior to the ...Show All

• VB_Programmer About Jet WorkSpace

  Started by ranero at 05-13-2005 9:47 AM. Topic has 0 replies. 05-13-2005, 9:47 AM ranero Joined on 05-13-2005 Posts 1 About Jet WorkSpace I am new to VBA. I am trying to Clone a table and I need the Jet WorkSpace but I don't know wich Library I have to load for have it available. I try a lot of them but it doesn't work. Does anybody know thanks h ...Show All

• firstspirit VBA Excel Macro to delete rows based on column conditions

  I am trying to write a macro that will take a file, open it up then based on conditions in 3 colums delete the row. So if the value in Colum Q,T & W is zero then that row will be deleted. All three columns have to be 0. so far I have: Sub Text_File_to_Excel() ' ' Text_File_to_Excel Macro ' Macro recorded 4/13/2004 by C4TXL ' ' myFile = Application.GetOpenFilename("Text Files,*.txt") Workbooks.OpenText _ FileName: ...Show All

• Mauro Regio Macro to sort an Excel column

  Hello, I am trying to create a macro to sort a column starting at a cell activated by the user. I programmatically select the range of cells starting at the selected cell over which I want to do the sort on. But I am stuck on what to do for the following snippet of code: Selection.Sort Key1:=.Range(<something>) ... I don't know what to stick in place of <something> to represent the selected range of cells in the column ov ...Show All

• Neha Goyal Closing a dependent file in Excel97

  I am trying to set up programming for an Excel97 spreadsheet. Because the file (call it Alpha) takes a long time to save, I want to put the code in another file (call it Beta) and call it from Alpha. I have that figured out, and the references set up. The problem is that I want Beta to close automatically when I close Alpha. I tried putting a Close command in the Before_Close subroutine, but then I get an error message telling me that I cannot c ...Show All

• gliffton To dim or not to dim

  I am writing some code in VBA without using the Dim command for many variables. It seems to be working fine. Other than perhaps a more efficient allocation of memory, what are the advantages of declaring the type of a variable prior to use You can do that because you haven't added the Option Strict or Option Explicit option to your macro file. When these aren't used then you can just use vari ...Show All

• vaidas Speed up processing time Excel Macro

  I had some questions about Office and performance. I would like to figure out what specifically will affect the runtime of macros in Excel. Currently this user has a Dell Optiplex GX520 with the following specifications: IntelR PentiumR 4 Processor 640 with HT (3.2GHz, 2M, 800MHz FSB) 1.0GB DDR2 Non-ECC SDRAM,533MHz, (2DIMM) 80GB SATA 3.0Gb/s and 8MB DataBurst Office 2000 Pro She is running macros in large Excel spreadsheets (30 - 60MB) that ...Show All

• Mohammed Fadel Shatnawi Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• Little Shell What is ISV

  Im sorry.. can somebody open that what ISV is sorry for that silly question : ) thank you Exact Definition: http://whatis.techtarget.com/definition/0,,sid9_gci214047,00.html Regards, Vikram I take it as 'Independent Software Vendor". I work for myself. I create and sell software, so I think of myself as an ISV. To this end, I'm going to an ISV Community Day in Brisbane, Australia today. I'll let you know if I'm wrong. - Simon ...Show All

• Friedrich von dem Storm InternetExplorer, NavigateError event not firing

  Hi, I am having trouble with the WebBrowser control, the server is sending back an error code but the navigateerror event is not being fired for some reason. I am trying to upload a file using the InternetExplorer control in MS Word . I have IE 6 installed. Is there any other way of finding out the response The code is below, thanks for your help. Option Explicit Private WithEvents WebBrowser As InternetExplorer Private strResult As String ...Show All