$$Excel-Macros$$ Re: [XL-VBA Clinic] PDF to Excel

[NOORAIN ANSARI]

Dear Shahzad,


Please try it..



Sub ImportPDFFileData()
'Author: Steve Lipsman
'Purpose: Import PDF File Data Into Excel Worksheet
'Other Requirement(s): 'Acrobat' Checked in VBA Tools-References
'Reference Renames Itself 'Adobe Acrobat 9.0 Object Library' After
Reference Is Saved

'Declare Variable(s)
Dim appAA As Acrobat.CAcroApp, docPDF As Acrobat.CAcroPDDoc
Dim strFileName As String, intNOP As Integer, arrI As Variant
Dim intC As Integer, intR As Integer, intBeg As Integer, intEnd As Integer

'Initialize Variables
Set appAA = CreateObject("AcroExch.App"): Set docPDF =
CreateObject("AcroExch.PDDoc")

'Set PDF FileName
strFileName = "Your Full PDF File Pathname Here.pdf"

'Read PDF File
docPDF.Open (strFileName)

'Extract Number of Pages From PDF File
intNOP = docPDF.GetNumPages

'Select First Data Cell
Range("A1").Select

'Open PDF File
ActiveWorkbook.FollowHyperlink strFileName, , True

'Loop Through All PDF File Pages
For intC = 1 To intNOP
'Go To Page Number
SendKeys ("+^n" & intC & "{ENTER}")

'Select All Data In The PDF File's Active Page
SendKeys ("^a"), True

'Right-Click Mouse
SendKeys ("+{F10}"), True

'Copy Data As Table
SendKeys ("c"), True

'Minimize Adobe Window
SendKeys ("%n"), True

'Paste Data In This Workbook's Worksheet
ActiveSheet.Paste

'Select Next Paste Cell
Range("A" & Range("A1").SpecialCells(xlLastCell).Row + 2).Select

'Maximize Adobe Window
SendKeys ("%x")
Next intC

'Close Adobe File and Window
SendKeys ("^w"), True

'Empty Object Variables
Set appAA = Nothing: Set docPDF = Nothing

'Select First Cell
Range("A1").Select
End Sub

also weblink.

http://www.pdftoexcelonline.com/
http://www.onlineocr.net/
http://www.cometdocs.com/
http://www.coolutils.com/Online-Excel-Converter.php
http://document.online-convert.com/convert-to-pdf
 http://www.pdfconverter.com/
 http://www.freepdfconvert.com/

http://www.simpleocr.com/OCR_Software/Convert_Image/convert_image_to_Excel.asp




On Fri, Mar 8, 2013 at 1:02 PM, Aamir Shahzad wrote:

> Dear group,
>
> Is there any way to convert the PDF file to excel by MACRO.
>
> Regards,
> Aamir Shahzad
>
> --
>
> --
> To post to this group, send email:
> excelvbacli...@googlegroups.com
> To unsubscribe from this group, send email
> excelvbaclinic+unsubscr...@googlegroups.com
>
> For more options, visit this group at
> http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
> ---
> You received this message because you are subscribed to the Google Groups
> "Excelvbaclinic" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excelvbaclinic+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ PDF to Excel

[Aamir Shahzad]

Dear group,

Is there any way to convert the PDF file to excel by MACRO.

Regards,
Aamir Shahzad

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Macro to sort cells based on highlights

[Amit Gandhi]

Thanks Ashish. Good work.

But this UDF doesn't satisfy Criteria 3 i.e.
Criteria 3 --> Sorting order will be from B --> J.

(a) if you see in your solution file Row 6 & 7 (Name G & A) has count 4,
but Row 7 (Name A) should come first then row 6 (Name G), as Row 7 has
first highlight in Column C and Row 6 has first highlight in Column D.

(b) if you see in your solution file Row 8 & 9 (Name I & C) has count 3,
but Row 9 (Name C) should come first then row 8 (Name I), as Row 9 has 3rd
highlight in Column G and Row 8 has 3rd highlight in Column H.


Can you solve this as well?

Pls help.

Regards

Amit




On Thu, Mar 7, 2013 at 11:26 PM, ashish koul  wrote:

> hi try this attached file
>
> I have created a simple UDF to count cells in a range which are having
> fill color red and once you have count. You can simply sort it
>
> Regards
> Ashish
>
>
> On Thu, Mar 7, 2013 at 3:55 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> I have an excel data and I want to sort data based on below criteria
>> using Macro. pls help me here.
>>
>> *Column B to J has data which is to be sorted as per Highlighted CELLS *
>> Criteria 1 -->  Highlighted cells should come first.
>> Criteria 2 --> Row which has more highlighted cells from B to J, should
>> come first.
>> Criteria 3 --> Sorting order will be from B --> J.
>>
>> I have attached excel file which shows sample data and result required
>> for better understanding.
>>
>>
>> Regards
>>
>> Amit
>>
>>  --
>> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog *
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a q

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

[Prince]

Hi Paul,

I think the solutions given by Sam and Me are correct for your question and 
fulfil your requirments. So please reply wat is wrong with our solution for 
not use.

Regards
Prince

On Thursday, March 7, 2013 6:09:14 PM UTC+5:30, Paul Schreiner wrote:
>
> Thanks David,
>  
> I subscribed to the newsletter and purchased the book.
>  
> Now to see what new realms I can visit!
>  
>
> *Paul*
>
> -
> *“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 can.” - John Wesley
> *-
>
>
>  --
> *From:* David Grugeon >
> *To:* "excel-...@googlegroups.com " <
> 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 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 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 Sharepoint site.
>>  
>> I use Excel to generate multiple reports from various data sources 
>> (mostly Oracle databases).
>>  
>> I'd like to use Excel VBA to retrieve a list of "released" documents from 
>> a specific table in Sharepoint.
>>  
>> I'll then retrieve the Oracle data for the Release documents.
>>  
>> Now, I've been told that I can link an Access table to the Sharepoint 
>> table, then use Excel VBA to query the Access table.
>>  
>> I have successfully created an Access Database that is linked to the 
>> Sharepoint site.
>>  
>> I've Googled my fingers off and read hundreds of lines in posts and have 
>> yet to find a WORKING example of using Excel VBA to query the AccessDB.
>>  
>> (no, I DON'T want to use Excel and create an external data source, I'd 
>> like to use VBA and issue an SQL query against the database)
>>  
>> It seems more efficient to connect to the Sharepoint table directly from 
>> Excel VBA instead of going through MSAccess.
>>  
>> So.. my question:
>> Does anyone have a working example of connecting to, and querying an 
>> Access Database using Excel VBA?
>>  
>> Or...
>> Does anyone have a working example of connecting to and querying a 
>> Sharepoint site/table using Excel VBA?
>>  
>> thank you,
>> Paul
>>  
>>
>> -- 
>> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>
> -- 
>  Regards
> David Grugeon 
>
>
> -- 
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don

$$Excel-Macros$$ Re: Scope of variables

[Prince]

Hi David,

You Did everything Correct except the way you are accessing the public 
variable. For Accessing the public variable from Another work book you need 
to add the reference of that work book into your current work book
then only you can use that variable in your current work book. For more 
explaination you can go through the following link this link will guid you 
how can you access the public variable.

http://support.microsoft.com/kb/141693

Regards
Prince


On Friday, March 8, 2013 5:07:19 AM UTC+5:30, David Grugeon wrote:
>
> Hi all
>
> I am using excel 14  (Part of Office Pro Plus 2010) on Win 7 Pro 32 bit. 
>  A fairly standard setup.
>
> The help file says
> Public
>
> Variables declared using the *Public* statement are visible to all 
> procedures in all modules in all applications unless *Option Private 
> Module* is in effect. In that case, the variables are public only within 
> the project in which they reside.
>
> I created 2 workbooks  They are clean.  i.e. I do not think there is 
> secret code in them as they are newly created.
>
>
> I created a module in each file.
>
> The modules are as foillows
>
> In Test1.xlsb
>
> -
>
> Option Explicit
>
> Public Y As Integer
>
> Sub setY()
>
> Y = 18
>
> End Sub
>
>
> Sub testY()
>
> Dim X
>
> X = Y
>
> Debug.Print X
>
> End Sub
>
> --
>
> in Test2.xlsb
>
> Option Explicit
>
>
> Sub testY()
>
> Dim X
>
> X = Y
>
> Debug.Print X
>
> End Sub
> ---
> If I run Sety() and TestY() in Test1 everything works as expected and it 
> prints 18 in the immediate window.
>
> However testY in test 2.xlsb will not compile.  It highlights the Y in X=Y 
> and says "Variable not defined"
>
> What have I misunderstood from the help file, or is it just wrong?
>
>
> Regards
> David Grugeon
>
>  

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Most helpful member award stopped.

[Prince]

Hi Ayush.

I think it is a good initiative  that will help us to recognize the person 
who put their quality of time in delivering the answer with the quality.

Regards
Prince

On Thursday, March 7, 2013 9:24:58 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members,
>
> Thanks for your active participation and taking this group to new heights.
>
> This is to inform you that we are stopping the 'Most helpful Member' award 
> for the below reasons :
> 1) The award is based on only quantity of the posts and not the quality of 
> the posts. It is not possible for us to check each message and keep a track 
> of quality delivered.
> 2) We should recognize the people who explains the reason behind the 
> problem and not just give the solution. 
> 3) I have observed that people post unnecessary question or solution or 
> answer and do anything just to increase the post count.
>
> Our target is to maintain the quality in the forum and not increase the 
> quantity of posts.
>
> Recognition is very important and hence I am starting a new thread* 'I 
> appreciate' *where you can recognize the people who have helped you and 
> you want to recognize the efforts. Its open for every member of the forum. 
> I hope you like the idea. I welcome your suggestions and please write to me 
> if you have any queries,
>
> Thanks again
>
> Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Sync/Update data from two sheets from one workbook to one sheet in another workbook

[Aaron Lasley]

I am in need of help in creating a fairly complex macro that will 
sync/update changes from two sheets in one workbook to one sheet in another 
workbook. However, only certain cell data is needed, not the entire column 
or row. 
The macro would run from the destination workbook and search by the unique 
ID in column A in the source workbook, both sheets (maybe one sheet at a 
time?) then if the same ID exists, (skips those that don't exist in the 
Destination sheet) compare cell data in the destination sheet and update 
the value if there are any changes. 
The twist on top of all this is that besides the Unique ID in Column A, the 
data is not in the same order between any of the sheets. The headers have 
the same names even if they are not in the same order (though the headers 
are located in row 1 or row 3). 
I am providing two example workbooks for both the Source workbook and the 
Destination workbook. 
Help would be greatly appreciated as this would be a huge time saver and 
would decrease some human error issues we have had in the past.

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




DestinationBK.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


SourceBK.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Scope of variables

[David Grugeon]

Hi all

I am using excel 14  (Part of Office Pro Plus 2010) on Win 7 Pro 32 bit.  A
fairly standard setup.

The help file says
Public

Variables declared using the *Public* statement are visible to all
procedures in all modules in all applications unless *Option Private
Module*is in effect. In that case, the variables are public only
within the
project in which they reside.

I created 2 workbooks  They are clean.  i.e. I do not think there is secret
code in them as they are newly created.


I created a module in each file.

The modules are as foillows

In Test1.xlsb

-

Option Explicit

Public Y As Integer

Sub setY()

Y = 18

End Sub


Sub testY()

Dim X

X = Y

Debug.Print X

End Sub

--

in Test2.xlsb

Option Explicit


Sub testY()

Dim X

X = Y

Debug.Print X

End Sub
---
If I run Sety() and TestY() in Test1 everything works as expected and it
prints 18 in the immediate window.

However testY in test 2.xlsb will not compile.  It highlights the Y in X=Y
and says "Variable not defined"

What have I misunderstood from the help file, or is it just wrong?


Regards
David Grugeon

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Using PROCV on a Budget for distribution of a installment

[Bruno Pitombeira]

Hi everyone! 

To begin with the post I would like to start sayin that I'm sry for any 
english mistakes. Going ahead: I've a budget sheet that I would like to 
insert an expense made on a credit card and, inform that that expense is 
divided in, for example, 3 months, and that the sheet do the arrangement. 

Thanks in advance for the help,

Bruno Pitombeira

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ hi there

[nm]

sir,

pl accept my apology i m begineer in the group, and not familier with excel
progarmming too.

i need customer recoed database.

Thanks

NIK.


On Thu, Mar 7, 2013 at 11:10 PM, xlstime  wrote:

> Hi Nik
>
> first of all please use proper subject line and which type database format
> you want i..e... Finance or customer record database type
>
> please specify
>
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Thu, Mar 7, 2013 at 10:26 PM, nm  wrote:
>
>> Sir,
>>
>> i m into real estate business and want to create a data base.
>>
>> 1) want to have a data base for my business with all the detail and where
>> i can also add some field as per my requirement.
>>
>> 2) further i want to use the said data base for my website too, i m
>> planing to have my website ( if any one can recommend or help for the
>> website shall also be appreciated)
>>
>> 3) anyone having the ready format of the data base.
>>
>>
>> thanks
>>
>> Nik.
>>
>>
>> --
>> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ calculating between two cells in two different sheets.

[Jaz]

Hello all,
I am wondering if I can be helped in this.  I have two sheets 'Main' & 
'Consumed'  B col. of both sheets have Lot ID.
A macro should be written to see in Lot qty Cell D2 of sheet consumed, 
check its lot ID in B2.  Then go to Main sheet and trace the qty of that 
lot in that sheet and subtract the amount.  
I am attaching the sheet.
Thanks for your help.
Jaz

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




sample.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Introduce Yourself !!

[Bruno Pitombeira]

Hi! everyone, 
My name is Bruno Pitombeira, I live in Fortaleza - Brazil and I'm 30 yrs 
old. I work as a financial supervisor and it's great to be among other 
Excel lovers!

Em sexta-feira, 8 de junho de 2012 16h21min59s UTC-3, Ayush Jain escreveu:
>
> Hey all new and current posters,
>  
> Welcome to excel group,one of the largest online community of excel Fans!
>  
> I hope you enjoy your time here & find this forum to be a friendly and 
> knowledgeable community. Please feel free to post a small introduction, a 
> friendly hello or tell us a bit about yourself. Why not tell us where are 
> you from, what you do, what your interests are, how old you are, which is 
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Macro to sort cells based on highlights

[ashish koul]

hi try this attached file

I have created a simple UDF to count cells in a range which are having fill
color red and once you have count. You can simply sort it

Regards
Ashish

On Thu, Mar 7, 2013 at 3:55 PM, Amit Gandhi  wrote:

> Hi Experts
>
> I have an excel data and I want to sort data based on below criteria using
> Macro. pls help me here.
>
> *Column B to J has data which is to be sorted as per Highlighted CELLS *
> Criteria 1 -->  Highlighted cells should come first.
> Criteria 2 --> Row which has more highlighted cells from B to J, should
> come first.
> Criteria 3 --> Sorting order will be from B --> J.
>
> I have attached excel file which shows sample data and result required for
> better understanding.
>
>
> Regards
>
> Amit
>
>  --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




SORTING BY MACRO (1).xlsm
Description: Binary data

Re: $$Excel-Macros$$ hi there

[xlstime]

Hi Nik

first of all please use proper subject line and which type database format
you want i..e... Finance or customer record database type

please specify


.

Enjoy
Team XLS



On Thu, Mar 7, 2013 at 10:26 PM, nm  wrote:

> Sir,
>
> i m into real estate business and want to create a data base.
>
> 1) want to have a data base for my business with all the detail and where
> i can also add some field as per my requirement.
>
> 2) further i want to use the said data base for my website too, i m
> planing to have my website ( if any one can recommend or help for the
> website shall also be appreciated)
>
> 3) anyone having the ready format of the data base.
>
>
> thanks
>
> Nik.
>
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ hi there

[nm]

Sir,

i m into real estate business and want to create a data base.

1) want to have a data base for my business with all the detail and where i
can also add some field as per my requirement.

2) further i want to use the said data base for my website too, i m planing
to have my website ( if any one can recommend or help for the website shall
also be appreciated)

3) anyone having the ready format of the data base.


thanks

Nik.

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ I appreciate your help :-)

[Ayush Jain]

Dear members, 

Let's keep this post to recognize the forum members who have helped you in 
solving problem or has shared any knowledge in the forum.
Let see who recognize first here.

Thanks.

Regards
Ayush Jain

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Most helpful member award stopped.

[Paul Schreiner]

That's probably for the best.
I know I appreciate the recognition (I even printed the certificate and have it 
on display!)
but then, it makes me somewhat... skeptical? when I see people that post 
answers that are NOT well thought out or tested. (like: a user asking how to 
delete the contents of cells that have "0", and the response gave a solution 
that cleared ALL cells, regardless of content!)

thank you... I appreciate YOUR efforts with this forum!


Paul
-
“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 can.” - John Wesley
-





From: Ayush Jain 
To: excel-macros@googlegroups.com
Sent: Thu, March 7, 2013 10:55:25 AM
Subject: $$Excel-Macros$$ Most helpful member award stopped.

Dear members,

Thanks for your active participation and taking this group to new heights.

This is to inform you that we are stopping the 'Most helpful Member' award for 
the below reasons :
1) The award is based on only quantity of the posts and not the quality of the 
posts. It is not possible for us to check each message and keep a track of 
quality delivered.
2) We should recognize the people who explains the reason behind the problem 
and 
not just give the solution. 

3) I have observed that people post unnecessary question or solution or answer 
and do anything just to increase the post count.

Our target is to maintain the quality in the forum and not increase the 
quantity 
of posts.

Recognition is very important and hence I am starting a new thread'I 
appreciate' 
where you can recognize the people who have helped you and you want to 
recognize 
the efforts. Its open for every member of the forum. I hope you like the idea. 
I 
welcome your suggestions and please write to me if you have any queries,

Thanks again

Keep posting.

Regards
Ayush Jain
Group Manager
-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members 
are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Most helpful member award stopped.

[Ayush Jain]

Dear members,

Thanks for your active participation and taking this group to new heights.

This is to inform you that we are stopping the 'Most helpful Member' award 
for the below reasons :
1) The award is based on only quantity of the posts and not the quality of 
the posts. It is not possible for us to check each message and keep a track 
of quality delivered.
2) We should recognize the people who explains the reason behind the 
problem and not just give the solution. 
3) I have observed that people post unnecessary question or solution or 
answer and do anything just to increase the post count.

Our target is to maintain the quality in the forum and not increase the 
quantity of posts.

Recognition is very important and hence I am starting a new thread* 'I 
appreciate' *where you can recognize the people who have helped you and you 
want to recognize the efforts. Its open for every member of the forum. I 
hope you like the idea. I welcome your suggestions and please write to me 
if you have any queries,

Thanks again

Keep posting.

Regards
Ayush Jain
Group Manager

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Telephone directory template

[ashish koul]

Visit this link to donload templates
http://office.microsoft.com/en-us/templates/address-and-phone-list-TC010196212.aspx




On Thu, Mar 7, 2013 at 10:43 AM, Kenil Gala  wrote:

> Hi group,
> DO ant one have a telephone directory template where i can save my
> personal and bussiness phone nos. with some other data like e.mail, DOB,
> Address etc
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0

[ashish koul]

Hi Amar,

change cells with range

Sub Macro1()
Range("a:a").Replace What:="0", Replacement:="", LookAt:=xlWhole,
SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End Sub




On Thu, Mar 7, 2013 at 7:04 PM, Somnath Khadilkar wrote:

> Still Prob
> 
>
> R/ Prince, I just 'recorded a macro just clicked in some cell G8 and
> stopped recording] and put your code in it., On exec. it says error,
> you may pl have a look
>
>
>
>
> Sub Macro1()
> '
> ' Macro1 Macro
> '
>
> Sheet1.range("$A1$AZ1048576").clearcontents.
>
>
>
> '
> Range("G8").Select
> End Sub
>
> Also is this method RIGHT ? [ The correct way pl. ]
> ALso sir, will it retain the other non-zero values. ?
>
> =mangal ho
> On 3/6/13, Prince  wrote:
> > By using VBA :
> >
> > Sheet1.range("$A1$AZ1048576").clearcontents.
> >
> > regards
> > prince
> >
> > On Tuesday, March 5, 2013 9:48:11 PM UTC+5:30, Somnath Khadilkar wrote:
> >>
> >> Dear Sir,
> >>I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
> >> would like to BLANK or DELETE the numeric 0 , [Other cells may contain
> >> any ALPHA-NUMERIC values. ] Pl Help.
> >>
> >> =mangal ho
> >>
> >
> > --
> > 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> > 2) Don't post a question in the thread of another member.
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> > 4) Acknowledge the responses you receive, good or bad.
> > 5) Jobs posting is not allowed.
> > 6) Sharing copyrighted material and their links is not allowed.
> >
> > NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> > members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND VBA MACROS" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to excel-macros+unsubscr...@googlegroups.com.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> > For more options, visit https://groups.google.com/groups/opt_out.
> >
> >
> >
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>


-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you 

Re: $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0

[Somnath Khadilkar]

Still Prob


R/ Prince, I just 'recorded a macro just clicked in some cell G8 and
stopped recording] and put your code in it., On exec. it says error,
you may pl have a look




Sub Macro1()
'
' Macro1 Macro
'

Sheet1.range("$A1$AZ1048576").clearcontents.



'
Range("G8").Select
End Sub

Also is this method RIGHT ? [ The correct way pl. ]
ALso sir, will it retain the other non-zero values. ?

=mangal ho
On 3/6/13, Prince  wrote:
> By using VBA :
>
> Sheet1.range("$A1$AZ1048576").clearcontents.
>
> regards
> prince
>
> On Tuesday, March 5, 2013 9:48:11 PM UTC+5:30, Somnath Khadilkar wrote:
>>
>> Dear Sir,
>>I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
>> would like to BLANK or DELETE the numeric 0 , [Other cells may contain
>> any ALPHA-NUMERIC values. ] Pl Help.
>>
>> =mangal ho
>>
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




12.xls
Description: MS-Excel spreadsheet

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

[Paul Schreiner]

Thanks David,

I subscribed to the newsletter and purchased the book.

Now to see what new realms I can visit!
 
Paul
-
“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 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 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 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 Sharepoint site.
>
>I use Excel to generate multiple reports from various data sources (mostly 
>Oracle databases).
>
>I'd like to use Excel VBA to retrieve a list of "released" documents from a 
>specific table in Sharepoint.
>
>I'll then retrieve the Oracle data for the Release documents.
>
>Now, I've been told that I can link an Access table to the Sharepoint table, 
>then use Excel VBA to query the Access table.
>
>I have successfully created an Access Database that is linked to the 
>Sharepoint 
>site.
>
>I've Googled my fingers off and read hundreds of lines in posts and have yet 
>to 
>find a WORKING example of using Excel VBA to query the AccessDB.
>
>(no, I DON'T want to use Excel and create an external data source, I'd like to 
>use VBA and issue an SQL query against the database)
>
>It seems more efficient to connect to the Sharepoint table directly from Excel 
>VBA instead of going through MSAccess.
>
>So.. my question:
>Does anyone have a working example of connecting to, and querying an Access 
>Database using Excel VBA?
>
>Or...
>Does anyone have a working example of connecting to and querying a Sharepoint 
>site/table using Excel VBA?
>
>thank you,
>Paul
>-- 
>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, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>members 
>are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email 
>to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>For more options, visit https://groups.google.com/groups/opt_out.
> 
> 
>

-- 

RegardsDavid Grugeon 

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members 
are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(E

Re: $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0

[amar takale]

Dear Ashish,
Code is Good one,but if anyone want delete Zero or Zero Value cell only
from specific column then how to modified code
Pls suggest code
Regards
amar

On Wed, Mar 6, 2013 at 8:51 PM, ashish koul  wrote:

> Hi Manjunath
>
> try this
> Sub Macro1()
> Cells.Replace What:="0", Replacement:="", LookAt:=xlWhole, SearchOrder
> _
> :=xlByRows, MatchCase:=False, SearchFormat:=False,
> ReplaceFormat:=False
> End Sub
>
>
>
> On Wed, Mar 6, 2013 at 8:47 PM, Manjunath Narayanappa <
> manjunath.narayana...@aon.co.uk> wrote:
>
>>  hi prince,
>>
>>
>>
>> As per VBA code entire data is getting deleted from sheet. Just want to
>> delete 0(Zero) from the sheet.
>>
>>
>>
>> Thanks
>>
>> Manjunath
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Prince
>> *Sent:* 06 March 2013 13:26
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0
>>
>>
>>
>> By using VBA :
>>
>>
>>
>> Sheet1.range("$A1$AZ1048576").clearcontents.
>>
>>
>>
>> regards
>>
>> prince
>>
>>
>> On Tuesday, March 5, 2013 9:48:11 PM UTC+5:30, Somnath Khadilkar wrote:
>>
>> Dear Sir,
>>I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
>> would like to BLANK or DELETE the numeric 0 , [Other cells may contain
>> any ALPHA-NUMERIC values. ] Pl Help.
>>
>> =mangal ho
>>
>> --
>> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>> --
>>
>> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>>
>>
>>
>> For Aon’s standard conditions associated with this e-mail please visit
>> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>>
>> Aon UK Limited
>>
>> Registered Office: 8 Devonshire Square, London EC2M 4PL
>>
>> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>>
>>
>>
>> Aon UK Limited is authorised and regulated by the Financial Services
>> Authority in respect of insurance mediation activities only.
>>
>> --
>> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog *
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It

Re: $$Excel-Macros$$ Re: Not able to change background color

[David Grugeon]

Yes.  macros in open office are totally different from those in MS
Office as are the object models.

On 07/03/2013, anubha gupta <13gupta.anu...@gmail.com> wrote:
> I am using open office not MS office could it be an issue
>
> On Thursday, March 7, 2013 11:17:46 AM UTC+5:30, anubha gupta wrote:
>>
>> Hi this is same which you have sent
>>
>> I have attached again
>>
>> On Thursday, March 7, 2013 9:51:25 AM UTC+5:30, अनिल नारायण गवली wrote:
>>>
>>> Dear Anu,
>>>
>>> Pl share that sheet in which u r getting nothing.
>>>
>>> Warm Regards,
>>> Gawli Anil
>>>
>>> On Wed, Mar 6, 2013 at 5:11 PM,  wrote:
>>>

 Thanks Anil for that much help
 But still when I run your defined macro 'Sheet3' it change nothing.
 I also try to call that function using '=Sheet3()' but not working

 Am I wrong in calling that function



 On Wednesday, March 6, 2013 4:23:02 PM UTC+5:30, अनिल नारायण गवली
 wrote:

> Dear Anu,
>
> Sorry for wrong file. here is the file.
>
>
> Warm Regards,
> Gawli Anil.
>
> On Wed, Mar 6, 2013 at 4:18 PM, अनिल नारायण गवली
> wrote:
>
>> Dear Anu,
>>
>> Pl see the sample sheet.
>>
>> Warm Regards,
>> Gawli Anil
>>
>> On Wed, Mar 6, 2013 at 4:12 PM,  wrote:
>>
>>> Hi Anil
>>>
>>> Thanks for ur help
>>> But I do not have much knowledge about macros as I have just started
>>>
>>> working on it. can you explain little bit more as an I need
>>> to do
>>> something with code or else for
>>> Selection change event
>>>
>>>
>>> On Wednesday, March 6, 2013 12:34:38 PM UTC+5:30,
>>> anu.r...@gmail.comwrote:

 Hi all

 I need to change the color of a cell through Macro
 using following code

 ===

 Sub Main

 End Sub

 Function Change_Color()

 ActiveCell.Interior.ColorIndex = 36
 End Function

 ====

 That throws run time error 'Object is not set'

 Can any one suggest where I am wrong.

 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 Facebook page of this forum
>>> @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
>>> Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>>
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros...@**googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/**
>>> group/excel-macros?hl=en
>>> .
>>> For more options, visit
>>> https://groups.google.com/**groups/opt_out
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>> Thanks & Regards,
>> Gawli Anil Narayan
>> Software Developer,
>> Abacus Software Services Pvt Ltd
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>

>>>
>>>
>>> --
>>> Thanks & Regards,
>>> Gawli Anil Narayan
>>> Software Developer,
>>> Abacus Software Services Pvt Ltd
>>
>>
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.

$$Excel-Macros$$ Macro to sort cells based on highlights

[Amit Gandhi]

Hi Experts

I have an excel data and I want to sort data based on below criteria using
Macro. pls help me here.

*Column B to J has data which is to be sorted as per Highlighted CELLS *
Criteria 1 -->  Highlighted cells should come first.
Criteria 2 --> Row which has more highlighted cells from B to J, should
come first.
Criteria 3 --> Sorting order will be from B --> J.

I have attached excel file which shows sample data and result required for
better understanding.


Regards

Amit

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




SORTING BY MACRO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ hyperlink issue

[dinaeshkool]

Sent from my iPhone upknjkhm


Hmm mn 
Lllppojv mllokollw   Clopping pp
VXvx@,z



B joke kknnkkl

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.