$$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

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

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

$$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$$ 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

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

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

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

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

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

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

$$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

$$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

$$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 --