Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jmy32
-
Advancedfilter VBA losing hyperlinks
When I run an advancedfilter in VBA in Excel my output data loses the hyperlinks from the original cells. Any idea why and how not to lose them? Thanks Josh- jmy32
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA advancedfilter crashes when XLS opens but NOT when run through VBE
I have a userform that takes data and creates a criteria range, output range and input range and runs an advancedfilter on it to create a subset of data. The userform is auto-loaded when the XLS is opened, do the advanced filter and then copy that subset to a new workbook, and then to close the...- jmy32
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How do I turn Date into custom text?
Using Excel 2003, writing custom VBA code for a userform. I want to be able to create a custom filename to save a workbook by appending the date and time (unique and easy to identify). I can't seem to figure out how to do it in VBA. The formula in Excel isn't working. My goal is to have it...- jmy32
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
