Answer Questions
teomanx suppress content overwrite message in TextToColumns?
My big problem is, that I use the TextToColumns to populate several columns. Before calling it, I clear the target area with range.clearcontents. It works 99% of the cases, but in some cases it asks 'Do you want to replace the contents of the destiantion cells ', though nothing is there at all. I've found out that in some cases if I change the formatting of the target range it is ok. Sometimes not. This messages is not acceptable, as I run the t ...Show All
Ernee Problem about the "Find" function in VBA editor
Hi all~ When I use "Ctrl F" or choose "Find" in VBA editor, the "Find" pop-up window close and do nothing after I press the "Find Next" button Can anyone help me I use MS Office 2003 and the VBA editor version is 6.3 Thanks! Per the support engineer: Would you please ask out ISV to check the language of the system 1. The language of the Win ...Show All
Shazen Custom file description keywords: read/write in VBA via API
In Windows Explorer, I can select a file, go to properties, and under 'summary', I can input keywords into the description, for use later when searching for the file. I would like to be able to read/write these file keywords via VBA. I assume I need to access the Windows API, but more than that, not sure what library etc. I would need to use. Can anyone advise me how do to this & ...Show All
bakerb How to open Access files and export them to Excel
I need to open multiple Access files and export several colums to Excel. The problem is that the file extension is not a typical access one and that I need to choose a table from several tables for each file. Then I need to merge into one excel document. Any help would be appreciated, thanks. I'm sorry I've never heard of .alg files before. If you can find a connection string that lets you access the ...Show All
jko Form Requery
I have a command button on a form to create new records for the data shown on the form. When the code finished I want the form to have the new record available. I have this code at the end of the button code: Forms("frmDocumentDetail").Requery It does not work. The records do not update unless I exit the form or do something like hit the sort records button. TimD Nope, did not work. Thanks for the r ...Show All
LearningVisualC2005 Data Sources in Business Score Card Builder fail to connect...
I'm attempting to get BSC 2.0 to work with SQL 2005 for a singel server instance. I've installed the prerequisites per the planning and administration guide. I have built processed and deployed an analysis services project to SQL 2005. The problem I'm currently running into is that the Data Soucre in Business Score Card Builder fails to connect to the database. In fact it fails to retrieve any databases from the defined server. I've tried (local ...Show All
RandyTM VBA XmlMap.loadXML problem - repeating call
Hi all, I have the following XSD load to XML Source of excel: < xml version="1.0" > <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs=" http://www.w3.org/2001/XMLSchema "> <xs:element name="stock"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="quote"> <xs:co ...Show All
55Jim Assign range to array
I am trying to assign a range to an array, but I keep getting a "Subscript out of range" error. I am using the following code sample. Dim Asset As Variant Dim LinesPerAsset As Variant Asset = Worksheets("Asset_Corr").Range("B5:AY5").Value LinesPerAsset = Worksheets("Asset_Corr").Range("B57:AY57").Value This is supposed to fill a 1 by 50 array according to what literature I can find. ...Show All
MSP work localy with database
hello, i have a database on the network and when i run a function with many queries it works really slow. is there a way to copy the database to the local computer, make the queries and continue working on the database on the network other users also work on the network database so it's important that the file stays linked to that DB. please help... refael Hi, You can create linked tables to SQL Server that are accessab ...Show All
Jens Kohler Problem with MS Updates on New Dell
I have a brand new Dell XPS Fully Loaded and Upgraded, but there is one MS security update that will never load. I have Windows XP Media Center Edition 2005. I also have PC-Cillan Micro Trends Antivirus/Firewall Internet Security Protection. Below is the update that I am not able to get as it fails every time. Security Update for Microsoft .NET Framework, Version 1.1 Service Pack 1 (KB886903) Failed to install The other issue I have: ...Show All
fasttrack Excel Solver VBA Problem
I have a problem with programming Excel solver using vba. I have the following micro in a workbook named "Book2.xls": Sub Macro1() ' ' Macro1 Macro ' Macro recorded 11/8/2005' SolverOk SetCell:="$H$10", MaxMinVal:=2, ValueOf:="0", ByChange:="$G$10" SolverAdd CellRef:="$G$10", Relation:=3, FormulaText:="$G$11" SolverOk SetCell:="$H$10", MaxMinVal:=2, ValueOf:="0", ByChange:="$G$10" &n ...Show All
Miguel Ortiz Falc&#243;n How to open Access files and export them to Excel
I need to open multiple Access files and export several colums to Excel. The problem is that the file extension is not a typical access one and that I need to choose a table from several tables for each file. Then I need to merge into one excel document. Any help would be appreciated, thanks. I'll move you thread to the VBA forum at the very bottom and you are likely to recieve help there. I'm s ...Show All
vthacker (Vitual IP Problem ) Web Farming using NLB in windows server 2003 Enterprise Edition
Hi All, We have a requirement of setting up web farm for our application. I tried setting up with the following setup. We have setted up two Windows 2003 Enterprise edition servers both having complete application with IIS configured. I have followed the instructions for setting up the Network Load Balancing utility (NLB) comes with Win2k3 and configured two clusters. I have configured correctly with a virtual ip being used by two nodes an ...Show All
tfm_mike CRM 3.0 doesn’t save my settings
Hi, I’m having another problem in CRM 3.0. When I change any setting in the CRM system, everytime that I clicked in the OK button it should save my new settings and that’s not happening. How can I solve this Thanks, Hi, The application pool is running with the account of the domain\administrator, because i had some problems during the instalation. I f i used tthe Network Service account, it would not install. ...Show All
M D L VBA Syntax
Hi, I'm a newbie to VBA. Can anyone recommend me on the websites that allow me to learn the syntax of VBA Could you also recommend me some useful websites for VBA beginner (an absolutely beginner with zero knowledge ) i don't understand the source code that i've come across. Thanks alot. Hi Richard, Thank you very much for your advice. I've borrowed "VBA for the dummies from the libra ...Show All