S
Slickdock
Sorry if this is a duplicate. I thought I posted it but cant' find
it :-(
Hoping for help on the following:
I'm trying to write a macro that saves documents like this:
1- P: will always be the drive letter
2- user input will determine the folder
3- first 8 characters of filename will be current date in yyyymmdd
format
4- next 3 characters will be the author
4- next will be a dash, then user input's description.
All I know how to do is the following (defining and capturing a few of
the variables):
Dim folder As String
Dim author As Long
Dim description As String
folder = InputBox("Folder to Save in:")
author = InputBox("1-CL 2-RH 3-KH")
description = InputBox("Description")
it :-(
Hoping for help on the following:
I'm trying to write a macro that saves documents like this:
1- P: will always be the drive letter
2- user input will determine the folder
3- first 8 characters of filename will be current date in yyyymmdd
format
4- next 3 characters will be the author
4- next will be a dash, then user input's description.
All I know how to do is the following (defining and capturing a few of
the variables):
Dim folder As String
Dim author As Long
Dim description As String
folder = InputBox("Folder to Save in:")
author = InputBox("1-CL 2-RH 3-KH")
description = InputBox("Description")