Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by smozgur
-
Set e-mail category
Hi, Goto VBA in OL (Alt+F11) and Insert->Module to add a new module then copy & paste the following code into this new module: '----Code Start---- Sub SetCategory() Dim olMail As MailItem If Application.ActiveExplorer.Selection.Count = 1 And _...- smozgur
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
P.S. Since I was working within a
Replied in your other same question. Suat Oz www.TheOfficeExperts.com- smozgur
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Format Date Problem
Use this: Me.FYTrackNo = "CY" & Format(DateSerial(Me.FYYear.Value, 1, 1), "yy") & "-" & Format(iCount, "000") Or this: Me.FYTrackNo = "CY" & right(Me.FYYear.Value, 2) & "-" & Format(iCount, "000") instead yours. It fails...- smozgur
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Inserting quote marks around existing cell values
Nice to hear that. Oz www.TheOfficeExperts.com- smozgur
- Post #4
- Forum: Microsoft: Office
-
Inserting quote marks around existing cell values
Hi, If you enter only one single quote before entering your real data then excel cell will see that you are entering a "text" by ignoring the real data type. So if you enter '1255 in a cell then excell will see that you are entering 1255 as string and remove ' from the beginning...- smozgur
- Post #2
- Forum: Microsoft: Office
-
Ouch, password encryted VBA
Oz@TheWordExperts.com Oz www.TheOfficeExperts.com- smozgur
- Post #4
- Forum: Microsoft: Office
-
Ouch, password encryted VBA
Try your chance. Oz www.TheOfficeExperts.com- smozgur
- Post #3
- Forum: Microsoft: Office
-
ListBox -- deselect ..the highlighted text ???
You can set listindex property to -1 when listbox clicked. Private Sub List1_Click() List1.ListIndex = -1 End Sub I hope this helps. Regards Oz www.TheOfficeExperts.com- smozgur
- Post #2
- Forum: Visual Basic (Classic)
-
"On error....go to" staement is not working in my macro
.... Windows(file).Activate ActiveWorkbook.Close (False) err: RESUME NEXT Next i .... And also put On Error line before Loop Regards Oz www.TheOfficeExperts.com- smozgur
- Post #5
- Forum: Microsoft: Office
-
Excel Macros - need help
Perfect! Oz www.TheOfficeExperts.com- smozgur
- Post #4
- Forum: Microsoft: Office
-
Method '~' of object '~' failed
If you are using ADO then I suggest reading this article and re-installing MDAC. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q255986 Actually when I got this error it was about a reserved word I used as field name in my sql connection string and fixed after changing it but I also...- smozgur
- Post #2
- Forum: Visual Basic (Classic)
-
TabExcel: Is there "code" for setting a custom Tab order
First, you can still protect your cells. Just select your changable cells (which macro modifies) and click Format Cells then click Protection tab and clear the Locked checkbox. Now Protect your worksheet. And for Tab order for this unprotected cells open the VBA and select the Sheet1 object in...- smozgur
- Post #2
- Forum: Microsoft: Office
-
Using DAO objects in Excel
You're welcome! Oz www.TheOfficeExperts.com- smozgur
- Post #4
- Forum: Microsoft: Office
-
Excel - Disable Auto Hyperlinking?
Wow, I was away for a while and everything solved :) Oz www.TheOfficeExperts.com- smozgur
- Post #10
- Forum: Microsoft: Office
-
Using DAO objects in Excel
Click Tools_References (in VBE) Insert Microsoft DAO 3.X Object library. Now it will work. Regards Oz www.TheOfficeExperts.com- smozgur
- Post #2
- Forum: Microsoft: Office
