Saving To A Network Drive

**kreiny** · 01-06-2009, 06:03 PM

HI All,

I am sure this has been posted before. I have tried searching with little luck.

We have a form that is completed by our employees and emailed to a central group email address that up to 8 employees within our team can access. When one of our 8 team members open the file sent they need to add comments to it and then save it in a central directory on one of our network drives.

Now the problem I have is that we all have the network drive mapped to a different letter.

Is there a way that I can have a macro (see below for current macro that does not work) save to a network path and not a drive letter.

Please Login or Register  to view this content.

Any help appreciated.

Thanks

Andrew

**jasoncw** · 01-06-2009, 06:23 PM

Andrew, I am confused. The line in your code:

Please Login or Register  to view this content.

is saving to a network path, and not a drive letter, as you are request. Is this not working for you? If you are simply asking if it will work, the answer is yes.

Jason

**Kenneth Hobson** · 01-06-2009, 06:24 PM

Did you try:

Please Login or Register  to view this content.

You may need to append quotes on each end.

**kreiny** · 01-06-2009, 06:39 PM

Originally Posted by jasoncw

Andrew, I am confused. The line in your code:

Please Login or Register  to view this content.

is saving to a network path, and not a drive letter, as you are request. Is this not working for you? If you are simply asking if it will work, the answer is yes.

Jason

Hi Jason,

Thanks for the quick response.

It is not saving the file to the network drive. It is saving to my C:\Documents and Settings\akn\My Documents\ folder.

Any suggestions??

Thanks

Andrew

**shg** · 01-06-2009, 06:56 PM

Changing directories doesn't work across drives; you have to change drive first. From Help:

The ChDir statement changes the default directory but not the default drive. For example, if the default drive is C, the following statement changes the default directory on drive D, but C remains the default drive:

ChDir "D:\TMP"

But it shouldn't be necessary. Try just

Please Login or Register  to view this content.

**VBA Noob** · 01-06-2009, 07:03 PM

Just to add a useful link on the subject

http://www.dailydoseofexcel.com/arch...6/21/unc-path/

VBA Noob

**kreiny** · 01-06-2009, 07:19 PM

Originally Posted by shg

Changing directories doesn't work across drives; you have to change drive first. From Help:

The ChDir statement changes the default directory but not the default drive. For example, if the default drive is C, the following statement changes the default directory on drive D, but C remains the default drive:

ChDir "D:\TMP"

But it shouldn't be necessary. Try just

Please Login or Register  to view this content.

Thanks,

While this saved to the correct directory it did not save with the correct file name being referrenced from cells within the spreadsheet.

**shg** · 01-06-2009, 07:23 PM

So debug the code as the string is being built.

**shg** · 01-06-2009, 07:35 PM

Also, if you haven't already, put Option Explicit at the top of the code module.

**kreiny** · 01-06-2009, 07:51 PM

Hi All,

Thanks for all the help.

This now works using the following code.

Please Login or Register  to view this content.

Once again thank you all.

Andrew

**shg** · 01-06-2009, 07:53 PM

Would you please mark the thread as solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

Saving To A Network Drive

LinkBack

Thread Tools

Rate This Thread

Display

Saving To A Network Drive

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions