Make macro that saves a file

[Jyggalag]

Hi all,

I would like to create a macro where, once I press it, it saves my file to my folder \\COMPANY.MDDD.COMPANY.NET\userdata\t654895\home\Documents\test files

Does anybody know how I would go about in doing this?

Thank you!

BR.
Jyggalag
Prince of Order est. March 26, 2007.

 

[Jamie McMillan]

Hello Jyggalag,

This should help.

ActiveWorkbook.SaveAs Filename:="C:\JyggalagFile.xlsm"
ActiveWorkbook.SaveAs Filename:="\\COMPANY.MDDD.COMPANY.NET\userdata\t654895\home\Documents\test files\JyggalagFile.xlsm"

Jamie

 

[Jyggalag]

Hello Jyggalag,

This should help.

ActiveWorkbook.SaveAs Filename:="C:\JyggalagFile.xlsm"
ActiveWorkbook.SaveAs Filename:="\\COMPANY.MDDD.COMPANY.NET\userdata\t654895\home\Documents\test files\JyggalagFile.xlsm"

Jamie

Thank you so much Jamie!

I assume that I should just put "Sub" before the code and "End Sub" after to make it work in VBA, right?

Would there be any way in which you could make the SaveAs FileName = a cell value in Excel?

Kind regards,
Jyggalag

 

[Jamie McMillan]

Yes you put sub before and end sub after.

I think you can set the filename to a cell value, I did something similar before. I will look at it tomorrow if I remember.

 

[Jamie McMillan]

Hello,

Sub CellFromFilename()
Dim Path As String
Dim fn As String
Path = "C:\Users\Jamie\Desktop\Developing\"
fn = Range("A1")
ActiveWorkbook.SaveAs filename:=Path & filename & ".xls", FileFormat:=xlNormal
End Sub

I would forget tomorrow.

Jamie

 

[Jyggalag]

Hello,

Sub CellFromFilename()
Dim Path As String
Dim fn As String
Path = "C:\Users\Jamie\Desktop\Developing\"
fn = Range("A1")
ActiveWorkbook.SaveAs filename:=Path & filename & ".xls", FileFormat:=xlNormal
End Sub

I would forget tomorrow.

Jamie

Hi Jamie,

Thank you so much for your guidance and incredibly fast answers! Apologies for my slow one

I have one error when I run the code now, please see below:

It highlights "Filename". Any idea where I may have messed up?

Kind regards,
Jyggalag

 

[Joe4]

Hi Jamie,

Thank you so much for your guidance and incredibly fast answers! Apologies for my slow one

I have one error when I run the code now, please see below:

View attachment 56648

It highlights "Filename". Any idea where I may have messed up?

Kind regards,
Jyggalag

I think he meant to use "fn" there, and not "FileName", as there are no variables named "Filename" declared in that procedure (but there is one named "fn").

 

[Jyggalag]

Z

I think he meant to use "fn" there, and not "FileName", as there are no variables named "Filename" declared in that procedure (but there is one named "fn").

You're right! Thank you so much Joe4! I'll allow Jamie to receive the solution, but would highlight yours in addition if I could!

 

[Joe4]

No problem!

 

[Jamie McMillan]

No problem!

Thank you Joe 4

Exactly right

Jamie