Search in Excel with Access

[iskov]

Hello Access programmers!

I have gotten the task to solve a problem our spareparts salesman has.

He has a veeeery long database stored in excel, previously he had a function to search from the different fields through an Access function that pops up when he opens the Excel document (Please see the attached screenshot)

I am not capable of doing this myself so I ask you guys kindly to help me out?

How do I make it possible with access to search in an Excel document???

EDIT: UPS! attached screenshot

Kind regards
Iskov

 

[iskov]

Here it is

What it says is:

Unable to find 'F:\\WINEXEL\KONSTRUK\KONSBASE.XLM'!Formularstart

 

[CJ_London]

Don't think I can be much help but some obvious checks to make

is the file in the right folder? (F:\\WINEXEL\KONSTRUK)
is the file named KONSBASE?
is the file of type .XLM?
does the file contain the function called Formularstart?

 

[iskov]

Hello CJ, thanks for the reply!

The Excel database is called Konsbase yes, I tracked the folder where the files are located, I took two screenshots.

I am sorry but I am really lost, I just want to help my college out.

An employee made an Access function that allowed him to search in his Excel database many years ago, recently it stopped working, I have no idea what coursed it - does anyone know how to make anything similar??

Iskov

 

[CJ_London]

Sorry, I'm out of suggestions - it looks like everything is there.

If it was working and has now stopped, this implies something has changed - you need to ask your colleague so detailed questions about what changed just before it stopped working

 

[iskov]

Let me just try to understand - if you know ofcourse CJ - I am rookie at this, did the database work this way:

Excel database with an Access macro, or is it an external Access program that he made back in the days?

Sorry for my lack of understanding, I am not the right guy to solve the problem , i guess i just know alittlebit more than the colleagues working with it :banghead:

 

[CJ_London]

from what you have provided, I can't tell - but it is trying to run a macro or vba code in KONSBASE.XLM

 

[iskov]

from what you have provided, I can't tell - but it is trying to run a macro or vba code in KONSBASE.XLM

Where do I open the VBA coding in Excel? Macros list seem to be empty - or is it not the correct one i opened?

 

[iskov]

By the way I will say it seems the documts are maybe 10 years old, is it possible the coding is simply out of date with newer versions launched?

 

[CJ_London]

age shouldn't matter - but if you have upgraded from Excel 2003 or earlier to a later version you may have issues. - Do you have an excel expert in your office who can help?

Where do I open the VBA coding in Excel?

depends on the version but there will be on a developer tab on your ribbon. If you can';t see the developer tab, you need to go to file>options and add it to your ribbon.

I'm due out in a few minutes so will not be able to respond again until much later this pm

 

[iskov]

Thanks for the help CJ, I found it.

I put an Excel expert on the job, maybe he knows how it works, but it is VERY old - from 97 I think so I think it miiight be due to outdate now that we are using 2013.

If anyone has anything to add I am all ears!