Results 1 to 1 of 1

workstation excel workbook is protected by password can i submit data from my user workbk

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    can i can i submit data from my user workbk to a url path which is protected by password

    the workstation excel workbook it is in network as shown in code

    Service log request but it is password protected by an admin

    i just wanted to data in the wokstation workbook It is possible please let me know

    Private Sub cmdbt1_Click()
    Dim irow As Long
    Dim ws As Worksheet
    
    
    Dim info
    info = IsWorkBookopen("\\bms\Service log request\login details\workstation.xlsx")
    
    
    'we open the workbook if it is closed
    If info = False Then
    Workbooks.Open ("\\bms\Service log request\login details\workstation.xlsx")
    End If
    
     Set ws = Worksheets("Login Time")
    
    'Find first empty row in database
     irow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
     SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
    
    
    'Check for a Name number
    If Trim(Me.TextBox1.Value) = "" Then
    Me.TextBox2.SetFocus
    End If
    'Exit Sub
    If TextBox1.Value = "" Then
            MsgBox "Fill the blanks "
            
            Application.DisplayAlerts = True
            Workbooks("workstation.xlsx").Close
            Exit Sub
        Else
    '       Code if not empty
    
    
    
        End If
    If TextBox2.Value = "" Then
            MsgBox "Fill the Details"
            Workbooks("workstation.xlsx").Close
    Application.DisplayAlerts = True
    
            Exit Sub
            
        Else
    '       Code if not empty
     
    
        End If
        If TextBox3.Value = "" Then
            MsgBox "Fill the Details"
             
      Workbooks("workstation.xlsx").Close
     Application.DisplayAlerts = True
    
            Exit Sub
            
        Else
    '       Code if not empty
    
    
        End If
    
    
    
    'Copy the data to the database
    ws.Cells(irow, 1).Value = Me.lbl2.Object
    ws.Cells(irow, 3).Value = Me.lbl4.Object
    ws.Cells(irow, 4).Value = Me.lbl6.Object
    ws.Cells(irow, 2).Value = Me.Label2.Object
    ws.Cells(irow, 5).Value = Me.TextBox3.Value
    ws.Cells(irow, 6).Value = Me.TextBox1.Value
    ws.Cells(irow, 7).Value = Me.TextBox2.Value
    'Me.lbl2.Name = ""
    'Me.lbl4.Name = ""
    Me.TextBox1.Value = ""
    Me.TextBox2.Value = ""
    Me.TextBox3.Value = ""
    
    Me.TextBox1.SetFocus
    
    
    'Application.DisplayAlerts = False
     
     Workbooks("workstation.xlsx").Save
     Workbooks("workstation.xlsx").Close
     Application.DisplayAlerts = True
    
    
    
    
    MsgBox "welcome to bms"
    MsgBox "Don't Forget to Logout before Shutdown system"
    Application.Quit
    End Sub
    Last edited by baig123; 09-04-2014 at 02:43 AM. Reason: paragraph

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] whenever i submit button it opens an workstation files where user details there i dont wan
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2014, 01:29 AM
  2. updating the master workbook whenever user click submit in check workbook
    By share knowledge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2011, 10:42 PM
  3. extract data from a password protected workbook
    By WaveOfMutilation in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-06-2010, 11:54 AM
  4. [SOLVED] Password-Protected Workbook not showing "in use by another user"
    By Jim Jackson in forum Excel General
    Replies: 1
    Last Post: 07-13-2006, 10:15 AM
  5. Replies: 2
    Last Post: 03-30-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1