Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again
If this does not work, re-register Excel
--
Gary's Student
gsnu200708
"Guy Coleman" wrote:
Since defragging my hard disk I have been experiencing problems loading my
Excel files. If I load a file by double clicking on it from within my My
Documents folder Excel starts and loads an empty page - the file association
is OK. If I start Excel and then go to File/Open the Excel file loads
perfectly. Does anyone have an idea as to what is happening?
Re: Method Columns of object IImexGrid failed ... and import specs aren't available when importing from Excel files.... you can set the Import Spreadsheet Wizard... (microsoft.public.access.externaldata)
Re: Import Several excel files into Several Access Tables ...Dim strPathFile As String, strFile As String, strPath As String ... ' Change this next line to True if the first row in EXCEL worksheet...strFileName must contain the entire path; ... I was hoping to use this to import several Excel files into a few Access ... (microsoft.public.access.externaldata)
Re: Import Several excel files into Several Access Tables ...Dim strPathFile As String, strFile As String, strPath As String ... ' Change this next line to True if the first row in EXCEL worksheet...strFileName must contain the entire path; ... I was hoping to use this to import several Excel files into a few Access ... (microsoft.public.access.externaldata)
Re: VB6 works fine on XP but not Vista - Error 445 ...FSO is generally NOT recommended, as it's very slow and consumes a lot of memory. ... Typically, the functions built into VB are enough to do the job, but they're fairly low-level, so if you're trying to do something like a recursive search, you'd have to write the code yourself. ... my program searches a selectable drive and finds certain excel files.... It then opens each file serparately in Excel and extracts info from each based on certain criteria. ... (microsoft.public.vb.general.discussion)
Re: VB6 works fine on XP but not Vista - Error 445 ... The API isn't a single entity, it's actually a collection of libraries. ... Typically, the functions built into VB are enough to do the job, but they're fairly low-level, so if you're trying to do something like a recursive search, you'd have to write the code yourself. ... my program searches a selectable drive and finds certain excel files.... It then opens each file serparately in Excel and extracts info from each based on certain criteria. ... (microsoft.public.vb.general.discussion)
