D
Dan Hulgin
Hi,
I am developing a form that updates a database. I would like the user
to click on a button and it will save the file as a name determined b
a cell reference, and save it to a folder as determined by another cel
reference. It also needs to update the database, when it is saved. (
need this so they don't mess things up )
Currently for saving as a particular filename I have:
ActiveWorkbook.SaveAs FileName:="ETR_" & Range("v7").Value & ".xls"
where:
V7 contains the file name i wish to add
This part works, However, this does not give the prompt to update th
exisitng database, whichI need it to do
I also have the following for saving to a particular location:
SavePath = "G:\Labs\Request Form\Database\" & Range("v32").Value
where:
V32 contains the name of the subfolder
But everytime I run the macro all it does is save the file to
G:\Labs\Request Form\Database\
instead of
G:\Labs\RequestForm\Database\whatever is in v32
Also the form works well if I dont run the macro, it updates th
database just fine and gives the correct prompts.
Any help in this matter would be greatly appreciated
I am developing a form that updates a database. I would like the user
to click on a button and it will save the file as a name determined b
a cell reference, and save it to a folder as determined by another cel
reference. It also needs to update the database, when it is saved. (
need this so they don't mess things up )
Currently for saving as a particular filename I have:
ActiveWorkbook.SaveAs FileName:="ETR_" & Range("v7").Value & ".xls"
where:
V7 contains the file name i wish to add
This part works, However, this does not give the prompt to update th
exisitng database, whichI need it to do
I also have the following for saving to a particular location:
SavePath = "G:\Labs\Request Form\Database\" & Range("v32").Value
where:
V32 contains the name of the subfolder
But everytime I run the macro all it does is save the file to
G:\Labs\Request Form\Database\
instead of
G:\Labs\RequestForm\Database\whatever is in v32
Also the form works well if I dont run the macro, it updates th
database just fine and gives the correct prompts.
Any help in this matter would be greatly appreciated