Prgrammatically save a file to a specific folder on a network drive

  • Thread starter Thread starter Christy
  • Start date Start date
C

Christy

In a macro, I would lke to programmatically save a file to
a specified folder on a network drive. Please advise.
 
Christy,

The command is:

ActiveWorkbook.SaveAs "PathAndFileName.xls"

HTH,
Nikos
 
Nikos
I m also looking for something similar. I was little querious to know can we still save it on the server if that server is not mapped .
 
The original thread has aged off my newsreader's cache.

But maybe you just save the workbook using the UNC path.

thisworkbook.saveas filename:="\\myserver\myshare\myfolder\myworkbook.xls"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine name of macro contained in each excel file in a folder 9
Force Save Folder Location on Network 2
Excel VBA Save file to Network in Vista and Office 2007 1
macro pointing to wrong folder 2
Saving templete / workbook to a specific drive / file 1
save file with macro - web folder 2
Problem in Saving the Activeworkbook on a network drive 2
Modify Ron de Bruin Code; Save Specific Files to Specific Folders 1

Back
Top