This is a code used to open up workbooks that I can't access the data due to password protect and non-selectable cells
- Pretty much I can't manually copy and paste or even right click to see hidden rows/columns
- It is designed to only pull the values and keep source formatting, it doesn't pull the original formulas
Essentially I have a very basic workbook with one button that says "Click Me".
- The button kicks off the Module below which asks you to select which excel workbook to open
- It then begins copying the format and values of every cell ( and tab names ) and puts it into the "Data Pulling" workbook
- This way I have the ability to manipulate the data ( by actually selecting it ) to put into other tools or do analysis with
*** This is not meant to break into anything I shouldn't be in - it's just a tool to copy data from a workbook I already have access to but instead of visually copying over the data I can remove some human error by using this tool.
But looking it seems a bit unclean. I feel like I should be putting things like " Dim ImportedFile as String " or something ( I'm not familiar with what this does )
I have to be careful with how it pastes data, if I try to mess around with that bit too much it errors out and I have to re-select the file location for each tab manually ( Whereas below it just automatically goes to the next tab without asking for the file location again )
Please Login or Register to view this content.
Bookmarks