Problem with creating .xls by macro

[tallpaul]

This is what i have got:

A form that when closed runs a macro.

This macro runs a query that outputs the queried data to a spread sheet.

My database is stored on a file server, and is accessed across the network by several people.

Everything runs fine when the form is open and closed on the server but when i access the database from another machine and close the form the macro fails becuase it has the wrong pathway. I.e. D:/database/info.xls. what i need is a network path. The trouble is, is that the "output file" property in the action arguments pane of the macro design window suggests that it needs the full path to the .xls file.

Can this be done. I have tried a few things like "http://server/Updatewebsite/MessageInfo.xls

but it cant be found.

P,.ease help

Thanks Paul

 

[crosmill]

Your server will have solid path and a virtual path name, the virtual path probably won't work forthis which is what i think is the problem your encountering.

I'm assuming you on a windows network....?

this is how it's set up on our network but should hopefully help you out

open explorer and navigate to 'My network places' then 'Entire Network' then 'Microsoft Windows Network' then 'Your Company Name' then 'Then network you want'

our files system has the path \\pp-fs where pp is the company name and fs is file system.

hopefull this is what your looking for.
I've got a hunch that macros won't let put networks into the path, you may have to do it in VBA

Let me know how you get on