Hi,
It's been a while since I have worked with Excel VBA so I'm trying to get back up on the horse.
I created a form on worksheet "Admin" to allow user to select multiple text data sources and ingest them (different criteria depending on the file format). These files populate a table on a worksheet Data". I thought I could simply copy the "Admin" worksheet and VBA code to an existing file with the "Data" worksheet and associated "Charts" and have the data dynamically update the charts, but this failed. I attempted to recreate the VBA code and buttons in this second file but nothing worked.
So I am not trying to copy the charts from the second workbook into my original. Doing this brings the relative references from the original workbook/Sheet/ranges, (and it is a rather complicated series of charts), so I thought it would be easier to convert to VBA code and then use find-replace to modify the source data location.
Any way of doing this? (converting existing chart to VBA Code)?
Thanks!
Casey
It's been a while since I have worked with Excel VBA so I'm trying to get back up on the horse.
I created a form on worksheet "Admin" to allow user to select multiple text data sources and ingest them (different criteria depending on the file format). These files populate a table on a worksheet Data". I thought I could simply copy the "Admin" worksheet and VBA code to an existing file with the "Data" worksheet and associated "Charts" and have the data dynamically update the charts, but this failed. I attempted to recreate the VBA code and buttons in this second file but nothing worked.
So I am not trying to copy the charts from the second workbook into my original. Doing this brings the relative references from the original workbook/Sheet/ranges, (and it is a rather complicated series of charts), so I thought it would be easier to convert to VBA code and then use find-replace to modify the source data location.
Any way of doing this? (converting existing chart to VBA Code)?
Thanks!
Casey