LinkBack URL
About LinkBacks
06nenglish 
I seem to be getting a Run Time error 9 on
wb is set as it is used on the line before to make the workbook visible.
wb.Close Savechanges:=False
I seem to be getting a Run Time error 9 on
wb is set as it is used on the line before to make the workbook visible.wb.Close Savechanges:=False
Can you post your entire code?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Here it is:
ModLibName and wb are set to be public.
ModLibName = "Library.xlsm" Set wb = Workbooks(ModLibName) ThisWorkbook.Windows(1).Visible = True wb.Windows(1).Visible = True wb.Save wb.Close Savechanges:=False
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks