Ana has attended:
Excel VBA Intro Intermediate course
Linking Workbooks
Is it possible to write macors and code that would go in to to different workbooks or access to to collect data and then apply that data into a new workbook for analysis, therefore, keeping analysis and data seperate?
RE: Linking Workbooks
Hi Ana
Thankyou for your question
Could you please clarify your requirements for me?
Do you want to be able to create a series of modules that can be applied to a variety of workbooks? Or do you wish to be able to analyse data contained in one workbook and then place the results of that analysis in another workbook.
You also mention Access. Can you be more precise as to the type of data you wish to extract from Access and how you would wish to analyse it
Regards
Stephen
