gnasher123
New Member
- Joined
- Jul 15, 2014
- Messages
- 3
Hi All
I have a 'reconciliation' process, which I am designing using MS Access. Its a three-way process where the source information comes from three different systems - one in CSV format and one in Excel. The third source is also in Excel, but cannot be accessed from any other PC than the user who controls the spreadsheet itself, due to it being linked to an external source which updates prices (a system called Bloomberg). Apologies if I've posted something like this before, but things have changed.
I cannot get the requisite licence due to its cost to be able to replicate what the user sees, so she has resorted to copying and pasting values into a blank spreadsheet and emailing me.
What I would like to do is give her a macro - something I havent had that much to do with on Excel, that will copy and paste all values in the spreadsheet, and save it to a particular shared folder. It will have the same name every time this is done, weekly. There are seven distinct spreadsheets all of which will have the same name and path to the specific folder.
Can anyone tell me the best way to go about this? The spreadsheets themselves are very valuable to the team so I dare not do anything which will alter them or endanger the data they contain, as it would be tricky if I damaged them in any way, whilst sat at their PC's trying to write Macros!
Any advice would be much appreciated!
Tks
Mark
I have a 'reconciliation' process, which I am designing using MS Access. Its a three-way process where the source information comes from three different systems - one in CSV format and one in Excel. The third source is also in Excel, but cannot be accessed from any other PC than the user who controls the spreadsheet itself, due to it being linked to an external source which updates prices (a system called Bloomberg). Apologies if I've posted something like this before, but things have changed.
I cannot get the requisite licence due to its cost to be able to replicate what the user sees, so she has resorted to copying and pasting values into a blank spreadsheet and emailing me.
What I would like to do is give her a macro - something I havent had that much to do with on Excel, that will copy and paste all values in the spreadsheet, and save it to a particular shared folder. It will have the same name every time this is done, weekly. There are seven distinct spreadsheets all of which will have the same name and path to the specific folder.
Can anyone tell me the best way to go about this? The spreadsheets themselves are very valuable to the team so I dare not do anything which will alter them or endanger the data they contain, as it would be tricky if I damaged them in any way, whilst sat at their PC's trying to write Macros!
Any advice would be much appreciated!
Tks
Mark
