Save File to specific location and name with date

[HomePro]

I would like to save the file without being prompted at the end of my existing macro.
I would prefer:
A variable to preset the file name
A variable to preset the location
And then the current date.

So i tried :
Sub Save()
FN="Test1"
lc ="C:\documents"
DT= (today)
ActiveWorkbook.SaveAs filename:=LC & FN &DT ".xls"
End Sub

wont work.
Any ideas?

 

[Joe4]

If you are able to manually save to that path, then yes. If not, no.

If you are able to save to that path, turn on your Macro Recorder and record yourself manually saving a file to that path.
Then stop the Macro Recorder and view your code to see what that part of your code should look like.

 

[HomePro]

Cant seem to get this to work.
This is the code i am using.
Can anyone help?

I tried the script below but it did not work..

'Save File
FN = "Mileage - "
DT = Sheets("Sheet1").Cells(1, "m")
FilePath = LC & "\" & FN & DT & ".xls"
LC=https://work.zoho.com/#workdrive/ho...folders/rdj8id0786001aa5c4d2ba095f37928e04cf0" '[this is the desired save to location that i could not get to work]
Application.DisplayAlerts = False
ActiveWorkbook.saveas Filename:=FilePath, FileFormat:=xlExcel8
Application.DisplayAlerts = True
Application.Quit

 

[Joe4]

Please respond to posts 10 and 11.
Have you tried either of those things yet?

 

[rlv01]

Can anyone help?

Follow @Joe4's recommendation in Post #11 and report the results and/or post the macro recorder code.

 

[HomePro]

Sorry - been away.
Using the macro recorder it defaults to the mapped path. Butif I run it on another pc that is not mapped the same way it fails.
Thats why I wanted to use a unc or in this case web address as the storage is not in my domain.

 

[rlv01]

If you are able to manually save the file to a web address path, then it should be possible to write a macro to automate it.

Step 1: Turn on your Macro Recorder and record yourself manually and successfully saving a file to your desired web address path.
Step 2: Post the macro recorder code here.

 

[HomePro]

well I do not know how to do that - i can only pick the location from the mapped folders in the save as drop down.
Thats why i was asking for help on how to save it to a web location......

 

[rlv01]

Best of luck to you, but I think I'm out. You ask for help but you won't follow recommendations to gather information that might allow further help, and I am weary of trying to coax you into action.

 

[HomePro]

I tried to follow - however I can not post what I can reproduce.

 

[Joe4]

One last attempt:

Thats why I wanted to use a unc or in this case web address as the storage is not in my domain.

Are you able to manually browse to this web address and successfully save your file?
If you are, simply turn on your Macro Recorder, and record yourself doing that exact thing (manually browsing to the web address and saving the file).
Then simply stop the Macro Recorder, view the code you recorded, and copy and paste it here.

If you cannot browse to the web address and save the file manually, then you probably are not going to be able to do it with VBA either.