VBa Code Did't Open Workbook
Closed
                    
        
                    azmiismail
    
        
                    Posts
            
                
            17
                
                            Registration date
            Thursday March  3, 2011
                            Status
            Member
                            Last seen
            July 20, 2011
            
                -
                            Jul 20, 2011 at 02:06 AM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 22, 2011 at 05:33 PM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 22, 2011 at 05:33 PM
        Related:         
- VBa Code Did't Open Workbook
 - Cs 1.6 code - Guide
 - Vba case like - Guide
 - Samsung volume increase code - Guide
 - Battery reset code - Guide
 - Samsung keypad mobile lock open code - Guide
 
1 response
                
        
                    smd_excel
    
        
                    Posts
            
                
            27
                
                            Registration date
            Saturday April 18, 2009
                            Status
            Member
                            Last seen
            November 22, 2012
            
                    
Jul 20, 2011 at 02:29 AM
    Jul 20, 2011 at 02:29 AM
                        
                    Capture the file name and location i.e. in variable
file_path = Sheets("sheet1").Cells(1, 2)
file_name = Sheets("sheet1").Cells(2, 2)
Workbooks.Open Filename:=file_path & file_name
            file_path = Sheets("sheet1").Cells(1, 2)
file_name = Sheets("sheet1").Cells(2, 2)
Workbooks.Open Filename:=file_path & file_name
        
    
    
    
    
Jul 22, 2011 at 05:33 PM