$$Excel-Macros$$ Re: Query Question with Excel Stock File

*I forget to attach the file which I'm doing now.* On Saturday, February 15, 2020 at 3:04:56 PM UTC-5, Mike C. wrote: > > I am working on creating an Excel file that will pull data from > barcharts.com for stocks listed in this Excel file and what I'm trying to > have

$$Excel-Macros$$ Query Question with Excel Stock File

I am working on creating an Excel file that will pull data from barcharts.com for stocks listed in this Excel file and what I'm trying to have it do is automatically show if it's a "sell", "strong sell", "buy", "strong buy", "weak buy", etc. and then either say that like it already does in colu

$$Excel-Macros$$ Macro to export Table Titles/Headers AND the contents of each table from Word to Excel

I am looking for a Macro to export the contents of every table in a Word document(s) and move this content to Excel. Along with pulling the contents of the tables however, I would like the titles of each of these tables to be exported as well. The Word document(s) are formatted in a table of

$$Excel-Macros$$ Unable to use a user defined fintion in a sql statement connecting to a worksheet

Hi, while I do have experience in vba Access I am new in writing VBA for excel. In access one can write and call public UDF in a sql statement. Is it possible to do so in Excel. I wrote a the UDF calcT1redemption which I have tested and works but when I call it from the sql statement below it s

$$Excel-Macros$$ Industrial Security Systems in Bangalore

*Industrial Security Systems in Bangalore* Security and police investigation Services AFL offers end-to-end security system solutions together with securitystyle and consulting, product management, remote observation and support and maintenance http://www.busybizz.com/security-systems-bangal

$$Excel-Macros$$ Re: Long if-then function? HELP

Ha, Paul found a typo in my code that solved my problem... phew! On Tuesday, February 25, 2014 3:45:33 PM UTC-5, Sara C wrote: > > Hi, > > I'm using a VBA macro for an invoice for a service, where the price per > hour of the service depends on 4 variables: location, type o

$$Excel-Macros$$ Long if-then function? HELP

Hi, I'm using a VBA macro for an invoice for a service, where the price per hour of the service depends on 4 variables: location, type of worker, time of service, and type of service. Each of these variables only has a few possible values which are contained in cells the function references. R

$$Excel-Macros$$ Need Help With VBA using VLookup

Good morning VBA masters. Let me start off by saying I am not a VB expert by any means. I am getting a bit better with modifying small things here and there, but I am absolutely lost when it comes to writing code from scratch. That being said, I have a code that works fine, but I am trying t

Re: $$Excel-Macros$$ Importing Excel Files

t; The destination sheets "Sheet FileA", "Sheet FileB"... are already existing. Thank you! On Saturday, 4 January 2014 13:18:18 UTC-5, ashish wrote: > > how many files are in folder .. can u share some full names of few files > and sheets thy need to go into >

Re: $$Excel-Macros$$ Importing Excel Files

FileB" cell A1 to Z3000 If file name starts with "FileC" and ends with "Raw", then import to "Sheet FileC" cell A1 to Z3000 So user only needs to select the folder and click import once to trigger all these jobs. Thanks again. :) On Monday, 30 December 2013 18

Re: $$Excel-Macros$$ Importing Excel Files

t;> Application.GetOpenFilename ("All Excel File (*.xls*),*.xls*") >> >> >> On Sun, Dec 29, 2013 at 8:49 PM, Linda C >> > wrote: >> >>> Hi Ashish, >>> >>> Is it possible to actually show all the excel files (both .xls and .xlsx &g

Re: $$Excel-Macros$$ Importing Excel Files

would be easier if I can actually see the files in the "Please select the folder" box. Thanks a lot! Linda On Saturday, 28 December 2013 09:55:28 UTC-5, Linda C wrote: > > Thank you Ashish! > > I will look at the file and will let you know if I have further questions. &g

Re: $$Excel-Macros$$ Importing Excel Files

first combobox > > > 2 choose the sheet name from 2nd combo box > > 3 click on import button to import data > > Regards > Ashish > > > > On Sat, Dec 28, 2013 at 3:34 AM, Linda C > > wrote: > >> Yes, there is only one sheet in those import files. &g

Re: $$Excel-Macros$$ Importing Excel Files

Yes, there is only one sheet in those import files. Thanks! On Friday, 27 December 2013 12:21:09 UTC-5, ashish wrote: > > excel files will have only one sheet right? > > > On Fri, Dec 27, 2013 at 10:48 PM, Linda C > > wrote: > >> Hi ashish, >> >>

Re: $$Excel-Macros$$ Importing Excel Files

mber 2013 11:42:49 UTC-5, ashish wrote: > > Is ur range fixed and do you want to append also or add the data in > seperate tabs only > Sent on my BlackBerry® from Vodafone > -- > *From: * Linda C > > *Sender: * excel-...@googlegroups.com

$$Excel-Macros$$ Importing Excel Files

Hello, I have trouble creating a macro to import excel files into an active workbook with UI. Let's say there are multiple excel files (.xlsx) in the folder "C:\Import Files". These files have the following file names: "FileA_Main.xlsx" "FileA_Sub.xlsx" &quo

Re: $$Excel-Macros$$ Excel data to convert xml

Please can any one help me on help me on below issue. Thanking in advance. On Nov 28, 2013 9:03 AM, "SHRINIVAS C A" wrote: > Dear all, > > I have some data in excel first row, want convert into XML file. > > Requesting you to advice on the same. > > -- > Are yo

$$Excel-Macros$$ Excel data to convert xml

Dear all, I have some data in excel first row, want convert into XML file. Requesting you to advice on the same. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

Hi Ashish, Thank you, your suggestion works perfectly! Thanls again for the prompt response! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advic

$$Excel-Macros$$ Need help with code to automate copy/paste

Hi everybody! I am hoping someone may be able to jelp me out. I am trying to write a macro that will take a formula that i write and copy it, move to the right seven spaces, paste, move seven spaces again, paste, ect.. Right now I need to have the formula pasted all of the way through column AZZ.

Re: $$Excel-Macros$$ Need VBA for repeating copy and paste special

Hi Kris - Thank you for the reply, I tried out your code and it works perfectly! Thank you all again for your responses! On Mar 9, 12:18 am, Kris wrote: > > Hi > > Try this > > Sub kTest() > >     Dim wksFrom     As Worksheet >     Dim wksTo       As Worksheet >     Dim i           As Long >

Re: $$Excel-Macros$$ Need VBA for repeating copy and paste special

).Copy > Sheet1.Range(Cells(1, i), Cells(LR, i)).Copy > Sheet2.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial > Paste:=xlValues, Transpose:=True > Next > End Sub > > HTH > Mahesh > > > > On Thu, Mar 8, 2012 at 8:54 PM, Erick C wrote: > > Hi

$$Excel-Macros$$ Need VBA for repeating copy and paste special

Hi everybody - I am hoping someone may be able to help me out. I am still quite a novice with writing VBA, so I am sure there is an easy way to make what I am trying to do. I am working in Excel 2010. I have a spreadsheet with a tab that has data vertically from column A through column ZW. I am

RE: $$Excel-Macros$$ Number Formats in French

o compensate for the work around. Regards, Sam On Mon, Oct 31, 2011 at 8:36 PM, Boucher, Kent C mailto:kent.bouc...@tbs-sct.gc.ca>> wrote: The format that you provided is really good but I have one other issue. What I have been doing is taking a very large number (in the millions) and I hav

RE: $$Excel-Macros$$ Number Formats in French

36 PM, Boucher, Kent C mailto:kent.bouc...@tbs-sct.gc.ca>> wrote: The format that you provided is really good but I have one other issue. What I have been doing is taking a very large number (in the millions) and I have reducing by millions and then rounding. Here is an examp

RE: $$Excel-Macros$$ Number Formats in French

The format that you provided is really good but I have one other issue. What I have been doing is taking a very large number (in the millions) and I have reducing by millions and then rounding. Here is an example: English accounting: 1) $4,333,222 -> =round((4,333,222/1,000,000),2) 2)

RE: $$Excel-Macros$$ Number Formats in French

Worked perfectly - thank you so much for your help Chethan and Sam - truly appreciated!!! Thank you, Kent From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B.N.Chethan Kumar Sent: October 28, 2011 5:38 PM To: excel-macros@g

RE: $$Excel-Macros$$ Hidden Columns and Save Location

u can, To all the people you can, As long as ever you can." - John Wesley - From: "Boucher, Kent C" To: "excel-macros@googlegroups.com" Sent: Wed, September 28, 2011 2:31:59 PM Subject: RE: $$Excel-Macros

RE: $$Excel-Macros$$ Hidden Columns and Save Location

kb.Path & "/" & Left(wkb.Name, InStrRev(wkb.Name, "")) & ".xls" with ur path "c:\" etc On Wed, Sep 28, 2011 at 9:11 PM, HarryP Knuckles mailto:kent.bouc...@tbs-sct.gc.ca>> wrote: Good morning guys, You guy

RE: $$Excel-Macros$$ Template to modify workbooks

11 1:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Template to modify workbooks hi Kent Try this one On Tue, Sep 20, 2011 at 10:31 PM, Boucher, Kent C mailto:kent.bouc...@tbs-sct.gc.ca>> wrote: Hi Ashish, The workbook that you sent back looks awesome

RE: $$Excel-Macros$$ Template to modify workbooks

rectory as of source file to view the code of this macro press single space On Tue, Sep 20, 2011 at 8:30 PM, Boucher, Kent C mailto:kent.bouc...@tbs-sct.gc.ca>> wrote: Thank you Ashish - Yes I just send a copy of the workbooks to them to have them posted. I believe the workbook is up n

RE: $$Excel-Macros$$ Template to modify workbooks

o all the people you can, As long as ever you can." - John Wesley - From: "Boucher, Kent C" To: "excel-macros@googlegroups.com" Sent: Tue, September 20, 2011 10:11:59 AM Subject: RE: $$Excel-Macros$$ Template to modify workbooks Hi Paul - thanks so mu

RE: $$Excel-Macros$$ Template to modify workbooks

elp is greatly appreciated!!! > > > ___ > > > > > Private Sub Workbook_Activate() > > Application.CutCopyMode = False > > Application.OnKey "^c", "" >

$$Excel-Macros$$ Need Help With an Imput Box in VBA

Any help I can get would be greatly appreciated. Thanks! Erick C. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Link

$$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

Dear All, I have attached sheet contains my query on Data Validation - Create a drop down list containing only unique -- *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Login Logout Report Help Required...

It's Working Daniel ...Thanks a lot. *Best Regards,* *Venkat* On Sat, Jul 23, 2011 at 8:19 PM, Daniel wrote: > Hi, > > ** ** > > Run the following macro : > > ** ** > > Sub LoginLogout() > > Dim c As Range > >

Re: $$Excel-Macros$$ Urgent Help needed-Dashboards

Hi Avinash, Try below Links, http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/ http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/ http://www.contextures.com/excel-dashboards.html http://www.mrdashboard.com/download.html -- *Best Regards,* *Venkat* * * On Thu,

Re: $$Excel-Macros$$ Change e-mail settings

Hi, Just Go to Below link and sign in your Gmail account..and set as a https://groups.google.com/group/excel-macros/subscribe?hl=en and go to Edit my membership --->Email *(Approximately 15 emails per day)*Send each message to me as it arrives and save it... -- *Best Regards,* *Venkat* * * O

$$Excel-Macros$$ Login Logout Report Help Required...

Dear All, I Have attached data sheet with Login Logout timings..i want how much time they were in work...Pure Login hrs have tried one formula...it's working for first 2 Employess not working for all... Please suggest any formula or VBA code... Example: Data: User Name Status Login & Lo

Re: $$Excel-Macros$$ Books

Hi, Check The Below link http://www.mrexcel.com/articles.shtml#Charts -- *Best Regards,* *Venkat* * * On Tue, Jul 19, 2011 at 11:37 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I need a book about graphs/charts only. Thanks! > > On Wed, Jul 13, 2011 at 7:15 PM, Vikas Chou

Re: $$Excel-Macros$$ Speedo Meter Chart

Hi , Please Look below Link http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm *Best Regards,* *Venkat* On Tue, Jul 19, 2011 at 11:36 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > Any suggestion please. > > On Mon, Jul 18, 2011 at 2:31 P

$$Excel-Macros$$ Job

From:""iGATE Global Solutions""< supreet.sa...@igatepatni.com > Date: 18 Jul 11 20:41:03 Subject: iGate Patni hiring Senior Team Leads for WFM-Forecasting_Bangalore location To: Job Location: Bengaluru/Bangalore Dear Candidate, We have few openings in BPO division.Please find details: Work lo

Re: $$Excel-Macros$$ Re: Check Boxs on Document

Please Attach There is No Attachment... *Best Regards,* *Venkat* * * On Mon, Jul 18, 2011 at 11:48 AM, Rsh wrote: > Please help me in reducing the code in the attachment above.. > > Thnx in advance > > -- > > -- >

Re: $$Excel-Macros$$ Simple Code

Hi sharad, look attached..it may Help you... -- *Best Regards,* *Venkat* * * On Sun, Jul 17, 2011 at 5:22 PM, sharad jain wrote: > Hi Guys, > > Can someone please send me a simple code for round off to nearest 10? (No > macro if possible.) > > For example, if I put 23 in A1, it should result

Re: $$Excel-Macros$$ MS Access

Hi Siva, You Can Post your MS Access Query's in this group it self... * * *Best Regards,* *Venkat* On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S wrote: > Hi Smarts, > > Good day.. > > Could you send me googlegroup id for MS Access.. > > -- > Thanks > Siva > > -- > > --

Re: $$Excel-Macros$$ Need Formula

Hi Rahim, Look attached file . *Best Regards,* *Venkat* On Thu, Jul 14, 2011 at 10:35 PM, Rahim Sharieff wrote: > Hi Experts, > > Please refer the attached workbook. > > The first sheet here "Schedule" gives the training requirements and > Training batches, and the second sheet "Trainin

Re: $$Excel-Macros$$ Regression Analysis in Excel

ykes_.Regression.pdf > http://en.wikipedia.org/wiki/Regression_analysis > > http://office.microsoft.com/en-us/excel-help/perform-a-regression-analysis-HA00963.aspx > > > > On Thu, Jul 14, 2011 at 2:49 PM, Venkatesan c wrote: > >> Dear All, >> Can any one help me on R

$$Excel-Macros$$ Regression Analysis in Excel

Dear All, Can any one help me on Regression Analysis in Excel with sample data.. *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : htt

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Hi Jai, Look Attached below.. On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailyti

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

Congrats *Ashish,* * * * * -- *Best Regards,* *Venkat* * * On Tue, Jul 5, 2011 at 10:59 AM, Kal xcel wrote: > Congratulation Ashish...You deserve it > > Kalyan > > > On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal wrote: > >> [image: >> http://tracking.technodesignip.com/?action=c

Re: $$Excel-Macros$$ workbook location on status bar

Pascal, Yes you are right I have said for 2007 &2010 Version... *Best Regards,* *Venkat* * * On Tue, Jul 5, 2011 at 4:05 AM, netuser501 wrote: > thanx, > > Venkat solution is most practical for 2007 since it works on all > workbooks that work and don't work with vba code. > I guess the

Re: $$Excel-Macros$$ copy data without opening file

Hi, Just Try Copy &Paste it will work... *Best Regards,* *Venkat* * * On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde wrote: > Hi friends, > > is there any way where we can copy data from closed workbook "A" and paste > it > into workbook "B" which is open? > > -- > > -

Re: $$Excel-Macros$$ Recovery plz

Hi just install the software and just open that software and click Remove Password...Before that you have to open Locked VBA Book.. -- *Best Regards,* *Venkat* * * On Mon, Jul 4, 2011 at 6:32 PM, Chandra Shekar wrote: > How to use this software? > > Thanks, > > Chandra Shekar B > > On Fri, D

Re: $$Excel-Macros$$ count unique values

Hi, Attach Some data ..and send will try.. *Best Regards,* *Venkat* * * On Mon, Jul 4, 2011 at 3:47 PM, airen wrote: > Hi, > i want to count unique values in a selection. I got this formula on > net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont > know how it works. So pl

Re: $$Excel-Macros$$ Assistance required

Hi Vikas, Look the Below Link http://excelvbatutor.com/vba_tutorial.html *Best Regards,* *Venkat* * * On Sun, Jul 3, 2011 at 3:39 PM, vikas verma wrote: > > Hi All, > > I am good with excel 2007 now I want to learn VBA coding in order to create > automation tool. Please suggest some ideas

Re: $$Excel-Macros$$ Sumif across multiple worksheets

gt; Nesting can be an issue if you use more references here. > > > > Let me know if this works. > > > > Thanks, > > DILIPandey > > > > On 7/1/11, Susan 1 wrote: > > > > > > > > > > > > > > > > > > > >

Re: $$Excel-Macros$$ I want to learn VBA

is getting a book > dedicated > >>>>> on vba...becoz they provide step wise and detailed concepts > >>>>> there are many free ebooks on vba on the internet.download it > >>>>> ...learn basic from there ...and then make reference from

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

*Dear Asish,* * * *Congrats...* * * *Best Regards,* *Venkat* * * On Fri, Jul 1, 2011 at 9:25 PM, Ayush wrote: > Dear Group, > I am extremely happy to share a good news with you. One of our dearest > group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for > his exceptional M

Fwd: $$Excel-Macros$$ I want to learn VBA

Hi Pooja, Just watch the below link Youtube video's you may get VBA Basic&Advancedconcepts http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb *Best Regards,* *Venkat* * * On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma wrote: > Hi All, > > I want to learn VBA, therefore, could an

Re: $$Excel-Macros$$ I want to learn VBA

Hi Pooja, Just watch the below link Youtube video's you may get VBA Basic&Advancedconcepts *Best Regards,* *Venkat* * * On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma wrote: > Hi All, > > I want to learn VBA, therefore, could anybody suggest with a good link > where I can learn it. > > -- >

Re: $$Excel-Macros$$ How To Concatenate the Cell without loosing the format

Hi Ak, Find attached your query resolved *Best Regards,* *Venkat* On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari wrote: > Hi Experts, > > > > I want to concatenate the different cells without losing the format of the > cells. Please refer the excel sheet for more details. > > Thanking you

Re: $$Excel-Macros$$ Unprotect Sheet in Excel 2007

> On Tue, Jun 28, 2011 at 3:38 PM, SANJAY SONI > wrote: > >> Dear Venkar, >> >> I think the attached file can resolve your problem..It will remove your >> passward. >> >> * >> Best Regards, >> * >> *Sanjay ** >> * >&

Re: $$Excel-Macros$$ Single Pivot from More than one worksheet

gt; > Thanks !! > > On Tue, Jun 28, 2011 at 11:58 AM, Venkatesan c wrote: > >> Hi Deepak, >> >> Find attached html file .for your queryYou prepare single pivot from >> more than one.data >> >> *Best Regards,* >> *Venkat* >> On Tue, J

Re: $$Excel-Macros$$ Unprotect Sheet in Excel 2007

aR1C1 = Chr(i) & Chr(j) & _ > Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _ > Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) >Exit Sub > End If > Next: Next: Next: Next: Next: Next > Next: Next: Next:

$$Excel-Macros$$ Unprotect Sheet in Excel 2007

Dear All, I want any VBA code or some tool to Unprotect Sheet in Excel 2007 I forgot the password.. *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri

Re: $$Excel-Macros$$ HaPpY BirthdaY - Sir Paul Schreiner

* Dear Paul, ** Happy Birthday Wishes to you * -- *Best Regards,* *Venkat* * * On Mon, Jun 27, 2011 at 8:30 AM, OpenExcel.com <26may.1...@gmail.com> wrote: > Wish you many many Happy Returns of the Day :) Enjoy :) > > HappY BirthdaY :) > > > Best Regards > Ashish Jain > eXceLiTems

Re: $$Excel-Macros$$ Help on Percentile Function

Dear Prashant, Please look below links... http://www.techonthenet.com/excel/formulas/percentile.php http://office.microsoft.com/en-us/excel-help/percentile-HP005209211.aspx *Best Regards,* *Venkat* * * On Mon, Jun 20, 2011 at 6:16 PM, Prashant wrote: > Dear Experts, > > ** ** > > Need he

$$Excel-Macros$$ Call Center Inbound&Outbound Manpower scheduling

Dear All, Can any one have templates or websites for Call Center Inbound&Outbound Manpower scheduling. -- *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hari, Find attached *Best Regards,* *Venkat* * * *Join My Group: http://groups.google.com/group/excel-miracle * On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR wrote: > I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE

Re: $$Excel-Macros$$ How to record a macro

Dear Ritesh, Watch Below Link http://www.youtube.com/watch?v=KKJj78LoFaA On Sat, Jun 18, 2011 at 8:20 PM, Susan wrote: > http://www.excel-vba-easy.com/ > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Ritesh Jain > S

Re: $$Excel-Macros$$ Beginer to Excel-VBA

On Fri, Jun 17, 2011 at 6:00 AM, Venkatesan c wrote: > Dear Hari, > > Just watch the below link video's you may get Some of basics in Excel VBA > > http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb > > Best Regards, > > Venkat > > > On

Re: $$Excel-Macros$$ Pad zeros

Hi Skanda, Please use Below formula for our query. =REPT(0,(9-LEN(B4)))&B4 *Best Regards,* *Venkat* On Fri, Jun 17, 2011 at 3:46 AM, Skanda wrote: > Hi, > How to add zeros in front of a value with varying lengths so that the > length of the column is 9? > for instance a column policy id has

Re: $$Excel-Macros$$ Beginer to Excel-VBA

Dear Hari, Just watch the below link video's you may get Some of basics in Excel VBA http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb Best Regards, Venkat On Thu, Jun 16, 2011 at 8:35 PM, Hari wrote: > > Dear Friends, >Can any one please help me in *"how to learn Excel-VBA"*

Re: $$Excel-Macros$$ excel query

Hi Azeema, Send the sample data and some one will assist the query.. Best Regards, Venkat.. On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote: > I have a table in excel of # of employees by age, sex and category of > employment. The ROWs have three diff categories by sex and the COLU

Re: $$Excel-Macros$$ how to put password in vba coding.??

Hi Kannan, Please go to Module--->VBA Project Properties--->Protection--->Give Password The above way is to protect VBA Project... *Best Regards,* *Venkat* On Wed, Jun 15, 2011 at 2:09 PM, kannan excel wrote: > Hi Guru... > > how to put password in vba coding.?? > > how to protect that? > >

$$Excel-Macros$$ Excel Tips&Tricks Video's Link...

Dear All, Please watch below link in YouTube you may get hundreds of Excel Tips &Tricks... With Excel Sample Excel Workbooks Also [image: image.png] *http://www.youtube.com/user/ExcelIsFun?blend=1&ob=5* * * *Best Regards,* *Venkat* -- -

Re: $$Excel-Macros$$ Index, Match, Vlookup Memory Cards [Free downloads]

Dear Ayush, Thank for good share of tutorial Regards, Venkat On Fri, Jun 10, 2011 at 10:13 PM, Ayush wrote: > Well, he's done it again. My good friend John Franco just uploaded these free > lookup syntax mastery > downloadsfor you. > To be hones

$$Excel-Macros$$ SQL Server Group

Dear All, I want SQL Server Group something like our excel-macros group. Can anyone send me the links.. Thanks in Advance.. *Best Regards,* *Venkat* -- -- Some important links for excel users: 1. Follow us on TWIT

excel-macros@googlegroups.com

Thank U On Mon, Feb 21, 2011 at 12:35 PM, saggi wrote: > Just Go on DATA ribbon in Xl, Then Other Sources, then Give the path > of SQL table this exercise need to done once. > > after onward same u can pull from Existing Connection just need to > given Username & Password. > > Regards >

excel-macros@googlegroups.com

any clarification on the same. > > > > On Sat, Feb 19, 2011 at 2:59 AM, Venkatesan c wrote: > >> Dear All, >> >> I want to Export data to Excel 2007 from SQL Server 2000 tab

excel-macros@googlegroups.com

Dear All, I want to Export data to Excel 2007 from SQL Server 2000 table.Kindly help on this. -- *Regards,* *Venkat* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

1, then a Cell Function would be: > =B1&REPT("_",6-LEN(B1)) > (or using " " to pad with spaces. > > In VBA, your solution would be: > > StrOut = StrOut & StrDelim _ > & Cells(R, 33).Value & _ > Application.WorksheetFunction.Rept(" &

$$Excel-Macros$$ Need Help Getting Text To Align Left

Hello everybody, I am in desperate need of some assistance, and I am hoping someone may be able to give me a hand. I am still a bit of a novice when it comes to vba code writing, so I am hoping that it may just be something that I am not aware of. I have some code that makes a string of text usin

$$Excel-Macros$$ Need help with text alignment in VBA string

I am hoping someone can help me out with a problem that I am having. I have a macro that I am working on in Excel 2003 right now that takes multiple fields from a spreadsheet and makes a text string. It was working great, until I had to add a few fields that were deemed necessary to have. I have t

Re: $$Excel-Macros$$ New Rupee Symbol

Hi Vijay, Can i know from where you downloaded the font. I am usning 2007 excel. Thanks Manjunath On Sun, Dec 19, 2010 at 1:35 PM, P.VIJAYKUMAR wrote: > Dear Kumar, > > > After installing the font the Rupee Symbol appears only if Rupee Foradian > font is selected and ~ is pressed you can have t

$$Excel-Macros$$ Hi - Number need to fill randomly

Hi Team, I need to fill the highlighted(brown) coloumn with numbers 1 to 90 randomly by clicking the button "Press" each time. Finally we need the data as highlighted in yellow. Thanks Manjunath -- -- Some important

Re: $$Excel-Macros$$ Reqd : Add in to convert Numbet to text in Excel 2007

Yes its workingThanks On Tue, Dec 7, 2010 at 5:32 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > > hello Radhe, > > Please find the attached addin.. > > Hope this helps you.. > > Regards, > Raj > > > On Tue, Dec 7, 2010 at 2:43 PM, Radhe Sham wrote: > >> H

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

Hi, I am unable to download the OPEN XL, can any one help the procedure On Tue, Dec 7, 2010 at 5:52 PM, Radhe Sham wrote: > Hi Ashish, > > Many thanks for the kind help in providing valuable information about > Openexcel. > > Probably the communication from my side was not clear > > The help i

Re: $$Excel-Macros$$ Need help on excel sheet

ut it on one sheet, > then saving a new workbook with only one sheet? > > > > --- On *Tue, 11/30/10, Manjunath C * wrote: > > > From: Manjunath C > Subject: $$Excel-Macros$$ Need help on excel sheet > To: excel-macros@googlegroups.com > Date: Tuesday, November 30, 201

$$Excel-Macros$$ Need assistance in macro training

Hi , This is Manjunath from chennai, I am more interested to learn Macro. Can any one help me how to learn macro with the begining stage. Or suggest me if any trainer or institution in chennai. more appreciated in advance for you assistance. Thanks Manjunath -- ---

$$Excel-Macros$$ Need it in seperate excel sheets

Hi Can anyone help me, as I Have data in each tab, I need it in sperate excel sheet. Any macros available - appreciate your help in advance. Thanks Manjunath -- -- Some important links for excel users: 1. Follow us

$$Excel-Macros$$ Need help on excel sheet

Hi All, Can anyone help me, I have data in 5 tabs, now i need to make it in seperate excel sheet and paste it local desktop. Any macros available - appreciate your help in advance. Thanks Manjunath -- -- Some impor

Re: $$Excel-Macros$$ Please help regard this question

Excellent one,,,its working Is it possbile , the result should be 0 , if i give same dates for both. On Fri, Nov 12, 2010 at 9:53 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > =IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & > IF(MONTH(A1) - MO

Re: $$Excel-Macros$$ Re: Excel Encyclopedia ppt

Excellent one Vijay,Thanks a lot,, I need a help on the below one,, is it possible to get a formula to solve this I need all the data in the column B for the name raju, (no sum or no count) result should be in each field one data (as in master data) Hi, I need a formula for t

$$Excel-Macros$$ Delete rows including blank row except few members

e = "" Then Range("A" & i).EntireRow.Delete If UCase(Range("A" & i).Value) = "C" Then Range("A" & i).EntireRow.Delete If UCase(Range("A" & i).Value) = "D" Then Range("A" & i).EntireRow.Delete If UC

Re: $$Excel-Macros$$ Delete rows including blank row except few members

.Value = "" Then Range("A" & i).EntireRow.Delete If UCase(Range("A" & i).Value) = "C" Then Range("A" & i).EntireRow.Delete If UCase(Range("A" & i).Value) = "D" Then Range("A" & i).EntireRow.Delete

Re: $$Excel-Macros$$ Excel Macro - Need help using Find and Selecting a range

> Range(ActiveCell.Offset(0, -1), Cells(ActiveCell.Row, > ActiveCell.SpecialCells(xlLastCell).Column)).Select > > try using that and see what you can do.. > > if you need more help, let me know. > > Paul > > > > - Original Message > > From: Erick C >

$$Excel-Macros$$ Excel Macro - Need help using Find and Selecting a range

Hi everybody - I am hoping someone can help me out with a problem I am having. I am very new to writing and recording macros, I have been trying to look at other macros that I use for different functions and tips. I have a macro that I am trying to get to do a few different things. The macro work

Re: $$Excel-Macros$$ Help Required Making Data into Muliple sheets

Dear Siti, Thanks a lot Best Regards, Venkat On Fri, Sep 24, 2010 at 3:47 PM, siti Vi wrote: > Sub splittabel() > ' siti Vi / jakarta, 24 sept 2010 > Dim RefTbl As Range > Dim DesTbl As Range > Dim sNames As String, ArrNames > Dim r As Long, n As Long, i As Lon

$$Excel-Macros$$ Re: I love excel because.......

Dear Group, Excel is the User friendly Application Compare then all Spread sheets &It's Very much Easy to Handle New user's Too.. Best Regards, * Venkat * -- -- Some important links for excel users: 1. Fol

  1   2   >