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

[Ahmed Honest]

Hi Send details

On Friday, July 28, 2017, Rajan Verma  wrote:

>
> [image: Inline image 1]
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>


-- 
*Ahmed Bawazir*
*احمد باوزير*

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel VBA Training

[Rajan Verma]

[image: Inline image 1]

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[Paul Schreiner]

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 my problem:

I'm an "owner" of a corporate SharePoint site.
(which means I have limited Admin privileges).

I have (4) user workbooks (not in SharePoint) that have a total of 242 
worksheets that monitor Capital Project expenditures.
I've written macros to copy the worksheets to separate workbooks, save the 
files to the SharePoint folder,
add some Named Ranges and use ContentTypeProperties to update fields in the 
SharePoint metadata (and views).

My Summary reporting macros have been rewritten to read from the SharePoint 
metadata fields instead of the worksheets themselves.

Once the final migration is complete, the worksheets will be maintained 
within SharePoint and  the current (4) workbooks will be locked away and 
used no more.

I've executed the migration macros multiple times over the last couple of 
months in order to prepare for final migration to the SharePoint site.

The ONLY thing I'm stuck on is trying to Check-In the documents from VBA.

Now, I CAN check in the document from SharePoint, but it extends the 
migration time to hours instead of minutes.

Whenever I attempt the .CheckIN method (or .CanCheckIn), the method fails 
or indicates that the files cannot be checked in.

Using VBA, I can delete the file from the SharePoint folder and copy (or 
.SaveAs) the current file to the folder.

The result is that the file is "Checked Out" to me.

(so it SEEMS to recognize my authorization to modify the contents of the 
folder)

Sure, I can stay after the end of my shift for 3 hours on ONE DAY to 
migrate the data (or come in 3 hours early).
but I'd prefer to be able to run a macro that does it all...

does anyone have any experience with the VBA .CheckIN method for SharePoint?

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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[Gaurav M]

Hi All,

In my project I am having a requirement to upload file from IE browser 
browse button. We are invoking this browser through macro in excel VB.

HTML code for webpage is :-


please share VB code to select any file from my system.

Gaurav


On Sunday, May 12, 2013 at 2:33:26 PM UTC-7, Mathan wrote:
>
> Thanks david ! 
>
> --Original message-- 
> From: David Grugeon > 
> To: "excel-...@googlegroups.com "  > 
> Date: Friday, May 10, 2013 12:08:12 PM GMT+1000 
> Subject: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to 
> 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 
> David Grugeon 
>
>
>
> On 10 May 2013 06:42, Mathan > wrote: 
>
> > Sorry, please refer to this screenshot. Thanks 
> > 
> > 
> > On Fri, May 10, 2013 at 2:11 AM, Mathan  > wrote: 
> > 
> >> Hi David, 
> >> 
> >> Please refer to the attached screenshot. I believe you would get my 
> point 
> >> after seeing that. I might have confused you earlier. 
> >> 
> >> Thanks 
> >> Mathan 
> >> 
> >> 
> >> On Thu, May 9, 2013 at 12:30 PM, David Grugeon  >wrote: 
> >> 
> >>> In essence, internet explorer does not understand excel files.  You 
> >>> could save the file as a web page and load that.  It would not have 
> the 
> >>> functionality of excel though. 
> >>> 
> >>> There are some proprietary products which allow you to run excel 
> >>> spreadsheets through a browser.  They cost though!  Min $500, I think. 
> >>> 
> >>> Or you could upload the file to Google Apps or Office 365 and then 
> open 
> >>> that in a browser. 
> >>> 
> >>> Regards 
> >>> David Grugeon 
> >>> 
> >>> 
> >>> 
> >>> On 9 May 2013 16:31, Mathan > wrote: 
> >>> 
> >>>> Hi David/Anil, 
> >>>> 
> >>>> We are trying to upload the excel file through excel vba. 
> >>>> 
> >>>> The files are from common shared folder not on the local drive. 
> >>>> 
> >>>> I hope this helps, However, I will share the screenshot by tonight. 
> >>>> Thanks for your time. 
> >>>> 
> >>>> Thanks 
> >>>> 
> >>>> 
> >>>> On Thu, May 9, 2013 at 10:11 AM, David Grugeon  >wrote: 
> >>>> 
> >>>>> 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 located. 
> >>>>> 
> >>>>> We also need to know why VBA code is required, rather than simply a 
> >>>>> hyperlink. 
> >>>>> 
> >>>>> Regards 
> >>>>> David Grugeon 
> >>>>> 
> >>>>> 
> >>>>> 
> >>>>> On 9 May 2013 06:56, Mathan > 
> wrote: 
> >>>>> 
> >>>>>> Hi Experts, 
> >>>>>> 
> >>>>>> I'm trying to upload a file from shared folder (directory) to the 
> >>>>>> internet explorer. 
> >>>>>> 
> >>>>>> Need a VBA code to do this. Could anyone help me on this? 
> >>>>>> 
> >>>>>> Thanks 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 

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

[Victor Momoh]

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 = Worksheets("Sheet2")
Lrow = wks.Range("A" & Rows.Count).End(xlUp).Row
k = 1
For I = 1 To Lrow
Colcount = Cells(I, Columns.Count).End(xlToLeft).Column
For j = 2 To Colcount
wks2.Cells(k, 1) = wks.Cells(I, 1)
wks2.Cells(k, 2) = wks.Cells(I, j)
k = k + 1
Next j
Next I

End Sub

Regards
Victor

On Fri, Apr 15, 2016 at 5:47 AM,  wrote:

>
>
> 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, total columns: 100)
>
>
>
> Sheet 2
>
>   A B
> 1 Door A2
> 2 Door B3
> 3 Door C2
> 4 Door L1
> 5 Furniture B2
> 6 Furniture B3
> 7 TV A1
> 8 TV A2
> 9 Kitchen L2
> 10 Kitchen L4
> 11 Kitchen Z1
> 12 Kitchen M2
> 13 Kitchen R3
> 14 Kitchen W5
>
>
> Thank you
>
> Jorge Cardenas
>
> --
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[jorgeexcel2016]

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, total columns: 100)



Sheet 2

  A B 
1 Door A2 
2 Door B3 
3 Door C2 
4 Door L1 
5 Furniture B2 
6 Furniture B3 
7 TV A1 
8 TV A2 
9 Kitchen L2 
10 Kitchen L4 
11 Kitchen Z1 
12 Kitchen M2 
13 Kitchen R3 
14 Kitchen W5


Thank you

Jorge Cardenas

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[mortgageprogrammer]

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 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.
For more options, visit https://groups.google.com/d/optout.

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

[ashish koul]

Share the sample file
On Nov 27, 2015 1:41 PM, "shilpag"  wrote:

> Hi
> I have developed a small desktop application with excel data which
> will be displayed on to Google Earth by VBA code.
>  The google earth is displaying coordinates  (values are looped by macro )
> but i am not able to show respective names for those coordinates ,
>  as getting Byref argument tyoe mismatch error.
>  Please help me to sort it out , since i have to give demo on the same in
> coming exams.
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[shilpag]

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 tyoe mismatch error. 
 Please help me to sort it out , since i have to give demo on the same in 
coming exams. 

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[Rama Chanattu]

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 number which may or may not repeat in the 
subsequent rows. What I am trying to do is to group the data based on 
“Order”, identify the highest “ID” (column-AC) in each group and mark that 
particular row with an “X” in column-U called “Confirmation”. If Order is 
not repeating, then mark that particular row “Confirmation” (Column-U) with 
“X”. 

   

Please support if any ideas.


Thanks in Advance..


Regards

Rama

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[Paul Schreiner]

what error?
I added it to my VBA project.I think you need adodb.Connection(see the ".")
Dim con as new adodb.connection 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: Satendra kumar 
 To: "xlvbacli...@googlegroups.com" ; 
excel-macros@googlegroups.com 
 Sent: 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 error at the 


Dim con as newadodb connection


Can some pleasetell me why is this error occurring, or how to come overview 
with it 


Thanks in advance

-- 
Thanks & RegardsSatendra Kumar-- 
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.
For more options, visit https://groups.google.com/d/optout.


   

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[Satendra kumar]

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 with it


Thanks in advance


-- 
Thanks & Regards
Satendra Kumar

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[sswcharlie]

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 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.
For more options, visit https://groups.google.com/d/optout.

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

[Anil Gawli]

Dear Gaurav,

Thisworkbook and activeworkbook is same when comes to work but the
difference is thisworkbook will work where the code is written and
activeworkbook will work with active file

On Mon, Mar 9, 2015 at 3:51 PM, Gaurav Devrani 
wrote:

> Hi,
>
> I tried working on that.. while I was 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 I am
> sure that in your code "Index" is referring to the sheet name that you want
> to unhide.
>
> Regards
> Gaurav Devrani
>
> On Wed, Mar 4, 2015 at 7:34 AM, Yahya Muhammad  wrote:
>
>>
>> Dears
>>
>> Any solution, please !
>>
>> On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad 
>> wrote:
>>
>>>
>>> Hi Experts
>>>
>>> I have an excel workbook, say Workbook1  with a vba on its workbook_open
>>>  event to hide all worksheets except one, as follows:
>>>
>>>
>>> -
>>> Private Sub Workbook_Open()
>>>
>>>   Dim sh As Worksheet
>>>
>>>   For Each sh In ThisWorkbook.Worksheets
>>>
>>> If sh.Name <> "Index" Then
>>> sh.Visible = xlSheetHidden
>>> End If
>>>   Next sh
>>>
>>> End Sub
>>>
>>>
>>> --
>>>
>>> But my issue is that when I open another workbook while workbook1 is
>>> open, (say workbook2), while working on both workbooks, suddenly all the
>>> sheets of workbook2 also goes hidden, except the first one. I am unable to
>>> find a solution for this. Please help.
>>>
>>> --
>>> 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.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
>
> *Thanks & Regards*
> *Gaurav Devrani*
>
>  --
> 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 t

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

[Gaurav Devrani]

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 I am
sure that in your code "Index" is referring to the sheet name that you want
to unhide.

Regards
Gaurav Devrani

On Wed, Mar 4, 2015 at 7:34 AM, Yahya Muhammad  wrote:

>
> Dears
>
> Any solution, please !
>
> On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad 
> wrote:
>
>>
>> Hi Experts
>>
>> I have an excel workbook, say Workbook1  with a vba on its workbook_open
>>  event to hide all worksheets except one, as follows:
>>
>>
>> -
>> Private Sub Workbook_Open()
>>
>>   Dim sh As Worksheet
>>
>>   For Each sh In ThisWorkbook.Worksheets
>>
>> If sh.Name <> "Index" Then
>> sh.Visible = xlSheetHidden
>> End If
>>   Next sh
>>
>> End Sub
>>
>>
>> --
>>
>> But my issue is that when I open another workbook while workbook1 is
>> open, (say workbook2), while working on both workbooks, suddenly all the
>> sheets of workbook2 also goes hidden, except the first one. I am unable to
>> find a solution for this. Please help.
>>
>> --
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>



-- 

*Thanks & Regards*
*Gaurav Devrani*

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

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

[Vaibhav Joshi]

Its really good!!

Cheers!!

On Tue, Mar 3, 2015 at 8:02 AM, Nilkanth Raval 
wrote:

> Hi Friends,
>
> Find attached some examples of VBA Macro
>
> *Thanks,*
> *Nilkanth Raval*
> *+91 900 428 0 428*
> *+91 808 000 1620*
> *Think Before You Print.Consider ENVIRONMENT.*
> *“SAVE TREES, SAVE EARTH” *
>
> *“All appears to change when we change!”*
>
>   --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[Yahya Muhammad]

Dears

Any solution, please !

On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad  wrote:

>
> Hi Experts
>
> I have an excel workbook, say Workbook1  with a vba on its workbook_open
>  event to hide all worksheets except one, as follows:
>
>
> -
> Private Sub Workbook_Open()
>
>   Dim sh As Worksheet
>
>   For Each sh In ThisWorkbook.Worksheets
>
> If sh.Name <> "Index" Then
> sh.Visible = xlSheetHidden
> End If
>   Next sh
>
> End Sub
>
>
> --
>
> But my issue is that when I open another workbook while workbook1 is open,
> (say workbook2), while working on both workbooks, suddenly all the sheets
> of workbook2 also goes hidden, except the first one. I am unable to find a
> solution for this. Please help.
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel VBA Example

[Nilkanth Raval]

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 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.
For more options, visit https://groups.google.com/d/optout.


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


Vlookup-return-multiple-records.xlsx
Description: MS-Excel 2007 spreadsheet


Return-multiple-values-horizontally.xlsx
Description: MS-Excel 2007 spreadsheet


Create-Links-To-All-Sheets-in-a-Workbook1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

[Yahya Muhammad]

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 Each sh In ThisWorkbook.Worksheets

If sh.Name <> "Index" Then
sh.Visible = xlSheetHidden
End If
  Next sh

End Sub

--

But my issue is that when I open another workbook while workbook1 is open,
(say workbook2), while working on both workbooks, suddenly all the sheets
of workbook2 also goes hidden, except the first one. I am unable to find a
solution for this. Please help.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[StephenB]

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 myRange As Range

Set myRange = Selection'
ActiveSheet.Range("$F$130:$F$141").RemoveDuplicates Columns:=1, Header:= _
xlNo
ActiveSheet.myRange.RemoveDuplicates Columns:=1, Header:= _
xlNoEnd Sub

Thanks!

StephenB

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[Prabhakar Thakur]

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 @ 
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.
For more options, visit https://groups.google.com/d/optout.

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

[OJEMENI Uzoma]

Excel VBA training needed online. Do you provide such services?
On 28 Jul 2014 02:41, "Sara Lee"  wrote:

> Does any one need help in Excel VBA  project or may be entire project to
> be completed?
>
> Let me know. You will get the solution at a reasonable price whether u in
> US or in India.
>
> I am in US right now.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[Sara Lee]

Does any one need help in Excel VBA  project or may be entire project to be
completed?

Let me know. You will get the solution at a reasonable price whether u in
US or in India.

I am in US right now.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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.
For more options, visit https://groups.google.com/d/optout.

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

[Pankaj Singh]

Hi
I am agree with paul and anil.
it's a violation of group policy


On Fri, Jun 20, 2014 at 9:52 PM, Ankur Gupta  wrote:

> hi Paul,
>
> the person who wrote the code has left the company and now i need the code
> behind in order to work further. I am not violating any policies dear.
> Please help me out if you could. please
>
>
> On Fri, Jun 20, 2014 at 4:17 AM, Paul Schreiner 
> wrote:
>
>> Really?
>>
>> #1) He said: " I cant pass the sheet as it can lead to violations on
>> company side"
>> #2) I'm sorry, it's a violation of group policy #3:
>>
>> * 3) Don't post questions regarding breaking or bypassing any security
>> measure*
>>
>> The reason is that we do not want to assist someone stealing another's
>> work.
>> Evidently, the author wanted to ensure others didn't have access to their
>> code.
>>
>> If you really wish to break their password protection, a simple Google
>> search for:
>> "excel vba password recovery"
>> results in 234,000 matches.
>>
>> *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:* Anil Gawli 
>> *To:* "excel-macros@googlegroups.com" ;
>> anky...@gmail.com
>> *Sent:* Friday, June 20, 2014 1:11 AM
>> *Subject:* Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view
>> the code
>>
>> Dear Ankur,
>>
>> Pl share the workbook with us.
>>
>> Warm Regards,
>> Gawli Anil.
>>
>> On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta  wrote:
>> > I am new to excel and absolutely a novice to vb. I have been given a
>> task to
>> > write macros code in vba in excel. The macro code is already there but
>> > nobody knows the password. So the button even in design mode doesnot
>> show
>> > view code. I just want to view to code behind. I cant pass the sheet as
>> it
>> > can lead to violations on company side. Can anyone please help me. Its
>> > really very very urgent and any sort of help will be great for me. I
>> have
>> > made the file unprotected but still i cannot view the code. Please help
>> me.
>> >
>> > Regards,
>> > anky
>> >
>> > --
>> > 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.
>> > For more options, visit https://groups.google.com/d/optout.
>>
>>
>> --
>> 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 anoth

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

[Paul Schreiner]

I don't wish to be insulting or suspicious.
 
You may or may not be violating your company policies,
but it is against the policy (rules) of THIS Forum.

If you are legitimately in need, there are services that are available for free 
or for a fee.
Google can provide the leads. 
I have utilized  a couple of these after forgetting my OWN passwords.

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: Ankur Gupta 
>To: excel-macros  
>Sent: Friday, June 20, 2014 12:22 PM
>Subject: Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code
>  
>
>
>hi Paul,
>
>
>the person who wrote the code has left the company and now i need the code 
>behind in order to work further. I am not violating any policies dear. Please 
>help me out if you could. please 
>
>
>
>On Fri, Jun 20, 2014 at 4:17 AM, Paul Schreiner  wrote:
>
>Really?
>>
>>#1) He said: " I cant pass the sheet as it can lead to violations on company 
>>side"
>>#2) I'm sorry, it's a violation of group policy #3:
>> 
>> 3) Don't post questions regarding breaking or bypassing any security measure
>>
>>The reason is that we do not want to assist someone stealing another's work.
>>Evidently, the author wanted to ensure others didn't have access to their 
>>code.
>>
>>If you really wish to break their password protection, a simple Google search 
>>for:
>>"excel vba password recovery" 
>>results in 234,000 matches.
>>
>>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: Anil Gawli 
>>>To: "excel-macros@googlegroups.com" ; 
>>>anky...@gmail.com 
>>>Sent: Friday, June 20, 2014 1:11 AM
>>>Subject: Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code
>>>  
>>>
>>>Dear Ankur,
>>>
>>>Pl share the workbook with us.
>>>
>>>Warm Regards,
>>>Gawli Anil.
>>>
>>>On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta  wrote:
>>>> I am new to excel and absolutely a
 novice to vb. I have been given a task to
>>>> write macros code in vba in excel. The macro code is already there but
>>>> nobody knows the password. So the button even in design mode doesnot show
>>>> view code. I just want to view to code behind. I cant pass the sheet as it
>>>> can lead to violations on company side. Can anyone please help me. Its
>>>> really very very urgent and any sort of help will be great for me. I have
>>>> made the file unprotected but still i cannot view the code. Please help me.
>>>>
>>>> Regards,
>>>> anky
>>>>
>>>> --
>>>> 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-macr

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

[Ankur Gupta]

hi Paul,

the person who wrote the code has left the company and now i need the code
behind in order to work further. I am not violating any policies dear.
Please help me out if you could. please


On Fri, Jun 20, 2014 at 4:17 AM, Paul Schreiner 
wrote:

> Really?
>
> #1) He said: " I cant pass the sheet as it can lead to violations on
> company side"
> #2) I'm sorry, it's a violation of group policy #3:
>
> * 3) Don't post questions regarding breaking or bypassing any security
> measure*
>
> The reason is that we do not want to assist someone stealing another's
> work.
> Evidently, the author wanted to ensure others didn't have access to their
> code.
>
> If you really wish to break their password protection, a simple Google
> search for:
> "excel vba password recovery"
> results in 234,000 matches.
>
> *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:* Anil Gawli 
> *To:* "excel-macros@googlegroups.com" ;
> anky...@gmail.com
> *Sent:* Friday, June 20, 2014 1:11 AM
> *Subject:* Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view
> the code
>
> Dear Ankur,
>
> Pl share the workbook with us.
>
> Warm Regards,
> Gawli Anil.
>
> On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta  wrote:
> > I am new to excel and absolutely a novice to vb. I have been given a
> task to
> > write macros code in vba in excel. The macro code is already there but
> > nobody knows the password. So the button even in design mode doesnot show
> > view code. I just want to view to code behind. I cant pass the sheet as
> it
> > can lead to violations on company side. Can anyone please help me. Its
> > really very very urgent and any sort of help will be great for me. I have
> > made the file unprotected but still i cannot view the code. Please help
> me.
> >
> > Regards,
> > anky
> >
> > --
> > 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.
> > For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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 

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

[Anil Gawli]

 Dear Ankur,

Fully agreed with paul.

Warm Regards,
Gawli Anil.

On Fri, Jun 20, 2014 at 4:47 PM, Paul Schreiner  wrote:
> Really?
>
> #1) He said: " I cant pass the sheet as it can lead to violations on company
> side"
> #2) I'm sorry, it's a violation of group policy #3:
>
>  3) Don't post questions regarding breaking or bypassing any security
> measure
>
> The reason is that we do not want to assist someone stealing another's work.
> Evidently, the author wanted to ensure others didn't have access to their
> code.
>
> If you really wish to break their password protection, a simple Google
> search for:
> "excel vba password recovery"
> results in 234,000 matches.
>
> 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: Anil Gawli 
> To: "excel-macros@googlegroups.com" ;
> anky...@gmail.com
> Sent: Friday, June 20, 2014 1:11 AM
> Subject: Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the
> code
>
> Dear Ankur,
>
> Pl share the workbook with us.
>
> Warm Regards,
> Gawli Anil.
>
> On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta  wrote:
>> I am new to excel and absolutely a novice to vb. I have been given a task
>> to
>> write macros code in vba in excel. The macro code is already there but
>> nobody knows the password. So the button even in design mode doesnot show
>> view code. I just want to view to code behind. I cant pass the sheet as it
>> can lead to violations on company side. Can anyone please help me. Its
>> really very very urgent and any sort of help will be great for me. I have
>> made the file unprotected but still i cannot view the code. Please help
>> me.
>>
>> Regards,
>> anky
>>
>> --
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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.
>

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

[Paul Schreiner]

Really?
 
#1) He said: " I cant pass the sheet as it can lead to violations on company 
side"
#2) I'm sorry, it's a violation of group policy #3:
 
 3) Don't post questions regarding breaking or bypassing any security measure
 
The reason is that we do not want to assist someone stealing another's work.
Evidently, the author wanted to ensure others didn't have access to their code.
 
If you really wish to break their password protection, a simple Google search 
for:
"excel vba password recovery"
results in 234,000 matches.

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: Anil Gawli 
>To: "excel-macros@googlegroups.com" ; 
>anky...@gmail.com 
>Sent: Friday, June 20, 2014 1:11 AM
>Subject: Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code
>  
>
>Dear Ankur,
>
>Pl share the workbook with us.
>
>Warm Regards,
>Gawli Anil.
>
>On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta  wrote:
>> I am new to excel and absolutely a novice to vb. I have been given a task to
>> write macros code in vba in excel. The macro code is already there but
>> nobody knows the password. So the button even in design mode doesnot show
>> view code. I just want to view to code behind. I cant pass the sheet as it
>> can lead to violations on company side. Can anyone please help me. Its
>> really very very urgent and any sort of help will be great for me. I have
>> made the file unprotected but still i cannot view the code. Please help me.
>>
>> Regards,
>> anky
>>
>> --
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>
>
>-- 
>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.
>For more options, visit https://groups.google.com/d/optout.
>
>

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

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

[Anil Gawli]

Dear Ankur,

Pl share the workbook with us.

Warm Regards,
Gawli Anil.

On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta  wrote:
> I am new to excel and absolutely a novice to vb. I have been given a task to
> write macros code in vba in excel. The macro code is already there but
> nobody knows the password. So the button even in design mode doesnot show
> view code. I just want to view to code behind. I cant pass the sheet as it
> can lead to violations on company side. Can anyone please help me. Its
> really very very urgent and any sort of help will be great for me. I have
> made the file unprotected but still i cannot view the code. Please help me.
>
> Regards,
> anky
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.

-- 
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.
For more options, visit https://groups.google.com/d/optout.

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

[Ankur Gupta]

I am new to excel and absolutely a novice to vb. I have been given a task 
to write macros code in vba in excel. The macro code is already there but 
nobody knows the password. So the button even in design mode doesnot show 
view code. I just want to view to code behind. I cant pass the sheet as it 
can lead to violations on company side. Can anyone please help me. Its 
really very very urgent and any sort of help will be great for me. I have 
made the file unprotected but still i cannot view the code. Please help me.

Regards,
anky

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel & VBA

[mrExcel4u]

Hi All,

Must visit below mentioned ...

Happy New Year 2014 

Thanks & regards,

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

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.
For more options, visit https://groups.google.com/groups/opt_out.

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

[Abhishek Jain]

Friends,...any update?


On Sat, Sep 7, 2013 at 11:21 AM, Abhishek Jain wrote:

> Hello friends,
>
> Let's say I have an Excel File with VBA and an a Form that is used to make
> entries in sheet. Is there a way I can make a Google Doc of it keeping the
> Form and all the VBA? I searched and found that Google docs do not support
> VBA but Java Scripts. Can someone share a way forward?
>
> On a separate note, my requirement is to let the Excel file used by
> several users across the internet (they are in multiple countries and we
> only have regular internet). Is there a place where the file can be placed
> and used by multiple people at once through the internet? (Don't want them
> to open a read only version).
>
> Hope my requirements are clear. Any and all help will be highly
> appreciated.
>
> Thanks in advance.
>
> Abhi
>
> --
> 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.
> 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.
For more options, visit https://groups.google.com/groups/opt_out.

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

[Abhishek Jain]

Hello friends,

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

On a separate note, my requirement is to let the Excel file used by several
users across the internet (they are in multiple countries and we only have
regular internet). Is there a place where the file can be placed and used
by multiple people at once through the internet? (Don't want them to open a
read only version).

Hope my requirements are clear. Any and all help will be highly appreciated.

Thanks in advance.

Abhi

-- 
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.
For more options, visit https://groups.google.com/groups/opt_out.

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

[mathan4s...@gmail.com]

Thanks david ! 

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

OK.  To to this 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
David Grugeon



On 10 May 2013 06:42, Mathan  wrote:

> Sorry, please refer to this screenshot. Thanks
>
>
> On Fri, May 10, 2013 at 2:11 AM, Mathan  wrote:
>
>> Hi David,
>>
>> Please refer to the attached screenshot. I believe you would get my point
>> after seeing that. I might have confused you earlier.
>>
>> Thanks
>> Mathan
>>
>>
>> On Thu, May 9, 2013 at 12:30 PM, David Grugeon wrote:
>>
>>> In essence, internet explorer does not understand excel files.  You
>>> could save the file as a web page and load that.  It would not have the
>>> functionality of excel though.
>>>
>>> There are some proprietary products which allow you to run excel
>>> spreadsheets through a browser.  They cost though!  Min $500, I think.
>>>
>>> Or you could upload the file to Google Apps or Office 365 and then open
>>> that in a browser.
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 9 May 2013 16:31, Mathan  wrote:
>>>
>>>> Hi David/Anil,
>>>>
>>>> We are trying to upload the excel file through excel vba.
>>>>
>>>> The files are from common shared folder not on the local drive.
>>>>
>>>> I hope this helps, However, I will share the screenshot by tonight.
>>>> Thanks for your time.
>>>>
>>>> Thanks
>>>>
>>>>
>>>> On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote:
>>>>
>>>>> 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 located.
>>>>>
>>>>> We also need to know why VBA code is required, rather than simply a
>>>>> hyperlink.
>>>>>
>>>>> Regards
>>>>> David Grugeon
>>>>>
>>>>>
>>>>>
>>>>> On 9 May 2013 06:56, Mathan  wrote:
>>>>>
>>>>>> Hi Experts,
>>>>>>
>>>>>> I'm trying to upload a file from shared folder (directory) to the
>>>>>> internet explorer.
>>>>>>
>>>>>> Need a VBA code to do this. Could anyone help me on this?
>>>>>>
>>>>>> Thanks 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.
>>>>>&

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

[mishra . mudit]

I
Sent from BlackBerry® on Airtel

-Original Message-
From: David Grugeon 
Sender: excel-macros@googlegroups.com
Date: Fri, 10 May 2013 12:08:12 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel VBA code to handle "choose 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
David Grugeon



On 10 May 2013 06:42, Mathan  wrote:

> Sorry, please refer to this screenshot. Thanks
>
>
> On Fri, May 10, 2013 at 2:11 AM, Mathan  wrote:
>
>> Hi David,
>>
>> Please refer to the attached screenshot. I believe you would get my point
>> after seeing that. I might have confused you earlier.
>>
>> Thanks
>> Mathan
>>
>>
>> On Thu, May 9, 2013 at 12:30 PM, David Grugeon wrote:
>>
>>> In essence, internet explorer does not understand excel files.  You
>>> could save the file as a web page and load that.  It would not have the
>>> functionality of excel though.
>>>
>>> There are some proprietary products which allow you to run excel
>>> spreadsheets through a browser.  They cost though!  Min $500, I think.
>>>
>>> Or you could upload the file to Google Apps or Office 365 and then open
>>> that in a browser.
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 9 May 2013 16:31, Mathan  wrote:
>>>
>>>> Hi David/Anil,
>>>>
>>>> We are trying to upload the excel file through excel vba.
>>>>
>>>> The files are from common shared folder not on the local drive.
>>>>
>>>> I hope this helps, However, I will share the screenshot by tonight.
>>>> Thanks for your time.
>>>>
>>>> Thanks
>>>>
>>>>
>>>> On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote:
>>>>
>>>>> 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 located.
>>>>>
>>>>> We also need to know why VBA code is required, rather than simply a
>>>>> hyperlink.
>>>>>
>>>>> Regards
>>>>> David Grugeon
>>>>>
>>>>>
>>>>>
>>>>> On 9 May 2013 06:56, Mathan  wrote:
>>>>>
>>>>>> Hi Experts,
>>>>>>
>>>>>> I'm trying to upload a file from shared folder (directory) to the
>>>>>> internet explorer.
>>>>>>
>>>>>> Need a VBA code to do this. Could anyone help me on this?
>>>>>>
>>>>>> Thanks 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 

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

[David Grugeon]

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
David Grugeon



On 10 May 2013 06:42, Mathan  wrote:

> Sorry, please refer to this screenshot. Thanks
>
>
> On Fri, May 10, 2013 at 2:11 AM, Mathan  wrote:
>
>> Hi David,
>>
>> Please refer to the attached screenshot. I believe you would get my point
>> after seeing that. I might have confused you earlier.
>>
>> Thanks
>> Mathan
>>
>>
>> On Thu, May 9, 2013 at 12:30 PM, David Grugeon wrote:
>>
>>> In essence, internet explorer does not understand excel files.  You
>>> could save the file as a web page and load that.  It would not have the
>>> functionality of excel though.
>>>
>>> There are some proprietary products which allow you to run excel
>>> spreadsheets through a browser.  They cost though!  Min $500, I think.
>>>
>>> Or you could upload the file to Google Apps or Office 365 and then open
>>> that in a browser.
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 9 May 2013 16:31, Mathan  wrote:
>>>
 Hi David/Anil,

 We are trying to upload the excel file through excel vba.

 The files are from common shared folder not on the local drive.

 I hope this helps, However, I will share the screenshot by tonight.
 Thanks for your time.

 Thanks


 On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote:

> 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 located.
>
> We also need to know why VBA code is required, rather than simply a
> hyperlink.
>
> Regards
> David Grugeon
>
>
>
> On 9 May 2013 06:56, Mathan  wrote:
>
>> Hi Experts,
>>
>> I'm trying to upload a file from shared folder (directory) to the
>> internet explorer.
>>
>> Need a VBA code to do this. Could anyone help me on this?
>>
>> Thanks 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+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.
> 

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

[ashish koul]

see if it helps
http://www.motobit.com/tips/detpg_uploadvbaie/


On Thu, May 9, 2013 at 12:30 PM, David Grugeon  wrote:

> In essence, internet explorer does not understand excel files.  You could
> save the file as a web page and load that.  It would not have the
> functionality of excel though.
>
> There are some proprietary products which allow you to run excel
> spreadsheets through a browser.  They cost though!  Min $500, I think.
>
> Or you could upload the file to Google Apps or Office 365 and then open
> that in a browser.
>
> Regards
> David Grugeon
>
>
>
> On 9 May 2013 16:31, Mathan  wrote:
>
>> Hi David/Anil,
>>
>> We are trying to upload the excel file through excel vba.
>>
>> The files are from common shared folder not on the local drive.
>>
>> I hope this helps, However, I will share the screenshot by tonight.
>> Thanks for your time.
>>
>> Thanks
>>
>>
>> On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote:
>>
>>> 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 located.
>>>
>>> We also need to know why VBA code is required, rather than simply a
>>> hyperlink.
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 9 May 2013 06:56, Mathan  wrote:
>>>
 Hi Experts,

 I'm trying to upload a file from shared folder (directory) to the
 internet explorer.

 Need a VBA code to do this. Could anyone help me on this?

 Thanks 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+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 

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

[David Grugeon]

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, I think.

Or you could upload the file to Google Apps or Office 365 and then open
that in a browser.

Regards
David Grugeon



On 9 May 2013 16:31, Mathan  wrote:

> Hi David/Anil,
>
> We are trying to upload the excel file through excel vba.
>
> The files are from common shared folder not on the local drive.
>
> I hope this helps, However, I will share the screenshot by tonight. Thanks
> for your time.
>
> Thanks
>
>
> On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote:
>
>> 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 located.
>>
>> We also need to know why VBA code is required, rather than simply a
>> hyperlink.
>>
>> Regards
>> David Grugeon
>>
>>
>>
>> On 9 May 2013 06:56, Mathan  wrote:
>>
>>> Hi Experts,
>>>
>>> I'm trying to upload a file from shared folder (directory) to the
>>> internet explorer.
>>>
>>> Need a VBA code to do this. Could anyone help me on this?
>>>
>>> Thanks 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+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.
> -

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

[Mathan]

Hi David/Anil,

We are trying to upload the excel file through excel vba.

The files are from common shared folder not on the local drive.

I hope this helps, However, I will share the screenshot by tonight. Thanks
for your time.

Thanks


On Thu, May 9, 2013 at 10:11 AM, David Grugeon  wrote:

> 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 located.
>
> We also need to know why VBA code is required, rather than simply a
> hyperlink.
>
> Regards
> David Grugeon
>
>
>
> On 9 May 2013 06:56, Mathan  wrote:
>
>> Hi Experts,
>>
>> I'm trying to upload a file from shared folder (directory) to the
>> internet explorer.
>>
>> Need a VBA code to do this. Could anyone help me on this?
>>
>> Thanks 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+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.

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

[David Grugeon]

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

We also need to know why VBA code is required, rather than simply a
hyperlink.

Regards
David Grugeon



On 9 May 2013 06:56, Mathan  wrote:

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

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

[अनिल नारायण गवली]

Dear Manthan,


Pls Elaborate More with Eg.

Warm Regards,
Gawli Anil


On Thu, May 9, 2013 at 2:26 AM, Mathan  wrote:

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



-- 
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.
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$$ Excel VBA code to handle "choose file to upload " window in internet explorer

[Mathan]

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 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$$ Excel-VBA QUIZ

[Gyana Ranjan Das]

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 take initiative to arrange such
quiz contests may be on weekly, fortnightly or monthly basis if possible.
It helps  the *group* to analyze ourselves where we are...


*Gratitude & Regards,*
*Gyana Ranjan Das*
*Life is an experiment. The more experiments you make the better*


On Fri, Mar 22, 2013 at 12:38 PM, NOORAIN ANSARI
wrote:

> Dear Group,
>
> Hope you are doing well.
>
> Now You have a new Quiz, Please solve, revert and analyze where you are?
> Quiz Link is here :
>
> Note: You have to write full form of Excel,VBA and MS Access Keywords.
>
> Quiz-2
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>
>
> --
> 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.
>
>
>

-- 
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$$ Excel-VBA QUIZ

[NOORAIN ANSARI]

Dear Group,

Hope you are doing well.

Now You have a new Quiz, Please solve, revert and analyze where you are?
Quiz Link is here :

Note: You have to write full form of Excel,VBA and MS Access Keywords.

Quiz-2



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




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

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

[Paul Schreiner]

Sorry,
I (quite often) work on several tasks at one time.
In fact, about the only time my priorities remain unchanged is when I'm working 
early mornings (before others arrive) and on the weekends if I'm working from 
home.

I've been pursuing an approach to accessing the data directly from Sharepoint 
instead of the linked Access database.
Primarily because I'm not sure if when the end-user runs the retrieval macro, 
if 
MSAccess will have to be running and have the linked database open in order to 
function properly.

That is, when I can get to it.

I'll post when I have made some progress.

thanks again,

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: Prince 
To: excel-macros@googlegroups.com
Sent: Fri, March 8, 2013 12:00:35 AM
Subject: Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

Hi Paul, 

I think the solutions given by Sam and Me are 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 " 
>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 bypass

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

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" gr

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

[David Grugeon]

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  'cvml', 'excel-macros%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to 
> excel-macros@googlegroups.com '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'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$$ Excel VBA to loop through rows and delete blank lines

[David McLaughlin]

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 and delete it
>  
> Regards,
> Gawli anil
>
> On Thu, Jul 26, 2012 at 8:42 AM, NOORAIN ANSARI 
> 
> > wrote:
>
>> Dear Tony,
>>
>> Please try it..
>>
>> *Sub DeleteBlank()*
>> *On Error Resume Next
>> ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
>> On Error GoTo 0: On Error GoTo -1: Err.Clear*
>> *End Sub*
>>  
>>
>> On Thu, Jul 26, 2012 at 5:13 AM, Tony O <> wrote:
>>
>>> I am working on a spreadsheet with 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, but I am not 
>>> getting it to work the way I want to:
>>>
>>> dim rowchk as integer
>>>
>>> for rowchk = 1 to 1000
>>> if activecell.Arowchk ="" then Selection.Delete Shift:=xlUp
>>> end if
>>>
>>> Please advise.
>>>
>>>
>>>
>>>
>>>
>>> -- 
>>> -- 
>>> FORUM RULES (986+ members already BANNED for violation)
>>>  
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
>>> signatures are prohibited. 
>>>  
>>> NOTE : Don't ever post personal or confidential data in a workbook. 
>>> Forum owners and members are not responsible for any loss.
>>>  
>>>
>>> --
>>> To post to this group, send email to excel-...@googlegroups.com
>>>  
>>> To unsubscribe, send a blank email to 
>>> excel-macros...@googlegroups.com
>>>  
>>>  
>>>
>>
>>
>>
>> -- 
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.blogspot.com 
>> http://accesssqclinic.blogspot.in/
>>   
>>
>>
>>
>> -- 
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-...@googlegroups.com
>>  
>> To unsubscribe, send a blank email to 
>> excel-macros...@googlegroups.com
>>  
>>  
>>
>
>
>
> -- 
> 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.
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 m

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

[Sam Mathai Chacko]

This has most of it

http://www.excelfox.com/forum/f13/execute-sql-excel-vba-66/

Regards,
Sam


On Mon, Mar 4, 2013 at 11:50 PM, Paul Schreiner wrote:

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



-- 
Sam Mathai Chacko

-- 
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$$ Excel VBA to retrieve from MSAccess or Sharepoint

[Paul Schreiner]

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.

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

[NOORAIN ANSARI]

Dear Yahya,

Pls visit on below link,hope it will help to you.

http://www.ozgrid.com/forum/showthread.php?t=66674


On Wed, Jan 30, 2013 at 12:49 AM, Yahya Muhammad  wrote:

>
> Dear Ashish
>
> This is what I want. But could not make it work in my file, which is
> attached. Please help.
>
>
> On Tue, Jan 29, 2013 at 5:22 PM, ashish koul wrote:
>
>> @Yahya Try the attached file
>>
>>
>> On Tue, Jan 29, 2013 at 6:15 PM, amar takale wrote:
>>
>>> Dear Yahya Muhamma & Anil,
>>> Sorry for that,I will post my query in a separate thread:
>>> Amar
>>>
>>> On Tue, Jan 29, 2013 at 6:14 PM, amar takale 
>>> wrote:
>>> > Hi Anil,
>>> > Sorry for that,I will post my query in a separate thread:
>>> > Amar
>>> >
>>> > On Tue, Jan 29, 2013 at 4:41 PM, Yahya Muhammad 
>>> wrote:
>>> >> Dear Amar
>>> >>
>>> >> Please read Forum Rule No. 2  and post your query in a separate
>>> thread:
>>> >>
>>> >> 2) Don't post a question in the thread of another member.
>>> >>
>>> >>
>>> >> On Tue, Jan 29, 2013 at 1:43 PM, amar takale 
>>> wrote:
>>> >>>
>>> >>> Hi Anil,
>>> >>> I want Ascending & Decending data then how to VBA Code used.only I
>>> >>> click button which column on Ascending & Decending then that column
>>> >>> sort with other data.I send Example file pls see it
>>> >>> Appreciate the help.
>>> >>>
>>> >>> Regards
>>> >>> Amar
>>> >>>
>>> >>> On Tue, Jan 29, 2013 at 2:46 PM, Yahya Muhammad 
>>> >>> wrote:
>>> >>> > Dear Anil
>>> >>> >
>>> >>> > Thanks again. However, here also the sorting occurs in the sheet,
>>> which
>>> >>> > I do
>>> >>> > not want.
>>> >>> >
>>> >>> >
>>> >>> > On Tue, Jan 29, 2013 at 9:25 AM, अनिल नारायण गवली
>>> >>> > 
>>> >>> > wrote:
>>> >>> >>
>>> >>> >> Dear Yahya,
>>> >>> >>
>>> >>> >> See the attached sheet .  is it ok??
>>> >>> >>
>>> >>> >> Wrm Regards,
>>> >>> >> Gawli Anil
>>> >>> >>
>>> >>> >> On Tue, Jan 29, 2013 at 11:47 AM, Yahya Muhammad <
>>> yahya...@gmail.com>
>>> >>> >> wrote:
>>> >>> >>>
>>> >>> >>>
>>> >>> >>> Dear Anil
>>> >>> >>>
>>> >>> >>> Thanks. However, I can't adapt this method , as my combo box is
>>> in a
>>> >>> >>> userform and I cannot sort the column in the worksheet.
>>> >>> >>>
>>> >>> >>>
>>> >>> >>> On Tue, Jan 29, 2013 at 9:12 AM, अनिल नारायण गवली
>>> >>> >>>  wrote:
>>> >>> 
>>> >>>  Dear *Yahya,*
>>> >>> 
>>> >>>  Pl see the attached sheet is it ok?
>>> >>> 
>>> >>> 
>>> >>>  Warm Regards,
>>> >>>  Gawli Anil
>>> >>> 
>>> >>>  On Tue, Jan 29, 2013 at 11:09 AM, Yahya Muhammad <
>>> yahya...@gmail.com>
>>> >>>  wrote:
>>> >>> >
>>> >>> > Dears
>>> >>> >
>>> >>> > I have an excel userform with a combobox which select  the
>>> items
>>> >>> > from a
>>> >>> > column in a worksheet. This column can't be sorted. I would
>>> like to
>>> >>> > have the
>>> >>> > list in the combobox to get sorted ascending, while
>>> initializing the
>>> >>> > userform. I am now using below code to load the combobox with
>>> >>> > values. Can
>>> >>> > someone suggest the modification to be applied to this code?
>>> >>> >
>>> >>> > Thanks
>>> >>> >
>>> >>> >
>>> >>> > Private Sub UserForm_Initialize()
>>> >>> >
>>> >>> > With Worksheets("Sheet1")
>>> >>> > sq = .Range("A2:A" & .Cells(Rows.Count, 1).End(xlUp).Row)
>>> >>> > cboFirstName.List = sq
>>> >>> > Label1.Caption = .Range("A1").Value
>>> >>> >
>>> >>> > Label2.Caption = .Range("B1").Value
>>> >>> >
>>> >>> > Label3.Caption = .Range("C1").Value
>>> >>> >
>>> >>> > cboFirstName.SetFocus
>>> >>> >
>>> >>> > End Sub
>>> >>> >
>>> >>> > --
>>> >>> > 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.
>>> >>>

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

[amar takale]

Dear Yahya Muhamma & Anil,
Sorry for that,I will post my query in a separate thread:
Amar

On Tue, Jan 29, 2013 at 6:14 PM, amar takale  wrote:
> Hi Anil,
> Sorry for that,I will post my query in a separate thread:
> Amar
>
> On Tue, Jan 29, 2013 at 4:41 PM, Yahya Muhammad  wrote:
>> Dear Amar
>>
>> Please read Forum Rule No. 2  and post your query in a separate thread:
>>
>> 2) Don't post a question in the thread of another member.
>>
>>
>> On Tue, Jan 29, 2013 at 1:43 PM, amar takale  wrote:
>>>
>>> Hi Anil,
>>> I want Ascending & Decending data then how to VBA Code used.only I
>>> click button which column on Ascending & Decending then that column
>>> sort with other data.I send Example file pls see it
>>> Appreciate the help.
>>>
>>> Regards
>>> Amar
>>>
>>> On Tue, Jan 29, 2013 at 2:46 PM, Yahya Muhammad 
>>> wrote:
>>> > Dear Anil
>>> >
>>> > Thanks again. However, here also the sorting occurs in the sheet, which
>>> > I do
>>> > not want.
>>> >
>>> >
>>> > On Tue, Jan 29, 2013 at 9:25 AM, अनिल नारायण गवली
>>> > 
>>> > wrote:
>>> >>
>>> >> Dear Yahya,
>>> >>
>>> >> See the attached sheet .  is it ok??
>>> >>
>>> >> Wrm Regards,
>>> >> Gawli Anil
>>> >>
>>> >> On Tue, Jan 29, 2013 at 11:47 AM, Yahya Muhammad 
>>> >> wrote:
>>> >>>
>>> >>>
>>> >>> Dear Anil
>>> >>>
>>> >>> Thanks. However, I can't adapt this method , as my combo box is in a
>>> >>> userform and I cannot sort the column in the worksheet.
>>> >>>
>>> >>>
>>> >>> On Tue, Jan 29, 2013 at 9:12 AM, अनिल नारायण गवली
>>> >>>  wrote:
>>> 
>>>  Dear Yahya,
>>> 
>>>  Pl see the attached sheet is it ok?
>>> 
>>> 
>>>  Warm Regards,
>>>  Gawli Anil
>>> 
>>>  On Tue, Jan 29, 2013 at 11:09 AM, Yahya Muhammad 
>>>  wrote:
>>> >
>>> > Dears
>>> >
>>> > I have an excel userform with a combobox which select  the items
>>> > from a
>>> > column in a worksheet. This column can't be sorted. I would like to
>>> > have the
>>> > list in the combobox to get sorted ascending, while initializing the
>>> > userform. I am now using below code to load the combobox with
>>> > values. Can
>>> > someone suggest the modification to be applied to this code?
>>> >
>>> > Thanks
>>> >
>>> >
>>> > Private Sub UserForm_Initialize()
>>> >
>>> > With Worksheets("Sheet1")
>>> > sq = .Range("A2:A" & .Cells(Rows.Count, 1).End(xlUp).Row)
>>> > cboFirstName.List = sq
>>> > Label1.Caption = .Range("A1").Value
>>> >
>>> > Label2.Caption = .Range("B1").Value
>>> >
>>> > Label3.Caption = .Range("C1").Value
>>> >
>>> > cboFirstName.SetFocus
>>> >
>>> > End Sub
>>> >
>>> > --
>>> > 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.
>>> >
>>> >
>>> 
>>> 
>>> 
>>> 
>>>  --
>>>  Thanks & Regards,
>>>  Gawli Anil Narayan
>>>  Software Developer,
>>>  Abacus Software Services Pvt Ltd
>>> 
>>>  --
>>>  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) Job

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

[amar takale]

Hi Anil,
Sorry for that,I will post my query in a separate thread:
Amar

On Tue, Jan 29, 2013 at 4:41 PM, Yahya Muhammad  wrote:
> Dear Amar
>
> Please read Forum Rule No. 2  and post your query in a separate thread:
>
> 2) Don't post a question in the thread of another member.
>
>
> On Tue, Jan 29, 2013 at 1:43 PM, amar takale  wrote:
>>
>> Hi Anil,
>> I want Ascending & Decending data then how to VBA Code used.only I
>> click button which column on Ascending & Decending then that column
>> sort with other data.I send Example file pls see it
>> Appreciate the help.
>>
>> Regards
>> Amar
>>
>> On Tue, Jan 29, 2013 at 2:46 PM, Yahya Muhammad 
>> wrote:
>> > Dear Anil
>> >
>> > Thanks again. However, here also the sorting occurs in the sheet, which
>> > I do
>> > not want.
>> >
>> >
>> > On Tue, Jan 29, 2013 at 9:25 AM, अनिल नारायण गवली
>> > 
>> > wrote:
>> >>
>> >> Dear Yahya,
>> >>
>> >> See the attached sheet .  is it ok??
>> >>
>> >> Wrm Regards,
>> >> Gawli Anil
>> >>
>> >> On Tue, Jan 29, 2013 at 11:47 AM, Yahya Muhammad 
>> >> wrote:
>> >>>
>> >>>
>> >>> Dear Anil
>> >>>
>> >>> Thanks. However, I can't adapt this method , as my combo box is in a
>> >>> userform and I cannot sort the column in the worksheet.
>> >>>
>> >>>
>> >>> On Tue, Jan 29, 2013 at 9:12 AM, अनिल नारायण गवली
>> >>>  wrote:
>> 
>>  Dear Yahya,
>> 
>>  Pl see the attached sheet is it ok?
>> 
>> 
>>  Warm Regards,
>>  Gawli Anil
>> 
>>  On Tue, Jan 29, 2013 at 11:09 AM, Yahya Muhammad 
>>  wrote:
>> >
>> > Dears
>> >
>> > I have an excel userform with a combobox which select  the items
>> > from a
>> > column in a worksheet. This column can't be sorted. I would like to
>> > have the
>> > list in the combobox to get sorted ascending, while initializing the
>> > userform. I am now using below code to load the combobox with
>> > values. Can
>> > someone suggest the modification to be applied to this code?
>> >
>> > Thanks
>> >
>> >
>> > Private Sub UserForm_Initialize()
>> >
>> > With Worksheets("Sheet1")
>> > sq = .Range("A2:A" & .Cells(Rows.Count, 1).End(xlUp).Row)
>> > cboFirstName.List = sq
>> > Label1.Caption = .Range("A1").Value
>> >
>> > Label2.Caption = .Range("B1").Value
>> >
>> > Label3.Caption = .Range("C1").Value
>> >
>> > cboFirstName.SetFocus
>> >
>> > End Sub
>> >
>> > --
>> > 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.
>> >
>> >
>> 
>> 
>> 
>> 
>>  --
>>  Thanks & Regards,
>>  Gawli Anil Narayan
>>  Software Developer,
>>  Abacus Software Services Pvt Ltd
>> 
>>  --
>>  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$$ Excel vba code to sort the userform combobox list ascending

[Yahya Muhammad]

Dear Amar

Please read Forum Rule No. 2  and post your query in a separate thread:

2) Don't post a question in the thread of another member.


On Tue, Jan 29, 2013 at 1:43 PM, amar takale  wrote:

> Hi Anil,
> I want Ascending & Decending data then how to VBA Code used.only I
> click button which column on Ascending & Decending then that column
> sort with other data.I send Example file pls see it
> Appreciate the help.
>
> Regards
> Amar
>
> On Tue, Jan 29, 2013 at 2:46 PM, Yahya Muhammad 
> wrote:
> > Dear Anil
> >
> > Thanks again. However, here also the sorting occurs in the sheet, which
> I do
> > not want.
> >
> >
> > On Tue, Jan 29, 2013 at 9:25 AM, अनिल नारायण गवली <
> gawlianil8...@gmail.com>
> > wrote:
> >>
> >> Dear Yahya,
> >>
> >> See the attached sheet .  is it ok??
> >>
> >> Wrm Regards,
> >> Gawli Anil
> >>
> >> On Tue, Jan 29, 2013 at 11:47 AM, Yahya Muhammad 
> >> wrote:
> >>>
> >>>
> >>> Dear Anil
> >>>
> >>> Thanks. However, I can't adapt this method , as my combo box is in a
> >>> userform and I cannot sort the column in the worksheet.
> >>>
> >>>
> >>> On Tue, Jan 29, 2013 at 9:12 AM, अनिल नारायण गवली
> >>>  wrote:
> 
>  Dear Yahya,
> 
>  Pl see the attached sheet is it ok?
> 
> 
>  Warm Regards,
>  Gawli Anil
> 
>  On Tue, Jan 29, 2013 at 11:09 AM, Yahya Muhammad 
>  wrote:
> >
> > Dears
> >
> > I have an excel userform with a combobox which select  the items
> from a
> > column in a worksheet. This column can't be sorted. I would like to
> have the
> > list in the combobox to get sorted ascending, while initializing the
> > userform. I am now using below code to load the combobox with
> values. Can
> > someone suggest the modification to be applied to this code?
> >
> > Thanks
> >
> >
> > Private Sub UserForm_Initialize()
> >
> > With Worksheets("Sheet1")
> > sq = .Range("A2:A" & .Cells(Rows.Count, 1).End(xlUp).Row)
> > cboFirstName.List = sq
> > Label1.Caption = .Range("A1").Value
> >
> > Label2.Caption = .Range("B1").Value
> >
> > Label3.Caption = .Range("C1").Value
> >
> > cboFirstName.SetFocus
> >
> > End Sub
> >
> > --
> > 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.
> >
> >
> 
> 
> 
> 
>  --
>  Thanks & Regards,
>  Gawli Anil Narayan
>  Software Developer,
>  Abacus Software Services Pvt Ltd
> 
>  --
>  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:/

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

[amar takale]

Hi Anil,
I want Ascending & Decending data then how to VBA Code used.only I
click button which column on Ascending & Decending then that column
sort with other data.I send Example file pls see it
Appreciate the help.

Regards
Amar

On Tue, Jan 29, 2013 at 2:46 PM, Yahya Muhammad  wrote:
> Dear Anil
>
> Thanks again. However, here also the sorting occurs in the sheet, which I do
> not want.
>
>
> On Tue, Jan 29, 2013 at 9:25 AM, अनिल नारायण गवली 
> wrote:
>>
>> Dear Yahya,
>>
>> See the attached sheet .  is it ok??
>>
>> Wrm Regards,
>> Gawli Anil
>>
>> On Tue, Jan 29, 2013 at 11:47 AM, Yahya Muhammad 
>> wrote:
>>>
>>>
>>> Dear Anil
>>>
>>> Thanks. However, I can't adapt this method , as my combo box is in a
>>> userform and I cannot sort the column in the worksheet.
>>>
>>>
>>> On Tue, Jan 29, 2013 at 9:12 AM, अनिल नारायण गवली
>>>  wrote:

 Dear Yahya,

 Pl see the attached sheet is it ok?


 Warm Regards,
 Gawli Anil

 On Tue, Jan 29, 2013 at 11:09 AM, Yahya Muhammad 
 wrote:
>
> Dears
>
> I have an excel userform with a combobox which select  the items from a
> column in a worksheet. This column can't be sorted. I would like to have 
> the
> list in the combobox to get sorted ascending, while initializing the
> userform. I am now using below code to load the combobox with values. Can
> someone suggest the modification to be applied to this code?
>
> Thanks
>
>
> Private Sub UserForm_Initialize()
>
> With Worksheets("Sheet1")
> sq = .Range("A2:A" & .Cells(Rows.Count, 1).End(xlUp).Row)
> cboFirstName.List = sq
> Label1.Caption = .Range("A1").Value
>
> Label2.Caption = .Range("B1").Value
>
> Label3.Caption = .Range("C1").Value
>
> cboFirstName.SetFocus
>
> End Sub
>
> --
> 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.
>
>




 --
 Thanks & Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd

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


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

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

[Yahya Muhammad]

​Dear Anil

Thanks again. However, here also the sorting occurs in the sheet, which I
do not want.


On Tue, Jan 29, 2013 at 9:25 AM, अनिल नारायण गवली
wrote:

> Dear Yahya,
>
> See the attached sheet .  is it ok??
>
> Wrm Regards,
> Gawli Anil
>
> On Tue, Jan 29, 2013 at 11:47 AM, Yahya Muhammad wrote:
>
>>
>> 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.com> wrote:
>>
>>> Dear Yahya,
>>>
>>> Pl see the attached sheet is it ok?
>>>
>>>
>>> Warm Regards,
>>> Gawli Anil
>>>
>>> On Tue, Jan 29, 2013 at 11:09 AM, Yahya Muhammad wrote:
>>>
 Dears

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

 Thanks


 Private Sub UserForm_Initialize()

 With Worksheets("Sheet1")
 sq = .Range("A2:A" & .Cells(Rows.Count, 1).End(xlUp).Row)
 cboFirstName.List = sq
 Label1.Caption = .Range("A1").Value

 Label2.Caption = .Range("B1").Value

 Label3.Caption = .Range("C1").Value

 cboFirstName.SetFocus

 End Sub

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



>>>
>>>
>>>
>>> --
>>> Thanks & Regards,
>>> Gawli Anil Narayan
>>> Software Developer,
>>> Abacus Software Services Pvt Ltd
>>>
>>> --
>>> 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.
>>>
>>>
>>>
>>
>>  --
>> 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 ar

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

[Yahya Muhammad]

Dear Anil

Thanks. However, I can't adapt this method , as my combo box is in ​a
userform and I cannot sort the column in the worksheet.


On Tue, Jan 29, 2013 at 9:12 AM, अनिल नारायण गवली
wrote:

> Dear Yahya,
>
> Pl see the attached sheet is it ok?
>
>
> Warm Regards,
> Gawli Anil
>
> On Tue, Jan 29, 2013 at 11:09 AM, Yahya Muhammad wrote:
>
>> Dears
>>
>> I have an excel userform with a combobox which select  the items from
>> a  column in a worksheet. This column can't be sorted. I would like to have
>> the list in the combobox to get sorted ascending, while initializing the
>> userform. I am now using below code to load the combobox with values. Can
>> someone suggest the modification to be applied to this code?
>>
>> Thanks
>>
>>
>> Private Sub UserForm_Initialize()
>>
>> With Worksheets("Sheet1")
>> sq = .Range("A2:A" & .Cells(Rows.Count, 1).End(xlUp).Row)
>> cboFirstName.List = sq
>> Label1.Caption = .Range("A1").Value
>>
>> Label2.Caption = .Range("B1").Value
>>
>> Label3.Caption = .Range("C1").Value
>>
>> cboFirstName.SetFocus
>>
>> End Sub
>>
>> --
>> 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.
>>
>>
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> 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.
>
>
>

-- 
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$$ Excel vba code to sort the userform combobox list ascending

[Yahya Muhammad]

Dears

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

Thanks


Private Sub UserForm_Initialize()

With Worksheets("Sheet1")
sq = .Range("A2:A" & .Cells(Rows.Count, 1).End(xlUp).Row)
cboFirstName.List = sq
Label1.Caption = .Range("A1").Value

Label2.Caption = .Range("B1").Value

Label3.Caption = .Range("C1").Value

cboFirstName.SetFocus

End Sub

-- 
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$$ Excel VBA Query

[ashish koul]

Add a new blank column before A in both the workbooks and use below formula
in cell a2 and fill it down

IF(B2<>"",B2&C2,LEFT(A1,FIND(C1,A1))&C2)


then use simple vlookup to get the status

Regards
Ashish





On Sat, Oct 20, 2012 at 6:14 PM, Manish Bankoti
wrote:

> Hi,
>
>  Please find attached two files - Input and Output...Need to fill "Follow
> up" column with the help of input file with the help of VBA...Matching
> countries and sub countries both..It can have duplicate sub countries so it
> both A and B columns should be matched...Need on urgent basis, please reply.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

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

[Dhartikumar Sahu]

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 | Mumbai – 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Excel vba

[Mangesh Vimay]

I am agree with Paul.
This group is the main source of information on Excel and its basics.

On Wed, Sep 12, 2012 at 7:40 PM, Paul Schreiner wrote:

> I don't mean to be difficult, or unhelpful, or snotty, or seem to be any
> other bad description,
> but this group is designed to help people that are having difficulty with
> VBA macros.
> Not necessarily teach VBA from scratch.
>
> I think one of the BIGGEST lessons any of us need to learn is how to look
> for help.
> The minute we have a question, we should LOOK for the answer instead of
> simply asking someone to provide the answer.
>
> Many times while looking for an answer to one question, I find the answers
> to questions
> I didn't know I had (until later!).
>
> As far as beginner learning, the same question has been asked several
> times in the past month in this very forum.
> Instead of asking someone else to look up the previous responses, you
> should try to look for yourself.
>
> Simply looking for "learn" in this forum should give you previous
> responses with links to sites specializing in teaching beginners.
>
>
> *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:* Shiva Prasad 
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, September 12, 2012 9:05:01 AM
> *Subject:* $$Excel-Macros$$ Excel vba
>
> hi team,
>
> my job profile is mis analyst level,
> have experience in excel depth formulas level but i need develops in excel
> VBA
> I want to learn excel vba ,
> could any one give help me
>
> --
>
>
>
>
>
> Regards,
> Shivaprasad K.
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With regards,

*MaNgEsH*

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Pro

Re: $$Excel-Macros$$ Excel vba

[Paul Schreiner]

I don't mean to be difficult, or unhelpful, or snotty, or seem to be any other 
bad description,
but this group is designed to help people that are having difficulty with 
VBA macros.
Not necessarily teach VBA from scratch.

I think one of the BIGGEST lessons any of us need to learn is how to look for 
help.
The minute we have a question, we should LOOK for the answer instead of
simply asking someone to provide the answer.

Many times while looking for an answer to one question, I find the answers to 
questions
I didn't know I had (until later!).

As far as beginner learning, the same question has been asked several times in 
the past month in this very forum.
Instead of asking someone else to look up the previous responses, you should 
try 
to look for yourself.

Simply looking for "learn" in this forum should give you previous responses 
with 
links to sites specializing in teaching beginners.

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: Shiva Prasad 
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 9:05:01 AM
Subject: $$Excel-Macros$$ Excel vba

hi team,

my job profile is mis analyst level,
have experience in excel depth formulas level but i need develops in excel VBA
I want to learn excel vba ,
could any one give help me 

-- 






Regards,
Shivaprasad K.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Excel vba

[Rajan_Verma]

 

You have already helped yourself to join this group,

With following discussion here , you can start learning macros by Recording
Macros , start recording little steps may be help for you.

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shiva Prasad
Sent: 12 September 2012 6:34
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel vba

 

hi team,

my job profile is mis analyst level,
have experience in excel depth formulas level but i need develops in excel
VBA
I want to learn excel vba ,
could any one give help me 

-- 

 

 

 

 

Regards,

Shivaprasad K.

 

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Excel vba

[Shiva Prasad]

hi team,

my job profile is mis analyst level,
have experience in excel depth formulas level but i need develops in excel
VBA
I want to learn excel vba ,
could any one give help me

-- 





Regards,
Shivaprasad K.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

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

[Sam Mathai Chacko]

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
Sheets(var).Delete
.DisplayAlerts = 1
End With

End Sub

Regards,
Sam Mathai Chacko

On Tue, Aug 14, 2012 at 8:02 PM, Rajan_Verma wrote:

> 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 for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Sam Mathai Chacko

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Excel VBA Challenge

[Rajan_Verma]

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 for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

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

[pesh]

This works great! Thank you!

On Sunday, August 5, 2012 9:09:06 AM UTC-4, Don Guillett wrote:
>
>   Or
>  
> Sub SplitStringSAS()
> Dim VarArr
> With Selection
>   VarArr = Split(.Value, "|")
> .Resize(1, UBound(VarArr)).Value = VarArr
> End With
> End Sub
>  
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>   
>  *From:* Rajan_Verma  
> *Sent:* Sunday, August 05, 2012 12:48 AM
> *To:* excel-macros@googlegroups.com 
> *Subject:* RE: $$Excel-Macros$$ Excel VBA Question: Splitting a 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 = Mid(StrString, 2, Len(StrString) - 2)*
>
> *VarArr = Split(StrString, "|")*
>
> *Range("A1").Resize(1, UBound(VarArr)).Value = VarArr*
>
> **
>
> *End Sub*
>
> ** 
>
> ** 
>
> ** 
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** 
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Alpesh Shah
> *Sent:* 05 August 2012 6:13
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ 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 time with VBA, but I cannot 
> seem to get it to succeed.
>
> Please help.
>
> Thank you.
> Alpesh
>
> -- 
> FORUM RULES (986+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>  
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>  
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>  
>  
> -- 
> FORUM RULES (986+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>  
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>  
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>  
>  
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

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

[dguillett1]

Or

Sub SplitStringSAS()
Dim VarArr
With Selection
  VarArr = Split(.Value, "|")
.Resize(1, UBound(VarArr)).Value = VarArr
End With
End Sub

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Rajan_Verma 
Sent: Sunday, August 05, 2012 12:48 AM
To: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ Excel VBA Question: Splitting a 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 = Mid(StrString, 2, Len(StrString) - 2)

VarArr = Split(StrString, "|")

Range("A1").Resize(1, UBound(VarArr)).Value = VarArr



End Sub

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Alpesh Shah
Sent: 05 August 2012 6:13
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ 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 time with VBA, but I cannot seem to 
get it to succeed.

Please help.

Thank you.
Alpesh

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
 
 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

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

[dguillett1]

I just recorded this TTC for data>text to columns>delimited>other=|

Sub Macro12()
'
' Macro12 Macro
' Macro recorded 8/5/2012 by Donald B. Guillett
'

'
Selection.TextToColumns Destination:=Range("J6"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=True, Other:=True, OtherChar:= _
"|", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 
1), Array(5, 1), _
Array(6, 1), Array(7, 1), Array(8, 1), Array(9, 1)), 
TrailingMinusNumbers:=True
End Sub

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Alpesh Shah 
Sent: Saturday, August 04, 2012 7:43 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a 
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 time with VBA, but I cannot seem to 
get it to succeed.

Please help.

Thank you.
Alpesh
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

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

[Rajan_Verma]

Hi

Use this :

 

Sub SplitString()

 

Dim StrString As String

Dim VarArr

StrString = "| ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|"

StrString = Mid(StrString, 2, Len(StrString) - 2)

VarArr = Split(StrString, "|")

Range("A1").Resize(1, UBound(VarArr)).Value = VarArr



End Sub

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Alpesh Shah
Sent: 05 August 2012 6:13
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ 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 time with VBA, but I cannot seem
to get it to succeed.

Please help.

Thank you.
Alpesh

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 
 

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Alpesh Shah]

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 time with VBA, but I cannot
seem to get it to succeed.

Please help.

Thank you.
Alpesh

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Rajan_Verma]

Use this :

 

Function CountThem(rngString As Range) As String



Dim VarArr

Dim ArrRes

Dim varWhattoFind

Dim lngCountAs Long



varWhattoFind = Array("Actor", "Businessman", "Athlete", "Dancer")

VarArr = Split(rngString.Value, ",")

   

For lngCount = LBound(varWhattoFind) To UBound(varWhattoFind)



CountThem = CountThem & varWhattoFind(lngCount) & "" &
UBound(Filter(VarArr, varWhattoFind(lngCount))) + 1 & vbCrLf

Next lngCount



End Function

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pesh
Sent: 29 July 2012 2:08
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel VBA: String manipulation and tally (Help
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 Trump (Businessman)"

I need the vba code to report out two things:

1. The number of actors, businessman, athletes, dancers
2. The items assigned to each person (e.g. Michael Jordan is a businessman
and athlete)

I have attached a sample sheet for greater clarity . I'm sure this is very
easy for you experts, and your help is greatly appreciated.

Thank you.
Alpesh 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 
 

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[pesh]

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 Trump (Businessman)"

I need the vba code to report out two things:

1. The number of actors, businessman, athletes, dancers
2. The items assigned to each person (e.g. Michael Jordan is a businessman 
and athlete)

I have attached a sample sheet for greater clarity . I'm sure this is very 
easy for you experts, and your help is greatly appreciated.

Thank you.
Alpesh

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




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

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

[dguillett1]

Use the special cells offering for this but if you wanted to find something 
else you could use data>filter>autofilter.
or to loop to delete start from the bottom up
sub delblanks()
for I =cells(rows.count,end(xlup).row to 2 step –1
if len(application.trim(cells(I, “a”)))<1 then rows(i).delete
next i

end sub

or more criteria (again filtering better)
sub delblanksA()
for I =cells(rows.count,end(xlup).row to 2 step –1
if len(application.trim(cells(I, “a”)))<1 and cells(I,”b”)=”something” then 
rows(i).delete
next i

end sub
or 



Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Tony O 
Sent: Wednesday, July 25, 2012 6:43 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

I am working on a spreadsheet with Excel 2007.
I have the vba code to delete a line:

Selection.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, but I am not 
getting it to work the way I want to:

dim rowchk as integer

for rowchk = 1 to 1000
if activecell.Arowchk ="" then Selection.Delete Shift:=xlUp
end if

Please advise.





-- 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
 
 

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Paul Schreiner]

A couple of observations:
-In your loop, you're never "activating" a cell, so ActiveCell never changes.

When you delete a row, the NEXT row becomes the CURRENT row.
That means that when you go from Row 1 to 1000,
if, in the first loop, row 2, column A is blank, 
then row 2 is deleted, and row 3 moves up.
the loop then moves to the NEW row 3.
That means that if rows 2 AND 3 were blank, then row 3 would've been skipped.

When deleting rows, you should move from the bottom up.

Like:

For R = 1000 to 1 step -1
  If (Cells(R,"A").Value = "") then cells(R,"A").entirerow.Delete Shift:=xlUp
Next R

if you're wanting to delete if column A AND B AND C are blank, use:

For R = 1000 To 1 Step -1
    If ((Cells(R, "A").Value = "") _
    And (Cells(R, "B").Value = "") _
    And (Cells(R, "C").Value = "") _
    ) Then Cells(R, "A").EntireRow.Delete Shift:=xlUp
Next R
 
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: Tony O 
To: excel-macros@googlegroups.com
Sent: Wed, July 25, 2012 7:46:33 PM
Subject: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

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, but I am not 
getting 
it to work the way I want to:

dim rowchk as integer

for rowchk = 1 to 1000
if activecell.Arowchk ="" then Selection.Delete Shift:=xlUp
end if

Please advise.





-- 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
 
--

To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[अनिल नारायण गवली]

Dear Tony,

U can use without macro
Just select the range and press ctl+G of press F5 function key .
Then click to blank cell and use Alt+E+D select the row and delete it

Regards,
Gawli anil

On Thu, Jul 26, 2012 at 8:42 AM, NOORAIN ANSARI wrote:

> Dear Tony,
>
> Please try it..
>
> *Sub DeleteBlank()*
> *On Error Resume Next
> ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
> On Error GoTo 0: On Error GoTo -1: Err.Clear*
> *End Sub*
>
>
> On Thu, Jul 26, 2012 at 5:13 AM, Tony O <> wrote:
>
>> I am working on a spreadsheet with 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, but I am not
>> getting it to work the way I want to:
>>
>> dim rowchk as integer
>>
>> for rowchk = 1 to 1000
>> if activecell.Arowchk ="" then Selection.Delete Shift:=xlUp
>> end if
>>
>> Please advise.
>>
>>
>>
>>
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.blogspot.com 
> http://accesssqclinic.blogspot.in/
>
>
>
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[NOORAIN ANSARI]

Dear Tony,

Please try it..

*Sub DeleteBlank()*
*On Error Resume Next
ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0: On Error GoTo -1: Err.Clear*
*End Sub*


On Thu, Jul 26, 2012 at 5:13 AM, Tony O  wrote:

> I am working on a spreadsheet with 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, but I am not
> getting it to work the way I want to:
>
> dim rowchk as integer
>
> for rowchk = 1 to 1000
> if activecell.Arowchk ="" then Selection.Delete Shift:=xlUp
> end if
>
> Please advise.
>
>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



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

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Tony O]

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, but I am not 
getting it to work the way I want to:

dim rowchk as integer

for rowchk = 1 to 1000
if activecell.Arowchk ="" then Selection.Delete Shift:=xlUp
end if

Please advise.





-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Mangesh Vimay]

Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
Rule # 05

On 7/2/12, harshita desu  wrote:
> Medha Information research Offering In House, Online and Corporate
> training on Excel VBA
>
> Course Highlights
>
> Fully handson Sessions.
>
> Realtime examples
>
> Interview/project support
>
> Indepth and exclusive coverage on each topic
>
> For More details,
>
> Contact us at +91 9945207350 or write us at i...@medhainfo.com
>
> Website: WWW.MEDHAINFO.COM
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com


-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[harshita desu]

Medha Information research Offering In House, Online and Corporate
training on Excel VBA

Course Highlights

Fully handson Sessions.

Realtime examples

Interview/project support

Indepth and exclusive coverage on each topic

For More details,

Contact us at +91 9945207350 or write us at i...@medhainfo.com

Website: WWW.MEDHAINFO.COM

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[charlyRoot]

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 other than manipulating recorded macros. What is the 
>> quickest way to learn from foundation up? Book? Some pay site? It takes to 
>> long to go through youtubes.
>>
>> I would like a info dense book that does not assume prior prior VBA 
>> knowledge but also assumes I know what a keyboard is.
>>
>>
>>
>>
>
>
> -- 
> *Sandeep Kumar Baranwal*
> Credit Risk Methodology & Wholesale Basel
> Gurgaon
> Mob:-08588802543
>
>
>  
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 other than manipulating recorded macros. What is the 
>> quickest way to learn from foundation up? Book? Some pay site? It takes to 
>> long to go through youtubes.
>>
>> I would like a info dense book that does not assume prior prior VBA 
>> knowledge but also assumes I know what a keyboard is.
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook. 
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to 
>>
>> To unsubscribe, send a blank email to 
>>
>
>
>
> -- 
> *Sandeep Kumar Baranwal*
> Credit Risk Methodology & Wholesale Basel
> Gurgaon
> Mob:-08588802543
>
>
>  

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Sandeep Kumar Baranwal]

Refer
 functionx.com/vbaexcel

this will help

Sandeep


On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot  wrote:

> I don't know VBA other than manipulating recorded macros. What is the
> quickest way to learn from foundation up? Book? Some pay site? It takes to
> long to go through youtubes.
>
> I would like a info dense book that does not assume prior prior VBA
> knowledge but also assumes I know what a keyboard is.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
*Sandeep Kumar Baranwal*
Credit Risk Methodology & Wholesale Basel
Gurgaon
Mob:-08588802543

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Excel VBA Book?

[charlyRoot]

I don't know VBA other than manipulating recorded macros. What is the quickest 
way to learn from foundation up? Book? Some pay site? It takes to long to go 
through youtubes. 

I would like a info dense book that does not assume prior prior VBA knowledge 
but also assumes I know what a keyboard is. 

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Abhishek Jain]

If a VBA project is password protected, you cannot step into / view the
code without knowing the password. That's the exact point of it.

Now you probably are experiencing an error with the code and are trying to
debug it. Well, the best way is to ask where you got it  or try to find a
similar working code.

HTP


On Tue, Mar 6, 2012 at 2:47 PM, PrIyAnKa  wrote:

> Dear Abhishek and Muneer
>
> What i need to do if i want to step in the macro after protecting it with
> password?
>
> As after password protection it only highlights the option  of run ,so how
> to step into the same
>
>
> On Tue, Mar 6, 2012 at 1:20 PM, Mohammed Muneer wrote:
>
>>  Dear Priyanka,
>>
>> ** **
>>
>> Have a look at the bmp file.
>>
>> ** **
>>
>> Step involved initially are : 1)  Alt+F11  2) then right click the
>> project explorer in this (VBA Project Protection) and proceed with the
>> following attachment.
>>
>> ** **
>>
>> Hope this what u need?
>>
>> ** **
>>
>> ** **
>>
>> Regards,
>>
>> 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 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, 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send em

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

[PrIyAnKa]

Dear Abhishek and Muneer

What i need to do if i want to step in the macro after protecting it with
password?

As after password protection it only highlights the option  of run ,so how
to step into the same

On Tue, Mar 6, 2012 at 1:20 PM, Mohammed Muneer  wrote:

>  Dear Priyanka,
>
> ** **
>
> Have a look at the bmp file.
>
> ** **
>
> Step involved initially are : 1)  Alt+F11  2) then right click the project
> explorer in this (VBA Project Protection) and proceed with the following
> attachment.
>
> ** **
>
> Hope this what u need?
>
> ** **
>
> ** **
>
> Regards,
>
> 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 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, 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Excel VBA Password protection

[PrIyAnKa]

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, 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[కిరణ్ కొత్తకోట]

Awesome! Thanks :)

On Wed, Jan 11, 2012 at 11:15 PM, NOORAIN ANSARI
wrote:

> FYI
>
>
> On Wed, Jan 11, 2012 at 11:04 PM, NOORAIN ANSARI  > wrote:
>
>> Dear Experts,
>>
>> Please use below link for excel-vba interview questions..
>>
>> http://www.coolinterview.com/type.asp?iType=220
>>
>> Kindly share with group if any one have other links or Excel-VBA
>> Interview questions..
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-Kiran

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Excel VBA interview questions

[NOORAIN ANSARI]

Dear Experts,

Please use below link for excel-vba interview questions..

http://www.coolinterview.com/type.asp?iType=220

Kindly share with group if any one have other links or Excel-VBA Interview
questions..

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[OpenExcel.com]

Hi,


Please check and bookmark this link for MS Excel, Access & VBA Jobs. 
http://jobs.openexcel.com  



*Best Regards*
 
 
*Photographer**, Odd Lens
Blogger, eXceLiTems.com
Traveler, MastWeekend.com
Developer, OpenExceL.com (Excel Add-in)*
Tel: (+91) -40-48-43 | (+91) 9968-615-632
www.OddLens.com  / 
www.eXceLiTems.com
 
 
Facebook
   
Twitter
   
LinkedIn
   
Flickr
   OddLens 
(FB)
   eXceLiTems  

 Open Excel 
IMPORTANT: The contents of this email and any attachments are confidential. 
They are intended for the named recipient(s) only. If you have received 
this email by mistake, please notify the sender immediately and do not 
disclose the contents to anyone or make copies thereof.
All views and opinions expressed in this email message are the personal 
opinions of the author and do not represent those of the company. No 
liability can be held for any damages, however caused, to any recipients of 
this message.


-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Divaker Pandey]

Hi Satish

Here is Divaker, you can contact to me on 9582060233.

Divaker pandey

On Mon, Oct 31, 2011 at 1:55 PM, satish
wrote:

> Dear Excel Gurus,
>
> I am free lance data analyst, I have set of excel templates to
> calculate the Savings and Overcharges. I would like to auto-maize the
> whole process using VBA and Macro. I would like to know the
> professional who can create the package ( Excel along with VBA  and
> Macro. Please leave your contact details along with
> Name
> Address
> Contact number
> Email Id etc.
> I will send you the full description of the project work along with
> Tender list. Please quote your fee & duration for developing  the
> project
> work.
> You can send you contact details in below email id.
> skanda...@hotmail.com
> Kind Regards
> SATISH KUMAR.
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Seba]

Hi guys,

thank you very much for your help.
You solved my problem and thank you for different posibilities from
which I can learn.

Best regards,

seba

On 10 nov., 18:21, Sam Mathai Chacko  wrote:
> Two options try
>
>     If Not IsEmpty(Range("A1")) Then
>         Range("B5").Value = 8
>     Else
>         Exit Sub
>     End If
>
> *OR*
>
>     If Len(Trim(Range("A1"))) Then
>         Range("B5").Value = 8
>     Else
>         Exit Sub
>     End If
>
> Regards
>
> Sam Mathai Chacko
>
>
>
>
>
>
>
>
>
> On Thu, Nov 10, 2011 at 10:13 PM, dguillett1  wrote:
> > you forgot RANGE but to make sure try
>
> > If len(application.trim(range("**A1")))<1 Then
>
> > Don Guillett
> > SalesAid Software
> > dguille...@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
>
> > 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
> > --**--**
>
> > I also tried
>
> > Sub testPogoja()
> > If IsEmpty("A1") = True Then
> > Exit Sub
> > Else
> > Range("B5").Value = 8
> > End If
> > End Sub
> > --**--**
> > 
>
> > and no luck.
> > What am I doing wrong?
>
> > regards
> > seba
>
> > --
> > FORUM RULES (934+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > --**--**
> > --**
> > To post to this group, send email to excel-macros@googlegroups.com
> > --
> > FORUM RULES (934+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > --**--**
> > --**
> > To post to this group, send email to excel-macros@googlegroups.com
>
> --
> Sam Mathai Chacko

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Sam Mathai Chacko]

Two options try

If Not IsEmpty(Range("A1")) Then
Range("B5").Value = 8
Else
Exit Sub
End If

*OR*

If Len(Trim(Range("A1"))) Then
Range("B5").Value = 8
Else
Exit Sub
End If

Regards

Sam Mathai Chacko

On Thu, Nov 10, 2011 at 10:13 PM, dguillett1  wrote:

> you forgot RANGE but to make sure try
>
> If len(application.trim(range("**A1")))<1 Then
>
>
> Don Guillett
> SalesAid Software
> dguille...@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
>
>
> 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
> --**--**
>
> I also tried
>
> Sub testPogoja()
> If IsEmpty("A1") = True Then
> Exit Sub
> Else
> Range("B5").Value = 8
> End If
> End Sub
> --**--**
> 
>
> and no luck.
> What am I doing wrong?
>
> regards
> seba
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --**--**
> --**
> To post to this group, send email to excel-macros@googlegroups.com
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --**--**
> --**
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Kaushal Kumar]

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 If IsEmpty(Range) code problem
> From: sebastjan.hri...@gmail.com
> To: excel-macros@googlegroups.com
> 
> 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
> 
> 
> I also tried
> 
> Sub testPogoja()
> If IsEmpty("A1") = True Then
> Exit Sub
> Else
> Range("B5").Value = 8
> End If
> End Sub
> 
> 
> and no luck.
> What am I doing wrong?
> 
> regards
> seba
> 
> -- 
> FORUM RULES (934+ members already BANNED for violation)
> 
> 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
> Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
> 
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
> 
> --
> To post to this group, send email to excel-macros@googlegroups.com
  

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[dguillett1]

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


I also tried

Sub testPogoja()
If IsEmpty("A1") = True Then
Exit Sub
Else
Range("B5").Value = 8
End If
End Sub


and no luck.
What am I doing wrong?

regards
seba

--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[mrinal saha]

try this...

If range("A1").value = " " Then
Exit Sub
Else
Range("B5").Value = 8
End If
End Sub

regards,
Mrinal

On Thu, Nov 10, 2011 at 9:18 PM, Seba  wrote:

> Hi,
>
> I am testing this fairly simple code for some other purposes but I
> always get the value 8 regardless of value in A1:
>
> 
> Sub testPogoja()
> If IsEmpty("A1") Then
> Exit Sub
> Else
> Range("B5").Value = 8
> End If
> End Sub
> 
>
> I also tried
>
> Sub testPogoja()
> If IsEmpty("A1") = True Then
> Exit Sub
> Else
> Range("B5").Value = 8
> End If
> End Sub
> 
>
> and no luck.
> What am I doing wrong?
>
> regards
> seba
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Seba]

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


I also tried

Sub testPogoja()
If IsEmpty("A1") = True Then
Exit Sub
Else
Range("B5").Value = 8
End If
End Sub


and no luck.
What am I doing wrong?

regards
seba

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[satish]

Dear Excel Gurus,

I am free lance data analyst, I have set of excel templates to
calculate the Savings and Overcharges. I would like to auto-maize the
whole process using VBA and Macro. I would like to know the
professional who can create the package ( Excel along with VBA  and
Macro. Please leave your contact details along with
Name
Address
Contact number
Email Id etc.
I will send you the full description of the project work along with
Tender list. Please quote your fee & duration for developing  the
project
work.
You can send you contact details in below email id.
skanda...@hotmail.com
Kind Regards
SATISH KUMAR.

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[vinod nagwanshi]

**

* *
*

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:

Availability:

Rate:

_



A global investment bank located in Midtown Manhattan is in need of a
excel/VBA programmer to work within their market risk team



Length: 6 Months+
Location: Midtown Manhattan


Job Description

- Design/implement data model and risk reporting tools for limit monitoring,
back testing, capital calculation, stress testing, capital calculation, Risk
identification, capture and assessment process

- Participate in analysis and testing of Global strategic risk calculation
and aggregation engines and components;

- Improve current modules with more standardization, robustness and
efficiency. Potentially apply the tools for wider usage across sites and
regions

- Work with users on software support, testing and maintenance issues

- Write functional spec, technical design/implementation and user guide
papers


Skills / Qualifications:

- Ideally 3-5 years of experience in financial services industry.

- Expert in SQL/Sybase; Experience in data model design

- Solid Excel/VBA programming skills and experience

- Knowledge of market risk measures and experience in market risk systems is
preferred

- Familiar with Java/Web programming is a plus

- Excellent verbal and written skills are a must. Must be able to explain
complex and/or technical matters clearly, accurately and simply. Frequent
interactions with market risk and credit risk managers, product controllers,
and senior IT developers. Timely feedback and escalation to line manager.

- Think out-of-the-box and be creative in software solutions with the target
and time-constraint in perspective

- Organized, detail-oriented and self-motivated quick learner and starter.
Ability to work in a team and develop & maintain relationships.

- Proactive and dynamic, be able to work on multiple projects simultaneously
and address ad-hoc requirements in an open, accurate and timely manner

- Exposure to financial products and risks are preferred; Experience in risk
reporting and design is a plus

- Excellent educational background in computational or quantitative field
(Computer Science, Math, Physics, Financial Engineering) is preferable.



Thanks & Regards



Vinod



ADDON Technologies, Inc.

Direct: 734-956-4737 Ext - 163

Fax: 734-418-2603

Mail ID:  vi...@addonusa.com

IM:vinod.addontech

URL: www.addonusa.com



[image: cid:image001.png@01CC5CA0.7061C480]

Note: We at Addon Technologies respect your On-line Privacy. Under
Bills.1618, Title III passed by the 105th U.S. Congress this mail cannot be
considered spam as long as we include contact information and a remove link
for removal from our mailing list, so we do not believe this email is
unsolicited. If you do not wish to receive our e-mails and/or lists, click
on the link below and press SEND:
mailto:jos...@addonusa.com?subject=Remove_me.Pleasereply
from the exact address to which this was originally mailed to or
provides the address (es) to be removed. Any inconvenience caused is
regretted.












*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Excel VBA/ Access

[ja...@macstop.co.uk]

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 Access it works fine - asks me for the 2 parameters then
updates the table accordingly.

However, I am trying to run it from Excel VBA. At first I thought the
issue was the parameters, so I created another update query which
takes 0 parameters. The continual error I get is 'Operation must use
an updateable query'.

It goes without saying that I can connect to the database, and I can
run normal Select statements - anyone got any ideas? Code below:
(obviously the execute line is the one that gives the error).

Function RunUpdateQuery(objConn As ADODB.Connection)
Dim objCommand As ADODB.Command

Set objCommand = New ADODB.Command

With objCommand
 .ActiveConnection = objConn
 .CommandType = adCmdStoredProc
 .CommandText = "qryTest"
 .Execute
 End With


End Function


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel