Posted
by Josh
on Stack Overflow
See other posts from Stack Overflow
or by Josh
Published on 2009-09-16T15:54:25Z
Indexed on
2010/04/20
11:03 UTC
Read the original article
Hit count: 223
Using CDaoDatabase defined in afxdao.h, how can I open up Excel 2007 (xlsx) files? I can open up Excel 2003 (xls) files using the connection string Excel 8.0;HDR=NO;IMEX=1, anybody know how I can do this?
Thanks!
© Stack Overflow or respective owner
as seen on Super User
- Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error,
"This workbook contains Excel 4.0
macros or Excel 5.0 modules. If you
would like to…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format.
I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed.
For this web project I'm building, the server doesn't have office installed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Any ideas why this code will not work?
Workbooks.Open Filename:="C:\a.xls"
Workbooks("a.xls").Activate
Worksheets("b").Select
Dim OutputArray(10, 10)
OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value
I'm trying to run a macro in one file (unnamed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Given the following workbook events:
BeforeClose
BeforeSave
Please tell me:
- The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving.
- What happen if user cancels one of the saving…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
While performing an upgrade, our in-house software started to report the following strange error. It is a C++ application talking to a remote postgresql database, defined through ODBC:
ODBC error state S1092, native error 0. [unixODBC][Driver Manager]Invalid attribute/option identifier
Both the…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem.
I've looked through the internet and found the following page that has some instructions on how I should proceed: http://www.ryslander.com/how-to-install-and-configure-db2-odbc-driver/…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm attempting to connect a ColdFusion application to a DB2 ODBC DSN.
Here's my error message:
Connection verification failed for data source: <DSN NAME>
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][CLI Driver] SQL30082N Attempt to establish connection failed…
>>> More
as seen on .NET 247
- Search for '.NET 247'
Hello, I am using the following connection to Query and Excel Spreadsheet: AConnectionString "Driver {Microsoft Excel Driver (*.xls)};DriverId 790;Dbq " & ofdSelectFile.FileName & ";DefaultDir c:\;" ASourceConnection New Odbc.OdbcConnection(AConnectionString)…
>>> More
as seen on .NET 247
- Search for '.NET 247'
Hello, I am using the following connection to Query and Excel Spreadsheet: AConnectionString "Driver {Microsoft Excel Driver (*.xls)};DriverId 790;Dbq " & ofdSelectFile.FileName & ";DefaultDir c:\;" ASourceConnection New Odbc.OdbcConnection(AConnectionString)…
>>> More
