I can send a corrupt Excel workbook to you if you want to test it out
yourself.
On Mar 13, 5:42 pm, mike wrote:
> Anyone??
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and link
hello dear;
this topic is already declared.i think u want connectivity or ado from excel
to to exces.
hope it will help
happy to help
:)
shyam
On Sun, Mar 14, 2010 at 7:12 AM, mike wrote:
> Anyone??
>
> --
>
>
Anyone??
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=28777955567
I've been messing with that code snip you gave me all day to no avail.
A couple of things are missing from my description:
1. I'm running from a button on an access form
2. Corrupt file is at "c:\san_corrupt.xls"
3. Good file is at "c:\san.xls"
Basic code where I'm at:
***
Option
I haven't been able to test this extensively, because I don't have a corrupt
file,
but with an incorrect file type, this works:
On Error Resume Next
Workbooks.Open Filename:="C:\temp\testfile.xls"
If (Err) Then
MsgBox Err.Description
Exit Sub
End If
Paul
_
