On Tuesday, November 28, 2017 at 8:08:59 PM UTC+5:30, John C wrote:
> I am looking for a Macro to export the contents of every table in a Word
> document(s) and move this content to Excel. Along with pulling the contents
> of the tables however, I would like the titles of each of these tables to
On Tue, 3/28/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Tuesday, March 28, 201
On Tue, 3/28/17, 'Martin George' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Tuesday, March 28, 201
On Tue, 3/28/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Tuesday, March 28, 201
On Tue, 3/28/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Tuesday, March 28, 201
On Mon, 3/27/17, martinez.david533 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Monday, March 27, 2017, 9:31 PM
On Mon, 3/27/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Monday, March 27, 201
On Mon, 3/27/17, storeythomas725 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Monday, March 27, 2017, 4:17 PM
On Mon, 3/27/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Monday, March 27, 2017
On Mon, 3/27/17, Swapnil Palande wrote:
Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
To: excel-macros@googlegroups.com
Date: Monday, March 27, 2017, 8:25 AM
Hi,
You want do develop kind of WorkForce
Hi,
You want do develop kind of WorkForce Management Application. Will
recommend not to do it in Excel. For small scale use MS Access.
It is complex application. You have to contact software developer to
develop it.
Regards,
Swapnil Suresh Palande.
On Sat, Mar 25, 2017 at 10:09 AM, Dollar Chande
Hello Paul / Ayush,
Can you guys help me or guide me on this one...
Best regards,
Dollar Chande
On Friday, March 10, 2017 at 4:28:34 PM UTC+5:30, Dollar Chande wrote:
>
> Hi All,
>
> I am a novice at macro (very little knowledge) and would seek your kind
> assistance on my attached sheet. I am
Hi Paul
Sir, I'm waiting for you good 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 titl
Hi Rashid,
I have time entry at given in the attached document.
1) I want first in and last out for a days – All the associates
2) I want the know how many hours they had spent inside the bay (you
have to look for each in and out)
3) If there are any discrepancy on the IN an
Oh Sorry about that the password is "Metlab" with capital M
On Monday, May 16, 2016 at 3:34:28 AM UTC-5, Mandeep Baluja wrote:
>
> please share your sheet without password after pasting this code so that i
> can check.
>
>
>
>
> On Monday, May 16, 2016 at 12:45:30 PM UTC+5:30, Ashkan Razania wrot
please share your sheet without password after pasting this code so that i
can check.
On Monday, May 16, 2016 at 12:45:30 PM UTC+5:30, Ashkan Razania wrote:
>
> It didn't work. same problem
>
> On Monday, May 16, 2016 at 1:17:15 AM UTC-5, Mandeep Baluja wrote:
>>
>> Autofill works in scenario
It didn't work. same problem
On Monday, May 16, 2016 at 1:17:15 AM UTC-5, Mandeep Baluja wrote:
>
> Autofill works in scenario if data you want to paste it down similarly.
> What you're doing is selecting two columns and pasting it more than 2
> columns that's not possible bro.If you wish to pas
Autofill works in scenario if data you want to paste it down similarly.
What you're doing is selecting two columns and pasting it more than 2
columns that's not possible bro.If you wish to paste your data
automatically you can do this by selecting the appropriate no of columns.
Private Sub Work
IT IS WORKING THANK YOU VERY MUCH FOR YOUR 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
Check this out is this you're looking for !! Regards, Mandeep baluja
Sub GetDetails_of_Sheet()
Dim ws As Worksheet
Dim i As Long: i = 2
On Error Resume Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each sht In ActiveWorkbook.Sheets
If sht.Name = "Info"
Run this code and let me know
Regards,
Mandeep baluja
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rownum As Long:
Dim colnum As Long:
Dim Temp As Long: Temp = 4
Dim lastentry As Long
With ActiveSheet
For colnum = 2 To 6
If colnum = 3 Or colnum = 6 Then
laste
hi,
shared only example format data like that
On Saturday, November 21, 2015 at 9:30:37 PM UTC+5:30, pramodb35 wrote:
>
> Akash.
> Kinldy Share Excel File
>
> On Sat, Nov 21, 2015 at 9:01 PM, Akash Singh > wrote:
> >> Hi,
> >
> > Can anyone guide who write a code in VBA in excel to find the
Akash.
Kinldy Share Excel File
On Sat, Nov 21, 2015 at 9:01 PM, Akash Singh wrote:
>> Hi,
>
> Can anyone guide who write a code in VBA in excel to find the employee
> attendance record or check whether employee working more than 6 day in a
> week
>
> akash
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(
>
> Hi,
Can anyone guide who write a code in VBA in excel to find the employee
attendance record or check whether employee working more than 6 day in a
week
akash
--
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 pag
Can you give more details, An example. I don't get you
On Friday, August 7, 2015 at 4:46:37 PM UTC, Mike B wrote:
>
> I would appreciate any help with creating a macro to email individual PDF
> documents to each client's email that is chosen from a list matched to the
> client's PDF to send as a
Anyone ?
On Friday, 19 June 2015 17:56:51 UTC-4, Bill Q wrote:
>
> Hi Guys,
>
> Attached is a spreadsheet and macro that does some web-scraping of
> individual web pages..
>
> I need two modifications on this macro that I do not know how to do as I
> have little experience.
>
> * Currently
file is locked and even it seems to me that there is data validation
control present in those cells.
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/82522
Do you want to copy the results again and again after the result,and do not
want to replace the existing result..
On Thursday, April 9, 2015 at 6:37:11 AM UTC+5:30, modi89 wrote:
>
> Group, please replace 'house1' with 'Red apples' and 'house2' with 'Green
> apples'
>
> On Wednesday, April 8, 20
Group, please replace 'house1' with 'Red apples' and 'house2' with 'Green
apples'
On Wednesday, April 8, 2015 at 8:56:36 PM UTC-4, modi89 wrote:
>
>
>
> Hello Group,
> I need help. when this code runs , The result goes to Sheet2 as intended.
> however it overwrite A, B, C E, G. of Sheet2 column
gt;
>> +
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Tue, Dec 23, 2014 at 9:18 PM, C.G.Kumar
>> wrote:
>>
>>> May someone please look and advise macro to solve the puzzle.
>>>
>>> Thanks and Rega
;
>> May someone please look and advise macro to solve the puzzle.
>>
>> Thanks and Regards,
>> C.G.Kumar
>>
>> -- Forwarded message -----
>> From: C.G.Kumar
>> Date: Mon Dec 22 2014 at 7:09:55 PM
>> Subject: Re: $$Excel-Macros$$ Re:
t; C.G.Kumar
>
> -- Forwarded message -
> From: C.G.Kumar
> Date: Mon Dec 22 2014 at 7:09:55 PM
> Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory
> To: excel-macros@googlegroups.com
>
>
> Macro is not providing desired result.
>
>
May someone please look and advise macro to solve the puzzle.
Thanks and Regards,
C.G.Kumar
-- Forwarded message -
From: C.G.Kumar
Date: Mon Dec 22 2014 at 7:09:55 PM
Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory
To: excel-macros@googlegroups.com
Macro is not
Macro is not providing desired result.
Attached worksheet looks at total Purchase of Specific qty and provides
ageing.
But the need is to have ageing (& Value) of balance stock only.
This mean in Solved worksheet of yours, total qty left in Cell "B5" is to
be keyed in Manually and macro is expec
Try this File hope it reach you expected Result.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
>
> Hi,
>
> I have purchase data in a sprea
Hi,
At year end, we need to determine age of Items left in Inventory.
For example, we are left with 2 pieces of Material Part No.357000 at year
end, and need to determine age of these two quantities of material based on
purchase.
We go to purchase data and find most recent purchase.
Recent Pur
Please see attached file.
Let me know if any additional info is required.
On Mon, Dec 22, 2014 at 3:18 PM, Anil Gawli wrote:
> Dear Rockernayal,
>
> Pls share a workbook with us.
>
> Regards,
> Gawli Anil
>
> On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja
> wrote:
> > Please explain your Qu
Dear Rockernayal,
Pls share a workbook with us.
Regards,
Gawli Anil
On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja wrote:
> Please explain your Query Again I an unable to understand it . Aeging can be
> count but on what criteria whether on particular order no, material no ,
> document no. whe
Please explain your Query Again I an unable to understand it . Aeging can
be count but on what criteria whether on particular order no, material no ,
document no. where is availble qty column.
On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
>
> Hi,
>
> I have purchase data in a
Hey Muneera,
One last change has been done in this code where I mentioned * '*Change
done here', basically it was not taking a Slash to get inside a directory.
Now it's is working fine.
Sub XLS_to_CSV()
Dim wb As Workbook
Dim SourcePath As String
Dim strFile As String, strDir As String
Dim
Replace source line with this
Set j = Application.FileDialog(msoFileDialogFolderPicker)
j.Show
SourcePath = j.SelectedItems(1)
On Wednesday, November 26, 2014 4:40:03 PM UTC+5:30, Muneera Shabana wrote:
>
> Good Morning,
>
> Hope you are having a great day!
>
> *Objecti
Thanks Mandeep
But I dont to define the source path, rather browse and open the folder for
converting the files.
please help!
On Wednesday, 26 November 2014 12:57:30 UTC+1, Mandeep Baluja wrote:
> Sub XLS_to_CSV()
>
> Dim wb As Workbook
> Dim strFile As String, strDir As String
>
> SourcePat
Sub XLS_to_CSV()
Dim wb As Workbook
Dim strFile As String, strDir As String
SourcePath = "C:\Users\pc\Desktop\45.November.2014\"
strFile = Dir(SourcePath & "*.xlsx")
Do While strFile <> ""
Set wb = Workbooks.Open(Filename:=SourcePath & strFile, Local:=True)
newpath = "C:\Users
Sub CSV_to_XLS()
Dim wb As Workbook
Dim strFile As String, strDir As String
SourcePath = "C:\Users\pc\Desktop\45.November.2014\"
strFile = Dir(SourcePath & "*.xlsx")
Do While strFile <> ""
Set wb = Workbooks.Open(Filename:=SourcePath & strFile, Local:=True)
newpath = "C:\Users
Thanks Mandeep,
Thank you so much..Lax
On Monday, November 24, 2014 3:18:45 PM UTC+5:30, Mandeep Baluja wrote:
>
> Set the columns for emails. it will take email one by one and send the
> mail from outlook automatically without showing any notification you can
> also use msgbox function to chec
Set the columns for emails. it will take email one by one and send the mail
from outlook automatically without showing any notification you can also
use msgbox function to check the list of of users one by one. here the
email column is For Each cell In Range("AJ2:AJ300")
Regards,
Mandeep Baluja
Thanks Mandeep,
I have couple of questions here.
With regards to the e-mail it sends, who will receive the email when I run
the macro?
Will this open up an email and I populate the email address?
Laxman
On Friday, November 21, 2014 3:48:00 PM UTC+5:30, Mandeep Baluja wrote:
>
> Sub Mail_Outl
Sub Mail_Outlook_With_Signature_Html_1()
' Working in Office 2000-2013
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim cell As Range
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
strbody = "Hello"
For Each c
Dear Anil ,
Thanks for the intrest.Please find the attachement present in the first
post of this thred.
Lax
On Friday, November 21, 2014 9:40:10 AM UTC+5:30, अनिल नारायण गवली wrote:
> Dear Mr. Ladmanan,
>
> Pls do send an attachment.
>
> Warm Regards,
> Gawli Anil
>
> On Thu, Nov 20, 2
Dear Mr. Ladmanan,
Pls do send an attachment.
Warm Regards,
Gawli Anil
On Thu, Nov 20, 2014 at 11:53 PM, Laxmanan M wrote:
> Am not gud at macros and am in learning phase.But i have been assigned to
> complete this task.So am roaming around the web.Please paul help me to be
> done this macro co
Am not gud at macros and am in learning phase.But i have been assigned to
complete this task.So am roaming around the web.Please paul help me to be
done this macro code
lax
On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote:
>
> hi All,
>
> Please see the attached file as req
people you can,
As long as ever you can.” - John Wesley
-
>
> From: Laxmanan M
>To: excel-macros@googlegroups.com
>Sent: Thursday, November 20, 2014 12:37 PM
>Subject: $$Excel-Macros$$ Re: Macro for send mail
&g
Am using Normal MS Outlook application for sending mails..
Thanks,
Lax
On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote:
>
> hi All,
>
> Please see the attached file as requested. What the outcomes I’m after are
> requested below.
>
>
>
> When column AJ (Name of successful
Hi
It uses VBA dictionary object, and good feature of it is that it does nit
add duplicated record in it.!!
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 15, 2014 at 2:23 PM, Mandeep Baluja
wrote:
>
> May I know how duplicates are removing ??
May I know how duplicates are removing ?? as you have not wrote any command
but still duplicates removed in this code. Vabz.. How ?
Thanks in advance
Mandeep
Sub GetUniques()
Dim d As Object, c As Variant, i As Long, lr As Long
Set d = CreateObject("Scripting.Dictionary")
lr = Cells(Rows.Coun
Thanks Bro!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Sep 20, 2014 at 10:47 PM, Ashish Kumar
wrote:
> Vaibhav Bhai, It's superb and unique creation.
>
> --
> 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)
Vaibhav Bhai, It's superb and unique creation.
--
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 t
Cheers!!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Sep 20, 2014 at 9:28 PM, Bill Q wrote:
> Perfect... Many thanks Vabz !
>
>
> On Monday, September 1, 2014 1:56:01 PM UTC-4, Bill Q wrote:
>>
>> Hi,
>>
>> PSA.
>>
>> I am looking for two things to be mod
Perfect... Many thanks Vabz !
On Monday, September 1, 2014 1:56:01 PM UTC-4, Bill Q wrote:
>
> Hi,
>
> PSA.
>
> I am looking for two things to be modified with this macro:
>
> 1. A timer (in seconds) when it gets into the website and extracts
> (retrieves) the line information that will allow it
Not working properly. Once spreadsheet is opened, the msg box shows up. 20,
30, 60 seconds pass... nothing. If I press ok I will run through it once
then stay there once again with the msg box showing until pressed again.
On Monday, September 1, 2014 1:56:01 PM UTC-4, Bill Q wrote:
>
> Hi,
>
>
Unfortunately, I am getting the following error when pressing the "strat"
button in the spreadhseet:
"Compile error: Duplicate declaration of current scope"
It highlight "wshShell As Object" as the problem.
I tried it a few times.
When I run the running "macro1" directly - it does nothing.
The third break is not needed. The following highlighted in yellow is where
I would like the 2 breaks
Sub Button1_Click()
Dim i As Long, j As Long, k As Long, s As String
i = 1
j = 1
Do
s = Cells(i, 4).Value
If s = "" Then Exit Do
Worksheets("DATA").Select
Cells(j, 1) = Worksheets("U
HI
can you highlight in your code where you want break..
CHeers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Sep 15, 2014 at 1:25 AM, Bill Q wrote:
> I unfortunately cannot get it to work. Would it be possible for you to
> modify the macro and attach ?
I unfortunately cannot get it to work. Would it be possible for you to
modify the macro and attach ?
On Monday, 1 September 2014 13:56:01 UTC-4, Bill Q wrote:
>
> Hi,
>
> PSA.
>
> I am looking for two things to be modified with this macro:
>
> 1. A timer (in seconds) when it gets into the websi
Dear Team,
Please help to solve for excel macro.
In simple words, want to validate the data (Sheet A) with another sheet
(Sheet B), and if it is matched need to copy from sheet and paste into
another sheet (Result)
What to match:-
1.Number
2.Order Number
3.Received quan
*Everyone that needs to copy certain range of cells across numerous
workbooks and summarize them into a master sheet can use the shared VBA
code by Ashish. Great job, great forum. This is a code that saves more than
2 hours of manual work. VBA rules! *
*Best*
*D*
On Wednesday, April 16,
Dear Ashish,
I just made some tests and it works perfectly and does exactly what I need
it to, thanks so much man and God bless you! I wish one day I could write
VBA code just like you.
On Wednesday, April 16, 2014 9:52:01 PM UTC+3, Dragomir Zhelev wrote:
>
> Dear Excel and VBA lovers,
>
> Thi
Dear Ashish,
Thank you so much for your code, for the effort and time dedicated.I am
learning so your answer is much appreciated. I was quite busy recently and
still had no the chance to test it. I will do it tonight. As my knowledge
in VBA is pretty scarce at the moment and I am just in the mi
Sub merge()
Dim fld As Object, fil As Object, fso As Object, fldpath
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Choose the folder"
.Show
End With
On Error Resume Next
fldpath =
Application.FileDialog(msoFileDialogFolderPicker).SelectedItems
Hello, what I propose will involve Word (or any other word processor)
besides excel but will work pretty fast:
Copy the column with the data to Word, paste it as unformatted text.
Run a replacement searching for commas and replacing them with ^p for
paragraph.
Copy the data to excel and it s
Thank you so much It works. I made some changes to the loops to locate
the data exactly where I wanted.
Thank you again.
On Tuesday, March 25, 2014 5:41:34 PM UTC-4, Rafael DeLeon wrote:
>
>
> Hello all,
>
> I have a SQL Server Database with a store procedure that I would like to
> displa
Em domingo, 5 de janeiro de 2014 04h45min51s UTC-2, Milin Sulakhi escreveu:
>
> Dear All,
>
> I cannot write macros hence need your help on it . This Macro will achieve
> what I have mentioned below.
>
> 1. There is a range which I will select in excel.
> 2. Run Macro
> 3. Number format will ch
Hi,
Looking to have code in attached modified slightly to :
A. Only function between Monday and Friday.
B. To work in a loop. IE: It's activated at a certain time to start on
Monday and goes off at a certain time on Monday - THEN starts again at the
same time on Tuesday and goes off at the s
Dear Experts thanks alot
Hi *De Premor / Enrique Martin**
**
*thanks for giving this macro
this would be save my time alot and alot
thanks
On Tuesday, 17 September 2013 01:46:47 UTC+5:30, renuka chari wrote:
>
> Dear experts.
>
>
> please solve my query its very very urgent
>
> macro for requ
El lunes, 2 de septiembre de 2013 02:09:32 UTC-5, prkhan56 escribió:
>
> Hello All,
>
>
>
> You can use =COUNT.IF($B$9:$G$66,$A70)
>
--
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.
see if it helps
On Wed, Aug 7, 2013 at 4:33 PM, wrote:
>
>
> On Thursday, June 27, 2013 6:30:36 PM UTC+5:30, vikas khen wrote:
>>
>>
>> Dear All,
>>
>>
>> Please find the excel sheet. I need macro for the same
>>
>>
>>
>> Regards
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
On Thursday, June 27, 2013 6:30:36 PM UTC+5:30, vikas khen wrote:
>
>
> Dear All,
>
>
> Please find the excel sheet. I need macro for the same
>
>
>
> 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 Faceboo
plz experts..spare some time on my problem.
looking forward for your help.
On Friday, July 5, 2013 5:25:27 PM UTC+5:30, SG wrote:
> hi Experts,
>
> I'm in a great problem as i'm beginner in macros.I have created a template
> in which the data would be extracted on basis on 3 criterias.However,
HI all,
Is it possible to do the attached in Vba / Macro.
Any help would be appreciated
Dii
--
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
Hi Kaushik,
Try this..!!!
Option Explicit
Private Sub CommandButton1_Click()
On Error Resume Next
Dim fso As FileSystemObject
Dim fld As Folder
Dim fil As File
Dim wkb As Workbook
Dim akb As Workbook
Dim i As Long
Dim fldpath As String
Application.FileDialog(msoFileDialogFolderPicker).Titl
You upload 1 Workbook, which contains 20 Worksheets with Data and Worksheets
requirements.
2013/6/1 Bv Dileep
>
> On Sunday, May 26, 2013 8:50:22 PM UTC-5, Bv Dileep wrote:
>>
>> Hello,
>>
>> ** **
>>
>> Please find attached the sheet.
>>
>> ** **
>>
>> Macro Requirement : I will receive
On Sunday, May 26, 2013 8:50:22 PM UTC-5, Bv Dileep wrote:
>
> Hello,
>
> ** **
>
> Please find attached the sheet.
>
> ** **
>
> Macro Requirement : I will receive the data for 20 associates in my team
> in a separate sheets (20 Sheets) in the attached format. Now I want a macro
> whic
Thank you one and all for your help; Really awesome
On Sunday, May 26, 2013 8:50:22 PM UTC-5, Bv Dileep wrote:
> Hello,
>
> ** **
>
> Please find attached the sheet.
>
> ** **
>
> Macro Requirement : I will receive the data for 20 associates in my team
> in a separate sheets (20 Sheets
Thanks for the below link
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Lalit Mohan Pandey
Sent: 03 April 2013 05:58
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Macro-with example file
You can go through below links:
http
You can go through below links:
http://www.excel-vba-easy.com/
http://www.excel-vba.com/
On Wednesday, 3 April 2013 09:56:27 UTC+5:30, prafull jadhav wrote:
>
> Dear All,
>
> Very Good Morning ,
>
> I am very familiar with excel ..but I have never use Macro in my work .
>
> I want to learn Macro
Thanks Boss very helpful
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Shekhar
Sender: excel-macros@googlegroups.com
Date: Wed, 20 Mar 2013 05:29:03
To:
Reply-To: excel-macros@googlegroups.com
Cc: excel-macros
Subject: $$Excel-Macros$$ Re: Macro to be
Hi Hilary,
Replace ThisWorkbook.Sheets("Template") with Activesheet in procedure
called selectResults. I believe you are good to go... :)
One more thing you may need to consider:
If you are adding a sheet which is already exist in the workbook, the code
produces an error. To avoid this you can
Please Use This It may help You.
Sub test()
Dim rngData As Range
Dim intCol As Integer
Dim intRow As Integer
Dim strCol As String
With ThisWorkbook.Worksheets("Sheet1")
Set rngData = .Range("A1").CurrentRegion
intRow = rngData.Rows
Hi Shekhar,
Thanks for your support.
File name should be like "Account Tracker tab name".
Regards,
Santhosh
On Fri, Feb 1, 2013 at 11:57 PM, Shekhar wrote:
> Hi Santhosh,
>
> Please find attached workbook and let me know if it works.
>
>
> Thanks and regards,
> Shekhar
>
> On Friday, 1 February
Thank you Shekhar.
Macro works well.
2013/2/2, Shekhar :
> Hi Santhosh,
>
> Please find attached workbook and let me know if it works.
>
>
> Thanks and regards,
> Shekhar
>
> On Friday, 1 February 2013 23:14:56 UTC+5:30, mks...@gmail.com wrote:
>>
>> Hi Friends,
>>
>> Need a macros to split each s
Hi Santhosh,
Please find attached workbook and let me know if it works.
Thanks and regards,
Shekhar
On Friday, 1 February 2013 23:14:56 UTC+5:30, mks...@gmail.com wrote:
>
> Hi Friends,
>
> Need a macros to split each spreadsheet into a different workbook and save
> as the tab name.
>
> Fo
Another way that can help you
Sub Statistics_sheetname()
Dim i As Integer
For i = 1 To ActiveWorkbook.Sheets.Count
ActiveSheet.Range("a" & i).Value = Sheets(i).Name
Range("a" & i).Select
Next i
End Sub
2013/1/30, Prince :
> Hi Amir,
> hope this can be help full for you.
>
> Sub test()
> Dim
Hi Amir,
hope this can be help full for you.
Sub test()
Dim wks As Worksheet
Dim introw As Integer
introw = 1
For Each wks In ThisWorkbook.Worksheets
Sheet1.Cells(introw, 1).Value = wks.Name
introw = introw + 1
Next
End Sub
regards
Prince
On Wednesday,
Hi Vignesh,
Please find attached
regards
prince
On Saturday, January 12, 2013 11:24:41 PM UTC+5:30, Vignesh S R wrote:
>
> hi All,
>
> Need your help guys.
>
> Description
> Master excel sheet contains many records with different categories, we
> have multiple excel sheet for each categories. N
operties visible and select visible
>>>
>>> Regards,
>>> Lalit Mohan
>>> Sent from BlackBerry® on Airtel
>>> --
>>> *From: *prkhan56
>>> *Sender: *excel-...@googlegroups.com
>>> *Date: *Thu, 3 Jan 2013 02:
rkhan56
>> *Sender: * excel-...@googlegroups.com
>> *Date: *Thu, 3 Jan 2013 02:31:17 -0800 (PST)
>> *To: *
>> *ReplyTo: * excel-...@googlegroups.com
>> *Subject: *$$Excel-Macros$$ Re: Macro to create attendance Sheet for
>> each Employee
>>
>> Hello Lalit
:31:17 -0800 (PST)
> *To: *>
> *ReplyTo: * excel-...@googlegroups.com
> *Subject: *$$Excel-Macros$$ Re: Macro to create attendance Sheet for each
> Employee
>
> Hello Lalit
> Thanks for your response.
> There is no sheet *Sample* in the file you sent me.
> However
Date: Thu, 3 Jan 2013 02:31:17
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee
Hello Lalit
Thanks for your response.
There is no sheet *Sample* in the file you sent me.
However, can you also please the amend the code to
Hello Lalit
Thanks for your response.
There is no sheet *Sample* in the file you sent me.
However, can you also please the amend the code to take
Col A - Date/Time
Col B - Name
Your code looks for name in Col A and Date/Time and Col B
Thanks a lot once again for your time and help
Regards
Rashid
Hi Rashid,
The file which i have sent you contains a sheet named *Sample *so if you
have copied only the code then it will give you an error because the sheet
is not available. Please check the same.
Reagrds,
Lalit Mohan
On Thursday, 3 January 2013 00:57:11 UTC+5:30, prkhan56 wrote:
>
> Hello
1 - 100 of 289 matches
Mail list logo