Does anyone know of a good Excel Forum?

Question

Post reply

Does anyone know of a good Excel Forum?

Welsh Corgi

SSC Guru

Points: 116520
More actions
January 2, 2012 at 8:35 am

#248924

Does anyone know of a good Excel Forum?
I inherited some monster Excel WOrkbooks with a lot of SQL Connections and VBA Code.
Nobody here knows to to alter it because it has a lot of dropping creating sheets, moving sheets around.
The code is scattered, anything but straight forward and very cryptic.
If I could kind a forum that would be great if not then I have to go it alone (again).:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gosta Munktell SSCertifiable Points: 6004 More actions · Answer 1

Try:

http://peach.ease.lsoft.com/archives/excel-l.html

I have been working a lot with Excel and SQL connections.

But it will be hard to help you to wind up spagetticode without

the code and possibilties to test it in real.

/Gosta

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Thanks Gosta.

By chance do you when you create a new connection to SQL Server how do you specify where the connection is used?

I tried defining a range and I get an error that the connect is not used in this workbook?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Gosta,

It turns out that I belonged to that list when I was converting Lotus Notes to Excel for a Year 2K Project (12 years ago).

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gosta Munktell SSCertifiable Points: 6004 More actions · Answer 4

Dear "Dog"

I usually use ODBC and ADO or OLE-DB and ADO as connections with VBA.

How do you specify a connection?

//Gosta

pdanes SSCrazy Eights Points: 8502 More actions · Answer 5

pdanes

SSCrazy Eights

Points: 8502

January 5, 2012 at 6:32 am

#1428965

http://www.mrexcel.com/forum/index.php

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Gosta Munktell (1/3/2012)
Dear "Dog"
I usually use ODBC and ADO or OLE-DB and ADO as connections with VBA.
How do you specify a connection?
//Gosta

That's how I usually do it but I inherted an Monster of an application that a contractor created years ago that no one wants to work on because the VBA Code is so long, confusing and complicated.

In this case I modified an existing Excel Connection (Data Connections).

I belive that it is defined an an odc and you have the option of storing it in your workbook.

I would used another method it was much less effort to keep it the same because of all of the formatting, etc contained in the VBA Code.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/