SOLVED!FIND DATABASE IN CERTAIN FOLDER

ROBINSYN

Board Regular
Joined
Aug 19, 2002
Messages
188
CAN YOU REFERENCE A DATABASE BY TELLING EXCEL TO LOOK FOR IT IN THIS FOLDER ONLY.
I NEED TO INSTALL A TEMPLATE AT 26 SCHOOLS AND USERS WILL NOT BE SAVING TO SAME LOCATION NAMES. CAN I TELL THE WORKBOOK TO LOCATE THE DATABASE AND IF SO CAN I ALSO USE THIS REFERENCE IN A FORMULA FOR FINDING THE NEXT NUMBER ON DATABASE FILE.
This message was edited by ROBINSYN on 2002-10-27 18:09
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

ROBINSYN

Board Regular
Joined
Aug 19, 2002
Messages
188

ADVERTISEMENT

No the schools are not networked. We use to be bbut our admin is streamlining supposively and we lost a great system. I have to create Purchase Order, Leave Forms, Timesheet and Budget Templates that all require a database as reference for all items saved. Each of the above is in a seperate workbook. I seriously need help but am new to excel and can not seem to find a solution to maske this transition easy.
 

ROBINSYN

Board Regular
Joined
Aug 19, 2002
Messages
188

ADVERTISEMENT

Yes, all schools are online.
 

zacemmel

Well-known Member
Joined
Apr 29, 2002
Messages
636
I would suggest setting up a centralized database on the internet with a webserver. It would make things A LOT easier. The great thing about this is, if you have the hardware, ALL of the server software is completely free :) These servers can handle a much bigger load than little old Excel can and are much more efficient.

http://www.apache.org
http://www.mysql.org

Take a look!

Questions?

Http://www.excelquestions.com
 

Forum statistics

Threads
1,144,148
Messages
5,722,787
Members
422,458
Latest member
Muirzy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top