$$Excel-Macros$$ Need connection String of oracle in Excel VBA
Hi All Macro Champs, I need your help, can some one provide me an example to connect to the oracle server using excel VBA. Note: I’m creating one macro for my office use so I can’t install any addin on my system. Thanks in -- Thanks and Reagrd’s Shariq Shazad Khan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Need Help in Cross tab
Hi All, I need your help, as I’m unable to solve the problem which I’m going to explain you guys…….. Please refer the attached the excel with two tabs “Data” and “Report” On Data tab I have three columns loaded and Date and hours. Now I need a macro code to generate a report actually the cross between Date and Hours(we don’t have duplicate hours in date) and the we have max 22 hours in a date . if we have particular hours is the Data tab under a date then we need to flag the value with “Yes” under the fixed location of that hours in Report Tab. I hope you guys understand what I need. I cannot use pivot table. If you look into the attached excel you will get an idea what I need. Please help me guys……. Thanks in advance Thanks and Reagrd’s Shariq -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sample Data.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need to zip files
Hi All, Again I’m looking for help from you guys. This is time I’m not sure this can be done by excel macro but just really need it. I have two excel with name A_201025.xls and B_201025.xls, I need to zip the both file in a single compress file with a password protection. Below is the actual requirement. *add both Excel files to the same zip archive with maximum compression and AES 128-bit encryption using the password “hell12”*** to zip the two excel workbook is not a big problem if we will do it manually, but the same process I need to follow for more then 10-12 location. -- Thanks and Reagrd’s Shariq Shazad Khan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Need help......
HI All, I created a macro PERSONAL.XLSBvery long time ago...now i need to add two more module init..bu the problem is i forget the vba password. Plz help.. I'm also attaching the macro workbook...can some one break the code for me --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- PERSONAL.XLSB Description: Binary data
$$Excel-Macros$$ How to send mail with excel
Can any one help me? I looking for code to send an email from excel to the number of users, few in TO and some are on CC. I also need to add the below table in the body of the mail looks like the below example _ Hi, Please find the attached score if the candidates *Name* *Marks1* *Marks2* *sum* *SK* *75* *75* *150* *RL* *25* *25* *50* *NM* *85* *85* *170* *HL* *25* *25* *50* Please let me know if you have any concerns Thanks Shariq _ And we have dynamic marks after the logic of the code and filter criteria. also i need to send an excel sheet as an attachment(saved on some other location) Please help me. Thanks, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop
I’m trying to assign the value in excel user from thought loop. Name of the textboxes are TB1,TB2,TB3…….. TB22 . Below is the code which I’m using ,but its not working. For num = 1 To 22 txtbox_val = "TB" & num & ".value" txtbox_val = num End If Next num The same thing I wanted to do with the label and the names of the label are L1,L2,L3……L22 Please help me on this. -- Thanks and Reagrd’s Shariq -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ need help help........Texbox of user form
I’m trying to assign the value in excel user form thought loop. Name of the textboxes are TB1,TB2,TB3…….. TB22 . Below is the code which I’m using ,but its not working. For num = 1 To 22 txtbox_val = "TB" & num & ".value" txtbox_val = num End If Next num The same thing I wanted to do with the label and the names of the label are L1,L2,L3……L22 Please help me on this. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop
Hi Daneil, Thanks but it didnt worked.. Run-time error '-2147024809 Could not find the specified object Thanks, Shariq On Fri, Jul 8, 2011 at 11:12 AM, Daniel wrote: > Hi, > > ** ** > > Try : > > ** ** > > For num = 1 To 22 > > txtbox_val = Me.Controls("TB" & num).Value > > txtbox_num = num > > Next num > > ** ** > > Regards. > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 11:00 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ Need Help Help Help.Putting value in user > from by loop > > ** ** > > I’m trying to assign the value in excel user from thought loop. > > > > Name of the textboxes are TB1,TB2,TB3…….. TB22 . > > > > Below is the code which I’m using ,but its not working. > > > > For num = 1 To 22 > > txtbox_val = "TB" & num & ".value" > > txtbox_val = num > > End If > > Next num > > > > > > The same thing I wanted to do with the label and the names of the label are > L1,L2,L3……L22 > > > > Please help me on this. > > > > > > > > -- > Thanks and Reagrd’s > Shariq > > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks and Reagrd’s Shariq Shazad Khan 066979,9891184784 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop
Daneil, This one "txtbox_val = Me.Controls("TB" & num).Value". This is not on the worksheet, i'm using one userform and on which i have many texboxes.. but i'm not able to put the value in by using loop, once this is done then i will link it to the sheet values. The main fight it how to dynamicly refer TB1,TB2,TB3..TB22 I really need to do thought loop as many time i have to disable it, enable it clear the value of the textbox and putting values into the text box.. On Fri, Jul 8, 2011 at 6:05 PM, Daniel wrote: > Didn’t you say the textboxes were in a userform ? if they are on a > worksheet, the syntax should be : > > ** ** > > With ActiveSheet > > For i = 1 To 22 > > txtbox_val = .OLEObjects("TB" & i).Object.Value > > Next i > > End With > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 13:11 > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > ** ** > > Hi Daneil, > > > > Thanks but it didnt worked.. > > > > Run-time error '-2147024809 > > Could not find the specified object > > > > Thanks, > > Shariq > > On Fri, Jul 8, 2011 at 11:12 AM, Daniel wrote: > > Hi, > > > > Try : > > > > For num = 1 To 22 > > txtbox_val = Me.Controls("TB" & num).Value > > txtbox_num = num > > Next num > > > > Regards. > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 11:00 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ Need Help Help Help.Putting value in user > from by loop > > > > I’m trying to assign the value in excel user from thought loop. > > > > Name of the textboxes are TB1,TB2,TB3…….. TB22 . > > > > Below is the code which I’m using ,but its not working. > > > > For num = 1 To 22 > > txtbox_val = "TB" & num & ".value" > > txtbox_val = num > > End If > > Next num > > > > > > The same thing I wanted to do with the label and the names of the label are > L1,L2,L3……L22 > > > > Please help me on this. > > > > > > > > -- > Thanks and Reagrd’s > Shariq > > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > Thanks and Reagrd’s > Shariq Shazad Khan > 066979,9891184784 > > -- > > ---
Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop
Daneil, that is what i want but the same code is not working.in my sheet. what is Me.contol ? On Fri, Jul 8, 2011 at 10:22 PM, Daniel wrote: > Give a try at the attached file. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 18:17 > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > ** ** > > Daneil, > > > > This one "txtbox_val = Me.Controls("TB" & num).Value". > > > > This is not on the worksheet, i'm using one userform and on which i have > many texboxes.. but i'm not able to put the value in by using loop, once > this is done then i will link it to the sheet values. > > > > The main fight it how to dynamicly refer TB1,TB2,TB3..TB22 > > > > I really need to do thought loop as many time i have to disable it, enable > it clear the value of the textbox and putting values into the text box..** > ** > > > > > > > On Fri, Jul 8, 2011 at 6:05 PM, Daniel wrote: > > Didn’t you say the textboxes were in a userform ? if they are on a > worksheet, the syntax should be : > > > > With ActiveSheet > > For i = 1 To 22 > > txtbox_val = .OLEObjects("TB" & i).Object.Value > > Next i > > End With > > > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 13:11 > > > *À :* excel-macros@googlegroups.com > > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > > > Hi Daneil, > > > > Thanks but it didnt worked.. > > > > Run-time error '-2147024809 > > Could not find the specified object > > > > Thanks, > > Shariq > > On Fri, Jul 8, 2011 at 11:12 AM, Daniel wrote: > > Hi, > > > > Try : > > > > For num = 1 To 22 > > txtbox_val = Me.Controls("TB" & num).Value > > txtbox_num = num > > Next num > > > > Regards. > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 11:00 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ Need Help Help Help.Putting value in user > from by loop > > > > I’m trying to assign the value in excel user from thought loop. > > > > Name of the textboxes are TB1,TB2,TB3…….. TB22 . > > > > Below is the code which I’m using ,but its not working. > > > > For num = 1 To 22 > > txtbox_val = "TB" & num & ".value" > > txtbox_val = num > > End If > > Next num > > > > > > The same thing I wanted to do with the label and the names of the label are > L1,L2,L3……L22 > > > > Please help me on this. > > > > > > > > -- > Thanks and Reagrd’s > Shariq > > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group
Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop
hay Thanks Daneil. On Sat, Jul 9, 2011 at 5:53 PM, Daniel wrote: > There is no « TB17 » textbox and that’s why you get an error. > > ** ** > > Regards. > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* samedi 9 juillet 2011 13:01 > *À :* excel-macros@googlegroups.com; dcolarde...@free.fr > > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > ** ** > > Please find the attached workbook. on login page use "Mudit Sharma" as > user name and password is nothing. > > > > On "Credentials Required!" tab i have create a "Test Button" and trying to > fill the counts. > > > > > On Sat, Jul 9, 2011 at 2:58 PM, Daniel wrote: > > “Me” represents the object containing the code ; so, in this case, « me » > is equivalent to “Userform2”. Can you post your workbook ?**** > > > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* samedi 9 juillet 2011 00:32 > > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > > > Daneil, that is what i want but the same code is not working.in my > sheet. > > > > what is Me.contol ? > > > > On Fri, Jul 8, 2011 at 10:22 PM, Daniel wrote: > > Give a try at the attached file. > > > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 18:17 > > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > > > Daneil, > > > > This one "txtbox_val = Me.Controls("TB" & num).Value". > > > > This is not on the worksheet, i'm using one userform and on which i have > many texboxes.. but i'm not able to put the value in by using loop, once > this is done then i will link it to the sheet values. > > > > The main fight it how to dynamicly refer TB1,TB2,TB3..TB22 > > > > I really need to do thought loop as many time i have to disable it, enable > it clear the value of the textbox and putting values into the text box..** > ** > > > > > > > On Fri, Jul 8, 2011 at 6:05 PM, Daniel wrote: > > Didn’t you say the textboxes were in a userform ? if they are on a > worksheet, the syntax should be : > > > > With ActiveSheet > > For i = 1 To 22 > > txtbox_val = .OLEObjects("TB" & i).Object.Value > > Next i > > End With > > > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 13:11 > > > *À :* excel-macros@googlegroups.com > > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > > > Hi Daneil, > > > > Thanks but it didnt worked...... > > > > Run-time error '-2147024809 > > Could not find the specified object > > > > Thanks, > > Shariq > > On Fri, Jul 8, 2011 at 11:12 AM, Daniel wrote: > > Hi, > > > > Try : > > > > For num = 1 To 22 > > txtbox_val = Me.Controls("TB" & num).Value > > txtbox_num = num > > Next num > > > > Regards. > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 11:00 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ Need Help Help Help.Putting value in user > from by loop > > > > I’m trying to assign the value in excel user from thought loop. > > > > Name of the textboxes are TB1,TB2,TB3…….. TB22 . > > > > Below is the code which I’m using ,but its not working. > > > > For num = 1 To 22 > > txtbox_val = "TB" & num & "
$$Excel-Macros$$ XML and VBA
Hi All Excel Experts, I want to create, read and update XML file using VBA. Can some one share an explain how to create a XML file and read or manipulate XML file. Thanks in advance. Shariq -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel