Search results for query: *

How to make it password protected? I don't want to users manipulate the csv file. I use the code to make it as read only: setattr fname, vbreadonly But it's not secured enough. They could still make changes to it if they want. Can I make changes to the following code on "fileauthority"...

the following code in my ebm file open up the window explorer : function browse() hWndCalc& = Shell("C:\WINDOWS\explorer.exe", 1) end function the problem is the user interface is gone after the window explorer get started. I want the users be able to get back to the user interface. I am...

HOw to set password to EBM file? I don't want my code to be read or manipulated by users.

'For mm=1 to restitems2.count olSubject=restitems2.item(mm).Subject or olSubject=restitems2.item(mm).body

Solution found: Select case mydialogbox.optiongroup1 Case 0 msgbox "first option button" Case 1 msgbox "second option button" Case else msgbox "invalid option" End Select

How to tell option buton 4 is selected or not, the following code didn't work: if mydialogbox.OptionButton4.selected =true then msgbox "option button 4 selected ." end if

The solution is: Set thisApp = CreateObject("Outlook.Application") Set thisNameSpace = thisApp.GetNamespace("MAPI") Set thisFolder = thisNameSpace.Folders("Mailbox- lastname, first name") Set thisFolder = thisFolder.Folders("Inbox") Set theseItems = thisFolder.Items Please note that the...

I find the solution myself. Thanks anyway!

Hi SkipVought, It didn't work!The Inbox is not within the personal folders. Under the Mailbox, there's subfolder for calender , sent items and inbox. I could create mail item using CreateItem(olmailitem) function. Now I am looking some way to retrieve mail from Inbox.

I could open folders in outlook by using the following code : Set thisApp = CreateObject("Outlook.Application") Set thisNameSpace = thisApp.GetNamespace("MAPI") Set thisFolder = thisNameSpace.Folders("Personal Folders") Set theseItems = thisFolder.Items these code doesn't work for Inbox. Do...