Ok here is the case, I'm using indirect formulas to link data from another open workbook for some calculations and other stuff. I'm using a button and a listbox to get the full file path of the other worksheet I want it to pull data from (Then trim formulas actually establish the link and pull the data).
The reason for this is because the other workbooks change daily and the other's using this sheet are even less savy about excel then myself. Perhaps there are better methods but with my knowledge its all I've come up with.
However everything is working great so far and there is one last little cosmetic issue i'd like to remove. The listbox populates the file path's of all open workbooks when the button is clicked. From there the selection from the listbox is copied to a cell on my spreadsheet and trim formulas take over (This works because the sheets that this is referencing are always in some date format like "MM-DD-YYYY.xls". What i'd like to do is remove my sheet from the list so that the only workbooks that are shown in the list are the others. I just don't know know to do it. The macro that actually populates the listbox with the open workbook's filepaths is shown below. I should note that i'm very new to vba.
I really appreciate any help here.
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by tlafferty
Bookmarks