Mandy has attended:
Excel VBA Intro Intermediate course
Upgrade to Office 2010 course
Code to copy using hyperlink
Is it possible to copy data from another workbook using a hyperlink in the current workbook to direct the code to a specific workbook.
ie. on workbook S:\systems\costing is a hyper link to S:\Dev\H&P. Workbook H&P has a worksheet call assembly.
I want to copy data from this assembly sheet into the costing worksheet for each workbook created in S:\Dev. The file names change on a regular basis so I dont want to go into several different bits of code each time.
RE: Code to copy using hyperlink
Hi Mandy
Thanks for the detail around what you are trying to achieve, this cannot be done using hyperlinks. Code would have to be written that would cycle through all the files in a directory, open them and copy the data into a workbook. Without spending more time on this we are not clear on how this could be done, but it would take several days to set up.
We can assist with this in a consultative role should it be something you wish to pursue.
regards
Jacob
