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
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