Search results

The Problem: I have an unattended database (triggered by scheduler) which imports excel files into access after checking the contents and format, but the process halts at "appExcel.Workbooks.Open" if it is unable to open the file - such as a zip file changed from .zip to .xls (I'm not...

I have an app which validates and imports excel files into Access with a module that checks the Tab names then sets certain columns to "General" format. The first file works ok then the second call of the module gives Run-time error 91 - "Object variable or With block variable not set" Module...

I have created a function for checking the Tab names in Excel workbooks before importing them (despite instructions, users will change the tab names before sending their monthly returns!) ***************************************** Function fncXLTabCheck(strPath As String, strImpFile As String)...

Probably a very simple question to the cognoscenti! I am creating a new table (access 2003) by importing an excel spreadsheet, processing the data then deleting the table for the next import. The spreadsheets come in from worldwide users and shuld be in a standard format, issued centrally...