$$Excel-Macros$$ XML and VBA

2011-07-27 Thread shariq khan
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 impo

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-09 Thread shariq khan
el-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 > > ** ** > &

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread shariq khan
ps.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 > > ** ** > > Dan

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread shariq khan
> > ** ** > > 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$$

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread shariq khan
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

$$Excel-Macros$$ need help help........Texbox of user form

2011-07-08 Thread shariq khan
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

$$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread shariq khan
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

$$Excel-Macros$$ How to send mail with excel

2011-03-29 Thread shariq khan
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,

$$Excel-Macros$$ Need to zip files

2010-09-23 Thread shariq khan
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 actu

$$Excel-Macros$$ Need Help in Cross tab

2010-08-21 Thread shariq khan
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 bet

$$Excel-Macros$$ Need connection String of oracle in Excel VBA

2010-05-29 Thread shariq khan
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 -- ---

$$Excel-Macros$$ Need help......

2009-06-27 Thread shariq khan
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 --~--~-~--~~~--