MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Dim OpenFileName As Variant Dim wBook As Workbook Dim SampleReg As Workbook On Error Resume Next ' if it stuffs out go to the next step ActiveWorkbook = SampleReg OpenFileName = Application.GetOpenFilename() 'Opens the File Dialog If OpenFileName = False Then Exit Sub 'If no file selected stop Workbooks.Open (OpenFileName) 'works OpenFileName.Activate Databook = OpenFileName.Name Range("P6") = OpenFileName Workbooks(Databook).Activate
|Can't get rid of Update Links message in Excel 2013||8||33|
|copy selected column based on selected value to new worksheet||2||34|
|Add Attendee Macro need not halt for Acknowledgement||12||25|
|Do Wend Macro not working||22||36|