Re: $$Excel-Macros$$ Excel VBA Training

Hi Send details On Friday, July 28, 2017, Rajan Verma wrote: > > [image: Inline image 1] > > -- > 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 > > FORUM RULES

$$Excel-Macros$$ Excel VBA Training

[image: Inline image 1] -- 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 FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

$$Excel-Macros$$ Excel VBA Sharepoint checkout-checkin

I've Googled extensively and tested multiple options for more than 30 hours over the last couple of weeks. The results of my searches all LOOK reasonable, but all have failed to function properly. I have some SUSPICIONS as to why it's not working, but that doesn't lead me to solutions. Here's m

Re: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

, Mathan wrote: > > Thanks david ! > > --Original message-- > From: David Grugeon > > To: "excel-...@googlegroups.com " > > Date: Friday, May 10, 2013 12:08:12 PM GMT+1000 > Subject: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to &

Re: $$Excel-Macros$$ Excel VBA - to transpose records in a row to a new sheet (in columns)

You can use this, change Sheet1 and Sheet2 to your source and destination sheets respectively Sub NewRearrangeMacro() Dim wks As Worksheet, wks2 As Worksheet Dim Lrow As Long, I As Long, j As Long, k As Long Dim Colcount As Long Set wks = Worksheets("Sheet1") Set wks2 = Worksh

$$Excel-Macros$$ Excel VBA - to transpose records in a row to a new sheet (in columns)

Hi Excel Group, Please can you help me with an Excel Macro that process the entire information saved on Sheet 1, and generates a report on Sheet 2 Sheet 1 A B C D E F G 1 Door A2 B3 C2 L1 2 furniture B2 B3 3 TV A1 A2 4 Kitchen L2 L4 Z1 M2 R3 W5 (Total rows: 500, tota

$$Excel-Macros$$ Excel VBA data transfer to Website

Dear Experts: Do you know if Excel VBA has the capability to automate the transfer of data from a spreadsheet to a website (a web based database)? I have heard that Excel's API may be able to do it. Is that so? Thank you!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b

Re: $$Excel-Macros$$ excel-VBA-GEarth integrated but not able to display name for placemark through VBA,Plz HELP

Share the sample file On Nov 27, 2015 1:41 PM, "shilpag" wrote: > Hi > I have developed a small desktop application with excel data which > will be displayed on to Google Earth by VBA code. > The google earth is displaying coordinates (values are looped by macro ) > but i am not able to sho

$$Excel-Macros$$ excel-VBA-GEarth integrated but not able to display name for placemark through VBA,Plz HELP

Hi I have developed a small desktop application with excel data which will be displayed on to Google Earth by VBA code. The google earth is displaying coordinates (values are looped by macro ) but i am not able to show respective names for those coordinates , as getting Byref argument tyo

$$Excel-Macros$$ Excel VBA Macro to Identify and Mark Highest Number in a Group.

Hello All, I am using excel 2013. Please support with necessary VBA code to solve the below problem. I have an Excel work sheet with 29 Columns (AC) and multiple rows of data. Column-AC is a unique incremental number called “ID” and Column (B), called “Order”, which is an eight digit numb

Re: $$Excel-Macros$$ excel vba userform using & data store in access database

ou can, To all the people you can, As long as ever you can.” - John Wesley - From: Satendra kumar To: "xlvbacli...@googlegroups.com" ; excel-macros@googlegroups.com Sent: Friday, September 25, 2015 7:45 AM Subject: $$Excel-Macros$$ exce

$$Excel-Macros$$ excel vba userform using & data store in access database

Hi Everyone, I have created a userform where i want the data to be stored in access automatically, However i have written some code, where in start only i m getting error at the * Dim con as new adodb connection * Can some please tell me why is this error occurring, or how to come overview

$$Excel-Macros$$ Excel VBA - Alex Cantu contact

Hi ou Anyone have a contact for Alex Cantu re his 'smiley face' vba on Youtube Charles -- 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 FORUM RULES 1) Use conci

Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

Dear Gaurav, Thisworkbook and activeworkbook is same when comes to work but the difference is thisworkbook will work where the code is written and activeworkbook will work with active file On Mon, Mar 9, 2015 at 3:51 PM, Gaurav Devrani wrote: > Hi, > > I tried working on that.. while I was test

Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

Hi, I tried working on that.. while I was testing that , nothing such happend as you said that your other workbook started hidding sheets. Just wanted to See if you are using activeworkbook instead of thisworkbook. Let me know, if this is not the issue. I will see what i can do for that. And also

Re: $$Excel-Macros$$ Excel VBA Example

Its really good!! Cheers!! On Tue, Mar 3, 2015 at 8:02 AM, Nilkanth Raval wrote: > Hi Friends, > > Find attached some examples of VBA Macro > > *Thanks,* > *Nilkanth Raval* > *+91 900 428 0 428* > *+91 808 000 1620* > *Think Before You Print.Consider ENVIRONMENT.* > *“SAVE TREES, SAVE EARTH” *

Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

Dears Any solution, please ! On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad wrote: > > Hi Experts > > I have an excel workbook, say Workbook1 with a vba on its workbook_open > event to hide all worksheets except one, as follows: > > > -

$$Excel-Macros$$ Excel VBA Example

Hi Friends, Find attached some examples of VBA Macro *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE EARTH” * *“All appears to change when we change!”* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

$$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

Hi Experts I have an excel workbook, say Workbook1 with a vba on its workbook_open event to hide all worksheets except one, as follows: - Private Sub Workbook_Open() Dim sh As Worksheet For Eac

$$Excel-Macros$$ Excel VBA remove duplicates fails depending on how range specified

Hello all. First post. I'm not sure why the commented out way of specifying a range works while using myRange fails with a "run time error '438': Object doesn't support this property or method". I cannot call out the specific location because it will vary. Sub testRemoveDuplicates() Dim

$$Excel-Macros$$ Excel VBA Programming FOR Dummies 1st EDITION 2010

Dear Team You have ebook Excel VBA Programming FOR Dummies 1st EDITION 2010, Please send soft copy Thanks, Prabhakar Thakur New Delhi +919953736776 -- 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 @ ht

Re: $$Excel-Macros$$ excel VBA solution - offered at reasonable price

Excel VBA training needed online. Do you provide such services? On 28 Jul 2014 02:41, "Sara Lee" wrote: > Does any one need help in Excel VBA project or may be entire project to > be completed? > > Let me know. You will get the solution at a reasonable price whether u in > US or in India. > > I

$$Excel-Macros$$ excel VBA solution - offered at reasonable price

Does any one need help in Excel VBA project or may be entire project to be completed? Let me know. You will get the solution at a reasonable price whether u in US or in India. I am in US right now. -- 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

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

-- >> >> >> >> >> >> >> >> *“Do all the good you can,By all the means you can,In all the ways you >> can,In all the places you can, At all the times you can,To all the people >> you can,As long as ever you ca

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

esley - From: Ankur Gupta >To: excel-macros >Sent: Friday, June 20, 2014 12:22 PM >Subject: Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code > > > >hi Paul, > > >the person who wrote the code has left

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

ver you can.” - John Wesley* > - > > *From:* Anil Gawli > *To:* "excel-macros@googlegroups.com" ; > anky...@gmail.com > *Sent:* Friday, June 20, 2014 1:11 AM > *Subject:* Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot vie

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

> In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > - > > From: Anil Gawli > To: "excel-macros@googlegroups.com" ;

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

;excel-macros@googlegroups.com" ; >anky...@gmail.com >Sent: Friday, June 20, 2014 1:11 AM >Subject: Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code > > >Dear Ankur, > >Pl share the workbook with us. > >Warm Regards, >Gawli Anil. > >O

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

Dear Ankur, Pl share the workbook with us. Warm Regards, Gawli Anil. On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta wrote: > I am new to excel and absolutely a novice to vb. I have been given a task to > write macros code in vba in excel. The macro code is already there but > nobody knows the pa

$$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but nobody knows the password. So the button even in design mode doesnot show view code. I just want to view to code behind. I cant pass the sheet as it

$$Excel-Macros$$ Excel & VBA

Hi All, Must visit below mentioned ... Happy New Year 2014 Thanks & regards, -- 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 F

Re: $$Excel-Macros$$ Excel VBA Project in Google Docs

Friends,...any update? On Sat, Sep 7, 2013 at 11:21 AM, Abhishek Jain wrote: > Hello friends, > > Let's say I have an Excel File with VBA and an a Form that is used to make > entries in sheet. Is there a way I can make a Google Doc of it keeping the > Form and all the VBA? I searched and found t

$$Excel-Macros$$ Excel VBA Project in Google Docs

Hello friends, Let's say I have an Excel File with VBA and an a Form that is used to make entries in sheet. Is there a way I can make a Google Doc of it keeping the Form and all the VBA? I searched and found that Google docs do not support VBA but Java Scripts. Can someone share a way forward? On

Re: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

Thanks david ! --Original message-- From: David Grugeon To: "excel-macros@googlegroups.com" Date: Friday, May 10, 2013 12:08:12 PM GMT+1000 Subject: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer OK. To to this

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

I Sent from BlackBerry® on Airtel -Original Message- From: David Grugeon Sender: excel-macros@googlegroups.com Date: Fri, 10 May 2013 12:08:12 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel VBA code to handle "choose fi

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

OK. To to this you need to analyse the URL that is sent when you do it manually, then you need to construct an appropriate URL and make this a hyperlink.Then you can refer to the cell containing the hyperlink and open the hyperlink. It will be something like Range("A1").hyperlink.follow. Regards

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

see if it helps http://www.motobit.com/tips/detpg_uploadvbaie/ On Thu, May 9, 2013 at 12:30 PM, David Grugeon wrote: > In essence, internet explorer does not understand excel files. You could > save the file as a web page and load that. It would not have the > functionality of excel though. >

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

In essence, internet explorer does not understand excel files. You could save the file as a web page and load that. It would not have the functionality of excel though. There are some proprietary products which allow you to run excel spreadsheets through a browser. They cost though! Min $500,

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

Hi David/Anil, We are trying to upload the excel file through excel vba. The files are from common shared folder not on the local drive. I hope this helps, However, I will share the screenshot by tonight. Thanks for your time. Thanks On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote: > I

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

IN particular we need to know what type of file is it that you want to "Upload". Is it an internet file like .html, .asp .php etc or is it an excel XLS file, xlsm, xlsb, etc. or perhaps a different type. Then we need to know if there is an internet server running on the site where the file is loc

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

Dear Manthan, Pls Elaborate More with Eg. Warm Regards, Gawli Anil On Thu, May 9, 2013 at 2:26 AM, Mathan wrote: > Hi Experts, > > I'm trying to upload a file from shared folder (directory) to the internet > explorer. > > Need a VBA code to do this. Could anyone help me on this? > > Thanks i

$$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

Hi Experts, I'm trying to upload a file from shared folder (directory) to the internet explorer. Need a VBA code to do this. Could anyone help me on this? Thanks in advance. -- 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 Face

Re: $$Excel-Macros$$ Excel-VBA QUIZ

Hi Noorain, Thanks for arranging Quiz-2. It helps us to analyze where we are.. And now eagerly waiting for result as today is the 5th day of this contest n also waiting to know for how many members takes part in this Quiz contest n whats our score.. And Ashish Sir & other friends here please tak

$$Excel-Macros$$ Excel-VBA QUIZ

Dear Group, Hope you are doing well. Now You have a new Quiz, Please solve, revert and analyze where you are? Quiz Link is here : Note: You have to write full form of Excel,VBA and MS Access Keywords. Quiz-2

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

r you can.” - John Wesley - From: Prince To: excel-macros@googlegroups.com Sent: Fri, March 8, 2013 12:00:35 AM Subject: Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint Hi Paul, I think the solutions given by Sam and Me are corr

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

; > excel-...@googlegroups.com > > *Sent:* Mon, March 4, 2013 4:11:32 PM > *Subject:* Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or > Sharepoint > > Hi Paul > > Helen Feddema's book Access : Working with excel covers all this and much > more. If you w

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

the people you can, As long as ever you can.” - John Wesley - From: David Grugeon To: "excel-macros@googlegroups.com" Sent: Mon, March 4, 2013 4:11:32 PM Subject: Re: $$Excel-Macros$$ Excel VBA to retrieve from M

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

Hi Paul Helen Feddema's book Access : Working with excel covers all this and much more. If you want it for $10 instead of $17 you have to subscribe for the free newsletter Access Watch. http://shop.office-watch.com/awe/fasttrack.aspx On Tuesday, 5 March 2013, Paul Schreiner wrote: > I may regre

Re: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

Wow That is neat. Thanks I need to try and remmember that. On Thursday, July 26, 2012 12:56:39 AM UTC-4, अनिल नारायण गवली wrote: > Dear Tony, > > U can use without macro > Just select the range and press ctl+G of press F5 function key . > Then click to blank cell and use Alt+E+D select the

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

This has most of it http://www.excelfox.com/forum/f13/execute-sql-excel-vba-66/ Regards, Sam On Mon, Mar 4, 2013 at 11:50 PM, Paul Schreiner wrote: > I may regret asking this, but here goes: > > Using Office 2010: > > I have Excel templates that are used to create documents and store the > dat

$$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

I may regret asking this, but here goes: Using Office 2010: I have Excel templates that are used to create documents and store the data in an Oracle database. The Oracle database has data from "released" and "archived" or "historical" documents. These documents are saved as PDF's and stored

Re: $$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

Dear Yahya, Pls visit on below link,hope it will help to you. http://www.ozgrid.com/forum/showthread.php?t=66674 On Wed, Jan 30, 2013 at 12:49 AM, Yahya Muhammad wrote: > > Dear Ashish > > This is what I want. But could not make it work in my file, which is > attached. Please help. > > > On T

Re: $$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

Dear Yahya Muhamma & Anil, Sorry for that,I will post my query in a separate thread: Amar On Tue, Jan 29, 2013 at 6:14 PM, amar takale wrote: > Hi Anil, > Sorry for that,I will post my query in a separate thread: > Amar > > On Tue, Jan 29, 2013 at 4:41 PM, Yahya Muhammad wrote: >> Dear Amar >> >

Re: $$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

Hi Anil, Sorry for that,I will post my query in a separate thread: Amar On Tue, Jan 29, 2013 at 4:41 PM, Yahya Muhammad wrote: > Dear Amar > > Please read Forum Rule No. 2 and post your query in a separate thread: > > 2) Don't post a question in the thread of another member. > > > On Tue, Jan 29

Re: $$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

Dear Amar Please read Forum Rule No. 2 and post your query in a separate thread: 2) Don't post a question in the thread of another member. On Tue, Jan 29, 2013 at 1:43 PM, amar takale wrote: > Hi Anil, > I want Ascending & Decending data then how to VBA Code used.only I > click button which

Re: $$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

Hi Anil, I want Ascending & Decending data then how to VBA Code used.only I click button which column on Ascending & Decending then that column sort with other data.I send Example file pls see it Appreciate the help. Regards Amar On Tue, Jan 29, 2013 at 2:46 PM, Yahya Muhammad wrote: > Dear Anil

Re: $$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

​Dear Anil Thanks again. However, here also the sorting occurs in the sheet, which I do not want. On Tue, Jan 29, 2013 at 9:25 AM, अनिल नारायण गवली wrote: > Dear Yahya, > > See the attached sheet . is it ok?? > > Wrm Regards, > Gawli Anil > > On Tue, Jan 29, 2013 at 11:47 AM, Yahya Muhammad wr

Re: $$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

Dear Anil Thanks. However, I can't adapt this method , as my combo box is in ​a userform and I cannot sort the column in the worksheet. On Tue, Jan 29, 2013 at 9:12 AM, अनिल नारायण गवली wrote: > Dear Yahya, > > Pl see the attached sheet is it ok? > > > Warm Regards, > Gawli Anil > > On Tue, Jan

$$Excel-Macros$$ Excel vba code to sort the userform combobox list ascending

Dears I have an excel userform with a combobox which select the items from a column in a worksheet. This column can't be sorted. I would like to have the list in the combobox to get sorted ascending, while initializing the userform. I am now using below code to load the combobox with values. Can

Re: $$Excel-Macros$$ Excel VBA Query

Add a new blank column before A in both the workbooks and use below formula in cell a2 and fill it down IF(B2<>"",B2&C2,LEFT(A1,FIND(C1,A1))&C2) then use simple vlookup to get the status Regards Ashish On Sat, Oct 20, 2012 at 6:14 PM, Manish Bankoti wrote: > Hi, > > Please find attached

$$Excel-Macros$$ Excel VBA Code for Zip Password

Hi Experts Kindly provide me a code for Zip file with password Protection. Q. How to Zip the folders with password in excel vba. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point |

Re: $$Excel-Macros$$ Excel vba

*- > > > ------ > *From:* Shiva Prasad > *To:* excel-macros@googlegroups.com > *Sent:* Wed, September 12, 2012 9:05:01 AM > *Subject:* $$Excel-Macros$$ Excel vba > > hi team, > > my job profile is mi

Re: $$Excel-Macros$$ Excel vba

can.” - John Wesley - From: Shiva Prasad To: excel-macros@googlegroups.com Sent: Wed, September 12, 2012 9:05:01 AM Subject: $$Excel-Macros$$ Excel vba hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops

RE: $$Excel-Macros$$ Excel vba

[mailto:excel-macros@googlegroups.com] On Behalf Of Shiva Prasad Sent: 12 September 2012 6:34 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel vba hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn

$$Excel-Macros$$ Excel vba

hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn excel vba , could any one give help me -- Regards, Shivaprasad K. -- Join official facebook page of this forum @ https://www.facebook.com/discussex

Re: $$Excel-Macros$$ Excel VBA Challenge

A suggested way to do it in http://www.excelfox.com/forum/f13/delete-worksheets-without-loop-515/ Here's a slightly modified version of the same Sub kTest() Dim var As Variant With Application var = .Transpose(.Evaluate("Row(2:" & Sheets.Count & ")")) .DisplayAlerts = 0

$$Excel-Macros$$ Excel VBA Challenge

Hi Guys, Challenge is to Delete all Sheets Except one without any loop and mapping table. Keep Excelling Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED

Re: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

Sub > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Rajan_Verma > *Sent:* Sunday, August 05, 2012 12:48 AM > *To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ Excel VBA Question: Splitting a Str

Re: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

cel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells Hi Use this : Sub SplitString() Dim StrString As String Dim VarArr StrString = "| ABC:2013| ABCD| EFGH|2IJK | 324

Re: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

Array(9, 1)), TrailingMinusNumbers:=True End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Alpesh Shah Sent: Saturday, August 04, 2012 7:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Para

RE: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

esize(1, UBound(VarArr)).Value = VarArr End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Alpesh Shah Sent: 05 August 2012 6:13 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ E

$$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

Dear Excel Experts, I am working with a string as follows: " | ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|" There are a total of 8 pipes | . My issue is that I am trying to Split this based on the pipes, and output the words in between into cells. I have been trying to solve this for a lon

RE: $$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Needed)

End Function Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pesh Sent: 29 July 2012 2:08 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Nee

$$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Needed)

Dear Excel Experts, I could really use your help. I am trying to take a string and with VBA code tally the number of instances of a word and then output into an excel sheet. For example, String >> "People: Tom Hanks(Actor), Michael Jordan(Businessman, Athlete), Fred Astaire (Dancer), Donald

Re: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

Aid Software dguille...@gmail.com From: Tony O Sent: Wednesday, July 25, 2012 6:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines I am working on a spreadsheet with Excel 2007. I have the vba code to delete a line: Selection.

Re: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ________________ From: Tony O To: excel-macros@googlegroups.com Sent: Wed, July 25, 2012 7:46:33 PM Subject: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

Re: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

Dear Tony, U can use without macro Just select the range and press ctl+G of press F5 function key . Then click to blank cell and use Alt+E+D select the row and delete it Regards, Gawli anil On Thu, Jul 26, 2012 at 8:42 AM, NOORAIN ANSARI wrote: > Dear Tony, > > Please try it.. > > *Sub Dele

Re: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

Dear Tony, Please try it.. *Sub DeleteBlank()* *On Error Resume Next ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).EntireRow.Delete On Error GoTo 0: On Error GoTo -1: Err.Clear* *End Sub* On Thu, Jul 26, 2012 at 5:13 AM, Tony O wrote: > I am working on a spreadsheet with Ex

$$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

I am working on a spreadsheet with Excel 2007. I have the vba code to delete a line: Selection.Delete Shift:=xlUp I want to delete all rows that have the cells in column A that are blank and column B and column C for just those rows. I'm thinking that the code should look something like this,

Re: $$Excel-Macros$$ Excel VBA Training By Subject matter Experts

Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. Rule # 05 On 7/2/12, harshita desu wrote: > Medha Information research Offering In House, Online and Corporate > training on Excel VBA > > Course Highlights > > Fully handson Sessions. > > Realtime exa

$$Excel-Macros$$ Excel VBA Training By Subject matter Experts

Medha Information research Offering In House, Online and Corporate training on Excel VBA Course Highlights Fully handson Sessions. Realtime examples Interview/project support Indepth and exclusive coverage on each topic For More details, Contact us at +91 9945207350 or write us at i...@medha

Re: $$Excel-Macros$$ Excel VBA Book?

PERFECT!! Thank you very much! I knew there was something out there I haven't found yet. On Tuesday, June 5, 2012 10:57:07 AM UTC-4, Sandeep Kumar Baranwal wrote: > > Refer > functionx.com/vbaexcel > > this will help > > Sandeep > > > On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot wrote: > >> I don

Re: $$Excel-Macros$$ Excel VBA Book?

Refer functionx.com/vbaexcel this will help Sandeep On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot wrote: > I don't know VBA other than manipulating recorded macros. What is the > quickest way to learn from foundation up? Book? Some pay site? It takes to > long to go through youtubes. > > I woul

$$Excel-Macros$$ Excel VBA Book?

I don't know VBA other than manipulating recorded macros. What is the quickest way to learn from foundation up? Book? Some pay site? It takes to long to go through youtubes. I would like a info dense book that does not assume prior prior VBA knowledge but also assumes I know what a keyboard is

Re: $$Excel-Macros$$ Excel VBA Password protection

> >> CC… >> >> ** ** >> -- >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *PrIyAnKa >> *Sent:* Tuesday, March 06, 2012 10:30 AM >> *To:* excel-macros@goog

Re: $$Excel-Macros$$ Excel VBA Password protection

t u need? > > ** ** > > ** ** > > Regards, > > Muneer, > > CC… > > ** ** > -- > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *PrIyAnKa > *Sent:* Tuesday, March

$$Excel-Macros$$ Excel VBA Password protection

Dear Team Kindly let me know how to protect macro in Excel 2007 I want to lock the VBA so no one can step into it w/o the password -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formul

Re: $$Excel-Macros$$ Excel VBA interview questions

Awesome! Thanks :) On Wed, Jan 11, 2012 at 11:15 PM, NOORAIN ANSARI wrote: > FYI > > > On Wed, Jan 11, 2012 at 11:04 PM, NOORAIN ANSARI > wrote: > >> Dear Experts, >> >> Please use below link for excel-vba interview questions.. >> >> http://www.coolinterview.com/type.asp?iType=220 >> >> Kindly s

$$Excel-Macros$$ Excel VBA interview questions

Dear Experts, Please use below link for excel-vba interview questions.. http://www.coolinterview.com/type.asp?iType=220 Kindly share with group if any one have other links or Excel-VBA Interview questions.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ Excel & VBA Jobs (US only)

Hi, Please check and bookmark this link for MS Excel, Access & VBA Jobs. http://jobs.openexcel.com *Best Regards* *Photographer**, Odd Lens Blogger, eXceLiTems.com Traveler, MastWeekend.com Developer, OpenExceL.com (Excel Add-in

Re: $$Excel-Macros$$ Excel VBA professional needed for a Project Work

Hi Satish Here is Divaker, you can contact to me on 9582060233. Divaker pandey On Mon, Oct 31, 2011 at 1:55 PM, satish wrote: > Dear Excel Gurus, > > I am free lance data analyst, I have set of excel templates to > calculate the Savings and Overcharges. I would like to auto-maize the > whole pr

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

; > > > > > > > > > On Thu, Nov 10, 2011 at 10:13 PM, dguillett1 wrote: > > you forgot RANGE but to make sure try > > > If len(application.trim(range("**A1")))<1 Then > > > Don Guillett > > SalesAid Software > > dguille...@gmai

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

; Sent: Thursday, November 10, 2011 9:48 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem > > > Hi, > > I am testing this fairly simple code for some other purposes but I > always get the value 8 regardless of value in A1: >

RE: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

Hi Seba, You are missing a small thing.. I have made the required correction in your code. Sub testPogoja() If IsEmpty(Range("A1")) Then Exit Sub Else Range("B5").Value = 8 End If End Sub Best Regards,Kaushal Kumar > Date: Thu, 10 Nov 2011 07:48:10 -0800 > Subject:

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

you forgot RANGE but to make sure try If len(application.trim(range("A1")))<1 Then Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Seba Sent: Thursday, November 10, 2011 9:48 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ excel v

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

try this... If range("A1").value = " " Then Exit Sub Else Range("B5").Value = 8 End If End Sub regards, Mrinal On Thu, Nov 10, 2011 at 9:18 PM, Seba wrote: > Hi, > > I am testing this fairly simple code for some other purposes but I > always get the value 8 regardless of value in A1: > > -

$$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

Hi, I am testing this fairly simple code for some other purposes but I always get the value 8 regardless of value in A1: Sub testPogoja() If IsEmpty("A1") Then Exit Sub Else Range("B5").Value = 8 End If End Sub -

$$Excel-Macros$$ Excel VBA professional needed for a Project Work

Dear Excel Gurus, I am free lance data analyst, I have set of excel templates to calculate the Savings and Overcharges. I would like to auto-maize the whole process using VBA and Macro. I would like to know the professional who can create the package ( Excel along with VBA and Macro. Please leave

$$Excel-Macros$$ Excel/VBA programmer-Midtown Manhattan (Hottest Position)

** * * * Hi Friends, Hope you are doing well today. Please find the job description below and send me the updated resume at ASAP. Here is an Immediate interview for the position. (Please send resumes to vi...@addonusa.com) Name: Contact: E-Mail: Location: Re-Location: Visa: Ava

$$Excel-Macros$$ Excel VBA/ Access

Hi, I have posted this on the access group too, it can't really be classified as one or the other, but it's driving me mad, can anyone help. I have an Access 2010 database, which I have saved as .mdb. (ie not accdb) It has an update query in, which takes 2 string parameters. When I run it from

  1   2   >