Sub salva() Dim C As String, directory As String C = "" & Range("C3") & "-" & Range("J1").Value directory = "/localhost/Volumes/Amministrazione/Amministrazione/SchedeLavoriClienti/2010/" ActiveWorkbook.SaveAs Filename:=directory & C & ".xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub |
Sub salva() Dim C As String, directory As String C = "" & Range("C3") & "-" & Range("J1").Value directory = "C:/localhost/Volumes/Amministrazione/Amministrazione/SchedeLavoriClienti/2010/" ActiveWorkbook.SaveAs Filename:=directory & C & ".xls End Sub |
Sub percorso() ' ' percorso Macro ' Macro registrata il 2-08-2010 da Graphic Designer ' ' ChDir "Marcie:DOCUMENTI:LAVORI:0RE LAVORI:" Range("H8").Select ActiveWorkbook.SaveAs Filename:="Marcie:DOCUMENTI:CAV-.xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False End Sub |
Sub salva() Dim C As String C = "" & Range("C3") & "-" & Range("J1").Value ActiveWorkbook.SaveAs Filename:="Marcie:DOCUMENTI:" & C & ".xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub |
Sub salva() Dim C As String C = "" & Range("C3") & "-" & Range("J1").Value ActiveWorkbook.SaveAs Filename:="Marcie:DOCUMENTI:" & C & ".xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub |
Sub Salva() Dim Percorso As String, ini As String, C As String C = "" & Range("C3") & "-" & Range("J1").Value ini = Left(Range("C3"), 3) '******************** If ini = "cav" Then Percorso = "Marcie:DOCUMENTI:" End If If ini = "bob" Then Percorso = "Percorso diverso" End If '******************** ActiveWorkbook.SaveAs Filename:=Percorso & C & ".xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub |
Sub Collegamento() Dim Codice As String Codice = Range("B10").Value Workbooks.Open Filename:="Marcie:DOCUMENTI:PRIBAR:" & Codice & ".xls" End Sub |
Sub Collegamento() Dim Codice As String Codice = left(range("pippo"),8) Workbooks.Open Filename:="Marcie:DOCUMENTI:PRIBAR:" & Codice & ".xls" End Sub |
Codice = left(range("pippo").value,8) |
Sub apri() NomeFile = Range("A1") Application.Dialogs(xlDialogOpen).Show ("F:" & NomeFile & "*") End Sub |