Hi all
Ive trawled the forums and tried some of my own code (im relatively new to vb)
What I need is a code that saves my spread sheet to a designated folder on a network and at same time names the workbook via a user imputed cell:
The form is a job request and basics are once filled in the information populates a data base then saves the filled in spread sheet (at least I need it too) save it as the job title and date it was filled in.
This is my attempt
ThisWorkbook.SaveAs G:Resources/SupportOfficers/Projects/JobRequest.range("C1")
Now it saves in the correct folder G:Resources/Support Officers/Projects/JobRequest
but calls its self G:Resources/SupportOfficers/Projects/JobRequest.range("C1")
any help muchly appreciated thanks
erhm if any could add the clear work book code I would be really grateful because my head is about ready to go BANG..
Ive trawled the forums and tried some of my own code (im relatively new to vb)
What I need is a code that saves my spread sheet to a designated folder on a network and at same time names the workbook via a user imputed cell:
The form is a job request and basics are once filled in the information populates a data base then saves the filled in spread sheet (at least I need it too) save it as the job title and date it was filled in.
This is my attempt
ThisWorkbook.SaveAs G:Resources/SupportOfficers/Projects/JobRequest.range("C1")
Now it saves in the correct folder G:Resources/Support Officers/Projects/JobRequest
but calls its self G:Resources/SupportOfficers/Projects/JobRequest.range("C1")
any help muchly appreciated thanks
erhm if any could add the clear work book code I would be really grateful because my head is about ready to go BANG..
Last edited: