Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UNC paths

Status
Not open for further replies.

aubie8

IS-IT--Management
Jul 9, 2001
7
US
I create a new workbook with the following code.

filenameinfo = "\\ncth3fax1\rightfax\chris\" + workbookname
Set newbook = Workbooks.Add
Application.DisplayAlerts = False
With newbook
.Title = ActiveCell.Value
.SaveAs filename:=filenameinfo
End With

If i use
filenameinfo = "C:\rightfax\chris\" + workbookname

it creates the workbook and does the rest of the spreadsheet creation in the blink of an eye. In fact, I can do 15 of them in five seconds.

If I use the unc path convention, it takes 30 seconds to just do one.

Anyone know why this would be the case? How to get around it?

Thanks!

Chris
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top