Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need new idea for universal path
Tod,
Make sure you are using unc naming in your hard coded path. I.e. rather than "f:\foldername\filename" use \\servername\foldername\filename. Good luck "Tod" wrote in message ... My former solution to this problem has to change. The former scenario: I had a workbook in a folder on a server. In that same folder I had a database. In my ADO code I had my connection to the path and database name. Problem is that when users tried to run the code from the workbook, the connection string failed because the path (for them)was incorrect. The solution was to put the path as ThisWorkbook.Path and then the database name. New Scenario: As the list of files on the server has grown, I've organized everything into subfolders. Now the workook and database are on the same server, but one is in a Reports folder and the other is a Database folder. So ThisWorkbook.Path will not longer work as a part of the connection string. So... if you are still reading.... here's what I need. I want to be able to run the workbook and it's ADO code from within the server. That's easy enough. I can hard code the path to the database. BUT.. I also want select users (as a back up in case I'm 'hit by the proverbial bus') to be able run the workbook from a folder on their computer that I've shared to a folder on the server. The hard-coded path for the connection string will not work. Does anybody understand what I'm talking about? tod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to turn on universal scrolling? | Excel Discussion (Misc queries) | |||
Universal formula to all cells | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
Universal formulas for any given row | New Users to Excel | |||
Need new idea for universal path | Excel Programming |