I have a client who is using Exponenciel's Excel Templates in Sage's Act! database. He uses the templates to open up 2 spreadsheets, part filled with data from the database. He then fills in some more details on one of the spreadsheets which he then wants to copy and paste into the second spreadsheet. At the moment, he does this manually but wants to be able to do this automatically via pressing a button.
All very easy, yes? A spot of VBA and Bob's your uncle! Well, no, as the Excel Templates open each spreadsheet in a separate instance of Excel (and Exponenciel tell me that it has to be this way), so they can't communicate with each other via VBA - or can they?
Short of saving the second sheet, then picking it up in the instance with the first sheet (rather messy - much rather NOT save the second one until completed), I can't think how I'm going to do this. Does anyone have any suggestions?