Hi there
I am hoping that someone can please help me, I will try and put this as best I can:
I have an Excel spreadsheet - 3 tabs - TabA, TabB (Hidden) and TabC (Hidden).
The user enters details into a predetermined fields onto TabA, this information is then copied (via formulas) into the hidden sheet TabB, when the user has completed entering in all the information they then click on a button to Save.
The information on TabB is copied into TabC, this tab is then copied into a new workbook and saved as a 1 tab workbook.
The location of where this tab needs to be saved, is compiled in cell CA1, as the destination/file name will be dependant on the information entered. I haved tried a previous Macro to check if the folder structure exists and if it does, then save the file, but if it doesn't then create the folder structure and then also save the file, however, I have hit a bit of a wall.
I tried the coding supplied to me on my home pc and it worked fine - saving to C:\Documents and Settings\Administrator\My Documents etc etc..... however, when I tried it in my workplace, I find I am having difficultly, it is not saving in the folder structure that already exist, it is creating a whole new structure.
The only difference I can see is the path/folder structure, although still wanting to save in "My Documents".
When I right click on the folder it is showing the path that I need, which I entered, as it doesn't have an assigned drive I.e. C:\..... it shows as E.g. \\Dfs60325.gpn.gov.uk\1234567$\My Documents.....
The first part being the location, "1234567$" being the users identifier etc.....
Can anyone please please help me with my dilemma??
Many thanks in advance.
Mark
I am hoping that someone can please help me, I will try and put this as best I can:
I have an Excel spreadsheet - 3 tabs - TabA, TabB (Hidden) and TabC (Hidden).
The user enters details into a predetermined fields onto TabA, this information is then copied (via formulas) into the hidden sheet TabB, when the user has completed entering in all the information they then click on a button to Save.
The information on TabB is copied into TabC, this tab is then copied into a new workbook and saved as a 1 tab workbook.
The location of where this tab needs to be saved, is compiled in cell CA1, as the destination/file name will be dependant on the information entered. I haved tried a previous Macro to check if the folder structure exists and if it does, then save the file, but if it doesn't then create the folder structure and then also save the file, however, I have hit a bit of a wall.
I tried the coding supplied to me on my home pc and it worked fine - saving to C:\Documents and Settings\Administrator\My Documents etc etc..... however, when I tried it in my workplace, I find I am having difficultly, it is not saving in the folder structure that already exist, it is creating a whole new structure.
The only difference I can see is the path/folder structure, although still wanting to save in "My Documents".
When I right click on the folder it is showing the path that I need, which I entered, as it doesn't have an assigned drive I.e. C:\..... it shows as E.g. \\Dfs60325.gpn.gov.uk\1234567$\My Documents.....
The first part being the location, "1234567$" being the users identifier etc.....
Can anyone please please help me with my dilemma??
Many thanks in advance.
Mark