Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL SQL Problem
hi can anyone help me with this problem? I have a excel raw datafile call holdmail register.xls which is protected with password when open. When i use another excel to query using ADODB connection as show below Dim cn As ADODB.Connection Set cn = New ADODB.Connection With cn ..Provider = "Microsoft.Jet.OLEDB.4.0" ..ConnectionString = "Data Source=C:\Documents and Settings\43230121\My Documents\Working folder\Holdmail\Hold mail register.xls ;" & _ "Extended Properties=Excel 8.0; User ID=HSBC; password=holdmail" ..Open End With It show me an error as show below Cannot Start Application. The Workgroup information file is missing or opened exclusively by another user The problem is that the file was not open. Can anyone help me ? Thank you, -- brucelim80 ------------------------------------------------------------------------ brucelim80's Profile: http://www.excelforum.com/member.php...o&userid=32244 View this thread: http://www.excelforum.com/showthread...hreadid=561987 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL SQL Problem
I know that older versions of Excel had some "database" capabilities that have not been continued. Perhaps this is the cause of your problem. -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=561987 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL SQL Problem
what happens A - if you try to open it as a spreadsheet - ie do you get the same error? B - if you try to open it as a spreadsheet in code? might help to diagnose the problem -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=561987 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL SQL Problem
hi i have encountered the same problem when i create a new workshee protected with password. The password is used to open the excel file. When i wrote another excel to query using ADODB Connection. It wil give me the same error. When i open the raw data, it working fine after entering the passwor -- brucelim8 ----------------------------------------------------------------------- brucelim80's Profile: http://www.excelforum.com/member.php...fo&userid=3224 View this thread: http://www.excelforum.com/showthread.php?threadid=56198 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL SQL Problem
Theses articles may help: http://support.microsoft.com/?scid=kb;en-us;300699 http://www.programmingtalk.com/showthread.php?t=7763 http://experts.about.com/q/Visual-Ba...nnection-1.htm sorry haven't got time at the moment to look further -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=561987 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) |