Tag Archives: vba

File in use Vb

just found nice code in internet, and i use it in one of my project. works great! it will return the last user that open the file Function LastUser(strPath As String) As String ‘// Code by Helen from http://www.xtremevbtalk.com/index.php?s= ‘// … Continue reading

Posted in vb | Tagged , , | Leave a comment

List of SendKeys

Key Code BACKSPACE {BACKSPACE}, {BS}, or {BKSP} BREAK {BREAK} CAPS LOCK {CAPSLOCK} DEL or DELETE {DELETE} or {DEL} DOWN ARROW {DOWN} END {END} ENTER {ENTER}or ~ ESC {ESC} HELP {HELP} HOME {HOME} INS or INSERT {INSERT} or {INS} LEFT ARROW … Continue reading

Posted in asp.net, vba | Tagged , , , | Leave a comment

Check if table is exist vba

Problem: Check if table is exist Solution: Option Compare Database Public Function TableExists(strTable As String) As Boolean Dim strName As String On Error Resume Next ‘If table exists already then strName will be > “” strName = CurrentDb.TableDefs(strTable).name TableExists = … Continue reading

Posted in vba | Tagged , , | Leave a comment

Shell and AppActivate command vba

Problem: You want to open the file using send key, and active it as a window Solution: ‘Define the task ID Dim dTaskID As Integer ‘Open the file with your application dTaskID = Shell(“applicationYouWantToOpenWith.EXE path+nameofthefile”) ‘Make it active window AppActivate … Continue reading

Posted in vba | Tagged , , , , | Leave a comment