my question is this, I have VBA code that does a while bunch of formatting, glue'ing of other sheets and adding templates and then it saves it to my local folder on my c:\ drive
The reason why I do this, is because the network is slow and there are multiple things that are happening, hacks and stuff... many steps, to be able to do the job.
Anyways, is there a way, some functions or something in Excel VBA where I could move the workbooks.xls to a network drive ? move them, like if I were to drag a file, without opening each one ? The process of Opening the workbooks and then Saving is too slow, as I will have hundreds of them and not a few.
So if my workbook is called: c:\tempfolder\Store_1_blablablabla.xls
I want to find out the store number, in this case 1, I have a nice CASE statement that has the different network location hard coded for each different store and then it would move it to the right folder from the temp folder on the C:\ drive, thanks!
The reason why I do this, is because the network is slow and there are multiple things that are happening, hacks and stuff... many steps, to be able to do the job.
Anyways, is there a way, some functions or something in Excel VBA where I could move the workbooks.xls to a network drive ? move them, like if I were to drag a file, without opening each one ? The process of Opening the workbooks and then Saving is too slow, as I will have hundreds of them and not a few.
So if my workbook is called: c:\tempfolder\Store_1_blablablabla.xls
I want to find out the store number, in this case 1, I have a nice CASE statement that has the different network location hard coded for each different store and then it would move it to the right folder from the temp folder on the C:\ drive, thanks!
