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

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

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

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 <da...@grugeon.com.au > > To: "excel-...@googlegroups.com " <excel-...@googlegroups.com > > > Date: Friday, May 10, 2013 12:08:12 PM GMT+1000 > Subject: Re:

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 =

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

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

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 )

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

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

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

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

nt: Friday, September 25, 2015 7:45 AM Subject: $$Excel-Macros$$ excel vba userform using & data store in access database Hi Everyone, I have created auserform where i want the data to be stored in access automatically, However i havewritten some code, where in start only i m getting

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

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 gauravdev1...@gmail.com wrote: Hi, I tried working on

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 nilkanth.ra...@gmail.com 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,

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 yahya...@gmail.com 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

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

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 lee.sar...@gmail.com 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

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

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

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

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

-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. On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta anky...@gmail.com

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

as ever you can.” - John Wesley - From: Anil Gawli gawlianil8...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com; anky...@gmail.com Sent: Friday, June 20, 2014 1:11 AM Subject: Re: $$Excel-Macros$$ Excel VBA Password Issues

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. On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta anky

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

- From: Ankur Gupta anky...@gmail.com To: excel-macros excel-macros@googlegroups.com 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

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

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 anky...@gmail.com 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

$$Excel-Macros$$ Excel VBA

Hi All, Must visit below mentioned ... Happy New Year 2014 http://mrexcel4u.blogspot.in/ 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

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

Friends,...any update? On Sat, Sep 7, 2013 at 11:21 AM, Abhishek Jain abhishek@gmail.comwrote: 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

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

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

Thanks david ! --Original message-- From: David Grugeon da...@grugeon.com.au To: excel-macros@googlegroups.com 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

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

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

see if it helps http://www.motobit.com/tips/detpg_uploadvbaie/ On Thu, May 9, 2013 at 12:30 PM, David Grugeon da...@grugeon.com.au 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

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

-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

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

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 mathan4s...@gmail.com 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

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

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

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

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

- From: Prince prince141...@gmail.com 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 correct

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

-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

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

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 want it for $10 instead of $17 you have to subscribe for the free newsletter Access Watch. http

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

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 schreiner_p...@att.netwrote: I may regret asking this, but here goes: Using Office 2010: I have Excel templates that are used to create documents

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 row

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

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 yahya...@gmail.com

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 amartak...@gmail.com wrote: Hi Anil, I want Ascending Decending data then how to VBA Code used.only I

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 amartak...@gmail.com 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

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 yahya...@gmail.com wrote: Dear Ashish This is what I want. But could not make it work in my file, which is attached. Please

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

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, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Yahya, Pl see the attached sheet is it ok? Warm Regards, Gawli

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,B2C2,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 genious.fore...@gmail.comwrote: Hi,

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

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

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

Re: $$Excel-Macros$$ Excel vba

@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 in excel VBA I want to learn excel vba , could any one give help me

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

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

Software dguille...@gmail.com *From:* Rajan_Verma rajanverma1...@gmail.com *Sent:* Sunday, August 05, 2012 12:48 AM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells *Hi

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

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 Parameter and outputting it into cells Dear Excel Experts, I am

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

@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 | 3243| 9s9s| afjkdf| StrString

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

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

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$$ Excel VBA Question: Splitting a String

$$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: String manipulation and tally (Help Needed)

@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 Needed) Dear Excel Experts, I could really use your help. I am trying to take a string

$$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 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 tonyrulesy...@yahoo.com wrote: I am working

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 noorain.ans...@gmail.comwrote: Dear Tony, Please

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

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 harshita4d...@gmail.com wrote: Medha Information research Offering In House, Online and Corporate training on Excel VBA Course Highlights Fully handson

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

Refer functionx.com/vbaexcel this will help Sandeep On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot c...@jwsre.com 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

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't know VBA

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

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

, Muneer, 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@googlegroups.com *Subject:* $$Excel-Macros$$ Excel VBA Password

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

*To:* excel-macros@googlegroups.com *Subject:* $$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

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

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

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

Awesome! Thanks :) On Wed, Jan 11, 2012 at 11:15 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: FYI On Wed, Jan 11, 2012 at 11:04 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Experts, Please use below link for excel-vba interview questions..

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

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

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

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 vba If IsEmpty(Range) code problem

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

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 sebastjan.hri...@gmail.com wrote: Hi, I am testing this fairly simple code for some other purposes but I always get the value 8 regardless of value

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 vba If IsEmpty(Range

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: $$Excel-Macros$$ excel vba

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

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

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

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

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

$$Excel-Macros$$ $$Excel VBA$$ Sorting worksheet with grouped rows and/or validation lists

I am working on a code that has a series of metrics listed in rows. Each metric is uniquely specified by several headings listed in the header row. The (relevant) categories in the header are as follows: |ID|Category|Sub-Category|Metric|Sub-Metric|Unit|Priority|etc... (irrelevant)| The entire

RE: $$Excel-Macros$$ Excel VBA for BOM

What help do you need in this macro?? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rash Sent: Monday, July 04, 2011 10:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel VBA for BOM Hi, With some more detailed explanation

Re: $$Excel-Macros$$ Excel VBA for BOM

Hi, FYI, Sorry, the previously attached file already contains the macro, but its not full proof. It is not highlighting rows 137 to 142. because its not in sorted order. Rash -- -- Some important links for excel

Re: $$Excel-Macros$$ Excel VBA for BOM

hi can you explain it in detail On Fri, Jul 1, 2011 at 11:44 AM, Rash rashmiv.ni...@gmail.com wrote: Hi I am using the attached bill of material. I need to search the whole sheet to find unique product numbers. Explained in more detail in the attached .docx file. Attached .xls is my excel

$$Excel-Macros$$ Excel VBA Macro for sending email through Lotus Notes

Hi Give below is the code I used to send email and attache attachement to the same email. Only success I had till now is in sending email and attaching same sheet as attachement. I am not able to attache a pdf and send it through email. Can some one please advsie me how can I attache a pdf file

$$Excel-Macros$$ EXCEL VBA

Dear All, I am Completely new to VBA.I don't know its terminology and how to write programs to execute specific action in Excel.I want to learn Excel VBA in an easy way.Any E book would be of immense help to me and other people would like to learn VBA.Please upload any VBA material .

  1   2   >