How to bypass Open macro when launching Excel 2003
Wed, 5 Apr 2006 12:50:26 -0400
Hi everybody !
Used to program Excel macros (VBA) on window's 2000. I have several
applications progammed to get rid of most menu bars and others at opening
and construct by programmation my owns for the benefit of the user.and for
protection of the programming
When application needs to be updated (onc ...
|
Connection string
Tue, 4 Apr 2006 08:19:12 +0800
I am connecting to a SQL Express database from Excel 2K.
I have three connection strings examples. The first two work however the
third was the one I wanted to use as I do not want to specify a local db.
These two work fine:
strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=IPS;
Trusted_ ...
|
msquery odbc --> excel repeats query on return
3 Apr 2006 08:48:17 -0700
[excel 2003 sp2, postgresql odbc driver 8_01_0200]
When I use MS-Query to get data from my postgresql server via odbc,
the query succeeds and displays in the msquery window. But when I say
"return data to excel" it re-runs the query. Is there some way to make
it
just pass what it has instead of re-executing ...
|
Import from SQL Server using an embedded formula
Fri, 24 Mar 2006 17:19:58 -0500
I'm trying out importing data into excel from an SQL server database.
So far it's great but there is one thing I can't do - calculating an
embedded formula.
The query looks something like:
SELECT 1 AS Quantity, ExportPrice, '=RC[-2]*RC[-1]' AS Amount FROM
tblPriceList
Refreshing puts the correct v ...
|
Querying Excel?
Wed, 22 Mar 2006 17:19:21 -0600
Hi,
I was just asked to create an Excel workbook with data queried from a SQL
Server and an Excel workbook. I know how to use querytables to query SQL
but is it possible to also query an Excel worksheet? I basically want to
use the Excel worksheet as another table, one of the columns will work as a
ke ...
|
China ZhongZhan Aids Mei Mei
Tue, 21 Mar 2006 08:09:54 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
China ZhongZhan Aids Mei Mei
Tue, 21 Mar 2006 08:09:48 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
|
|
Macro for operations with external files
Sun, 19 Mar 2006 08:51:44 +0100
I need to get files from a dir and copy them in another dir, reading their
name from a list in an Excel sheet.
The problem is that I can open them from inside Excel, but I don't know how
to phisically copy in the new dir.
Any help well accepted.
Thanks.
Angelo
angelo.ferra@tiscali.it
...
|
China ZhongZhan Aids Mei Mei
Sat, 18 Mar 2006 18:17:41 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
China ZhongZhan Aids Mei Mei
Sat, 18 Mar 2006 18:17:36 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
