Hi Team,
I'm facing challenges to automate attached worksheet. I've to match total
of debit and credit amount to reconcile the data, match could be possible
in single and multiple transaction entries. Please provide your valuable
inputs after you go through to the data sheet.
--
Regards,
Deepa
Hi Ayush,
Rather than banning all job posts you can ban repetitive job posts, because
these job posts really help the group members to find good openings.
Regards
Deepak
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
I don't know much about VSTO, but you can read articles on Wikipedia and
MSDN..
http://en.wikipedia.org/wiki/Visual_Studio_Tools_for_Office
As we all know that there're many office applications (specially
spreadsheets, text editor & presentations) available in the market today.
To retain the No#
Okay Tom..I thought in a different way... Code provided by Sam will work...
Regards
Deepak
On Sun, Nov 27, 2011 at 2:35 AM, Sam Mathai Chacko wrote:
> Tom,
>
> Use this example
>
> Sub NameFile()
> Name "C:\Text.txt" As "C:\Text"
> End Sub
>
> Regards,
>
> Sam
>
>
> On Wed, Nov 23, 2011 at 10:51
bottom line of table is not
> reflected .
>
> Request you to please look in small chnages & revert
>
> Thnaks in Advance..
>
> On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh <
> deepaktheind...@gmail.com> wrote:
>
>> Here it is I developed this code
Can you provide the format of your data.. Also want to know do you outlook
to send emails..??
On Sun, Nov 13, 2011 at 10:30 PM, maulik desai wrote:
> Hi Team,
>
> I am having 1 excel sheet in that i have to prepare Chennel wise detail
> report on a every week & i have to send that information to
Thanks Bro... It worked... :-) :-)
On Fri, Oct 21, 2011 at 1:47 AM, Sam Mathai Chacko wrote:
> Not tested. When you create the OutLook object, try using
> CreateObject("Outlook.Application.12") for 2007, or .11 for 2003 (assuming
> you have outlook in 2003)
>
> Regards,
> Sam
>
>
> On Thu, Oct 20
Where is the code.??
On Mon, Sep 26, 2011 at 10:07 AM, aju chacko wrote:
> Dear friends,
> I have created the following code to to trap
> "windowactivate" event and execute the code from personal macro
> workbook when the activate sheet name is "sap vs phy".But it works
Sure. :-)
On Sun, Sep 25, 2011 at 9:35 PM, vickey wrote:
> Yes, great its working can I raise more query/issues in case I face
> during the operation...
>
>
>
> --
>
> --
> Some important links for ex
Yeah... B'coz one year back I'd to prepare a similar kind of template.. with
BiomatriX data... :-) :-)
On Sun, Sep 25, 2011 at 9:21 PM, dguillett1 wrote:
> It appears that you properly understood the question.
>
> *From:* Deepak Pal Singh
> *Sent:* Sunday, September 2
Try this one... :-)
On Sun, Sep 25, 2011 at 8:36 PM, dguillett1 wrote:
> I sent a solution to what I thought was your request. Now, you have an
> entirely different question. Please give examples and clear logic on how to
> get the result.
>
> *From:* vickey
> *Sent:* Sunday, September 25,
Just ask your vendor to publish data in your required format, he'll do it
because your organization is paying him monthly maintenance...
On Sun, Sep 25, 2011 at 4:03 PM, vickey wrote:
> can I get values (time) of two same values in accedning order with two
> Criteria.
> for example I have emplo
It won't work... Just want to confirm whether do you want to blink your text
in a label or in cells...??
Regards
Deepak
On Wed, Sep 7, 2011 at 7:30 PM, Bheema Shankar wrote:
> Deepak ji
>
> I made little changes to your code to blink my label caption on the
> form:
>
>
> Dim MyArray() As Variant
Its better to not to use pie chart when you have many data points...
FYI...
On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain wrote:
> Hi All,
>
> please help me to remove 0 or null value in pie chart.
>
>
> file enclosed
>
> --
>
>
I hope this is what you're looking..
On Sat, Jun 18, 2011 at 7:29 AM, AyaNayzgi ZeWolqait wrote:
> Hello,
>
> I am trying to find out if there is a way of protecting or preventing
> modification of excel cells after a predetermined deadline has
> elapsed. For instance in cells A1:A20 a user is ex
Hope this will work..
On Fri, Jun 17, 2011 at 11:23 PM, airen wrote:
> Members please Help..
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twi
Tussi Vadde Mazakiya Ho Ji.. :-)
2011/6/15 NOORAIN ANSARI
> कविता : दास्तान-ए-VLOOKUP
>
> आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप.
> खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप.
> हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP .
>
> LOOKUP महोदय के दो बेटे दोनों गजब होनहार.
>
Hi Bob,
I'm sorry bro, I didn't understand your problem completely...
There is a minor problem with the code that you"ve written.. If you copy the
complete column then you can paste it only from row no 1 of the worksheet.
So instead of copying the complete column you just need to copy those rows
Just add the following line to your code..
Sheets("Customer
Record").Range("ABZ1").End(xlToLeft).Offset(0,1).PasteSpecial
Paste:=xlPasteValues
Regards
Deepak
On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> I'm sorry , Still having trouble with copy on next available blank
> row. If I record a m
n
>Cells(i, 5) = "Event Number"
> Else
>Cells(i, 5) = "Odd Number"
> End If
> Next i
>
> Range("K2") = Timer
> Range("K3") = Timer - Range("K1")
>
> End Sub
>
>
>
> On Sun, Apr 24, 201
Hi Guy's
Need your help in this code.. in the following code...
Sub Time_Test_Array2()
Range("K1") = Now()
Application.ScreenUpdating = False
Range("E:E").Clear
LastRow = 0
LastRow = Range("A100").End(xlUp).Row
iVal = Range("A1:A" & LastRow).Value
ReDim strArray(1 To UBound(i
This can be done in VBA using OLE objects but
>>> unfortunately we cannot do it in Excel 2007 as this feature has been
>>> taken off. Having said that you can definitely do this in earlier
>>> versions of Excel.
>>>
>>> On 3/27/11, Deepak Pal Singh wrote:
E objects but
> unfortunately we cannot do it in Excel 2007 as this feature has been
> taken off. Having said that you can definitely do this in earlier
> versions of Excel.
>
> On 3/27/11, Deepak Pal Singh wrote:
> > Hi Ashish,
> >
> > I'd attached the PPT i
as well
>
>
> On Sun, Mar 27, 2011 at 9:58 AM, Deepak Pal Singh <
> deepaktheind...@gmail.com> wrote:
>
>> Hi Guy's,
>>
>> I'm still waiting for your help...
>>
>> -- Forwarded message --
>> From: Deepak Pal Sin
Hi,
Can anyone send me some good study material to learn Advance Arrays in
VBA..??
Thanks
Deepak
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/ex
Hi,
I need a help to connect excel file to a database in Access, I've a table
format in the attached file, can anyone make a macro to solve this query.
1) Macro should take inputs from a useform and saved the data in the table
in access databse. Seq# should be unique and auto generated for every
Hi,
I've a workbook where two tables given on the sheet1 showing sales for 2009
and 2010. I want to present the data through Line Char. There should be a
dropdown on the top of the charts containing three values 2009, 2010 & 2009
Vs 2010. If I select 2009 then the chart should show only sales dur
Hi,
I've a workbook where two tables given on the sheet1 showing sales for 2009
and 2010. I want to present the data through Line Char. There should be a
dropdown on the top of the charts containing three values 2009, 2010 & 2009
Vs 2010. If I select 2009 then the chart should show only sales dur
Hi,
I've a workbook where two tables given on the sheet1 showing sales for 2009
and 2010. I want to present the data through Line Char. There should be a
dropdown on the top of the charts containing three values 2009, 2010 & 2009
Vs 2010. If I select 2009 then the chart should show only sales dur
Hi,
I've a workbook where two tables given on the sheet1 showing sales for 2009
and 2010. I want to present the data through Line Char. There should be a
dropdown on the top of the charts containing three values 2009, 2010 & 2009
Vs 2010. If I select 2009 then the chart should show only sales dur
ed message ------
From: Deepak Pal Singh
Date: Tue, Sep 7, 2010 at 10:21 AM
Subject: $$Excel-Macros$$ Urgent Help Required
To: excel-macros@googlegroups.com
Hi Guy's,
I've a worksheet containing three columns Serial No, Month and
New/CarryForward. I want to get count of New & Carry Forwar
Hi Guy's,
I've a worksheet containing three columns Serial No, Month and
New/CarryForward. I want to get count of New & Carry Forward on Monthly
basis using an excel formula not by pivot table, I've tried to done it using
COUNTIF but couldn't get success.
Please Help
Thanks
Deepak Kumar
--
---
Hey Noone is interested to solve this query..!! :-(
-- Forwarded message --
From: Deepak Pal Singh
Date: Tue, Aug 10, 2010 at 2:18 PM
Subject: Require A Macro To Compile Data From Different Files
To: excel-macros@googlegroups.com
Hi All,
I'm looking your help to develop a
Thanks Dave - it works...
On Sat, Aug 14, 2010 at 1:56 PM, Dave Bonallack
wrote:
> Hi,
> I hope the attached contains what you need.
> Regards - Dave.
>
> --
> Date: Sat, 14 Aug 2010 10:23:42 +0530
> Subject: $$Excel-Macros$$ Help Required
> From: deepaktheind...@gmail
Hi All,
I need your help to make an automation of the attached worksheet. In the
attached workbook different columns have been given . We have to searched
for duplicate entries in column Service Provider, From and To. If values
entered in these 3 columns are same then it should be displayed “Yes”
Hi All,
I'm looking your help to develop a code where I can compile data from
different files, these files located in a same folder and can be 20 or 50 I
don't know that, but macro should search excel files in a specific folder
and start to compile data.
Thanks
--
--
loop range from A1 to A100 will be selected, but
>> I want to select each cell one by one untill an empty cell comes, it can be
>> after 100 or before 100, that's wha idon't know.
>>
>>
>> Sub selectCells()
>>
>> Dim i As Integer
>> For i = 1
n't know.
Sub selectCells()
Dim i As Integer
For i = 1 To 100
Cells(i, 1).Select
End Sub
Thanks
On Sat, Jun 12, 2010 at 6:46 PM, Mahesh parab wrote:
> Hi Deepak
>
> find attach sheet, hope its as per u r requirement.
> Change Mypath in Module2.
>
> On Sat, Jun
Hi All,
I've some data in sheet1, people have to work on this data, i've assigned
the work to the concern people, now what i want a macros should be run and
then new files should be created ion the same folder in the name of assigned
peoples and those files should contain individual works that i'v
You can use =Today()-1
On Fri, May 28, 2010 at 10:07 PM, Surendra saxena wrote:
> Hi All,
>
> need you help to fix the formula in excel like below-
>
> (-Today+End.date)
>
> i want to fix the formula in excel which reflect always previous day value
> instead on today.
> --
> Your's
> Surendra
Hi Vidyut,
This is an example workbook for you, click on button click here, and the
macro will check to first 10 rows if it's found any empty cell in column a
then the entire row mey be edited else will be restricted.
Thanks
Deepak Kumar
On Wed, May 19, 2010 at 12:53 PM, vidyut more wrote:
>
41 matches
Mail list logo