I've been messing with that code snip you gave me all day to no avail.
A couple of things are missing from my description:
1. I'm running from a button on an access form
2. Corrupt file is at "c:\san_corrupt.xls"
3. Good file is at "c:\san.xls"
Basic code where I'm at:
***
Option
I have a speadsheet that has 5 columns.
(Headings are in row 2 and are: Cell A2=Date, B2=Name, C2=Paylist,
D2=Cycle, E2=Action).
Data starts in Row 3 and will go down to row 5000. The dates would
start 01-Jan-2011 and could go up to 31-Dec-2011.
Right now I have 2 macro's to sort by date and pa
AJ,
Thanks, this is exactly what i was looking for
Thanks
Harry
On Mar 7, 10:53 pm, Abhishek Jain wrote:
> Dear Harpreet,
>
> Check the sample file attached. Format used is - "[h]:mm" (without quotes).
>
> Cheers!
>
> AJ
>
> On Sun, Mar 7, 2010 at 12:42 PM, Harpreet Singh Gujral <
>
>
>
> harp
Aj,
I read the below attached code
I have some questions about it, as i am keen to learn
application.ontime event
Why did we repeat the following line of code
Application.OnTime TimeValue("20:20:00"), "Close_and_Save"
in both Workbook_Open event and the Close_And_SAve sub?
Is it important to do
Hi Imran,
I have followed the following logic:
In Column G, i have entered a IF Statement, which will seek for Text in
columns H to M, as soon as it finds and text in any of the first columns,
that will be imitated in Column G
Please see the attached file
Thanks
Harpreet Gujral
On Mar 10, 12:5
I have a speadsheet that has 5 columns.
(Headings are in row 2 and are: Cell A2=Date, B2=Name, C2=Paylist,
D2=Cycle, E2=Action).
Data starts in Row 3 and will go down to row 5000. The dates would
start 01-Jan-2011 and could go up to 31-Dec-2011.
Right now I have 2 macro's to sort by date and pa
Hi Shyam,
Thank you for your help again, but I do not see how hiding the Formula
Bar is related to the question though.
Excel 009
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Dear All,
Pls send V.B.A e-book ..or url
--
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U"
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨)
Dear Aindril
Thanks For Confirmation,Try to read the range suppose a1:a100
(the value which will be takes place as file name).
then try to save as with loop.
Hope it Will Help
Happy To Help
:)
Shyam
On Thu, Mar 11, 2010 at 3:41 PM, Andy wrote:
> Hi Shyam,
> Thanks for the code.
> I am alread
Hello Neil
You can select range,Suppose you want to send the chart from excel to power
point.
then you can use this code as it...
""
Module1
Sub ChartToPresentation()
Good and I also like the concept / funda of defined names.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Tue, Mar 9, 2010 at 1:22 PM, Born to Win wrote:
> Sir,
>
> Please Check Attenda
Dear Vinu,
I am behind my lots of emails and still catching them.
Suggestions from my side:-
- SumProduct is faster thean SumIf, so you can use SumProduct.
- Pivot table is again going to be on a higher side of calculations.
- Move to the last row of data in your spreadsheet and delete
I haven't been able to test this extensively, because I don't have a corrupt
file,
but with an incorrect file type, this works:
On Error Resume Next
Workbooks.Open Filename:="C:\temp\testfile.xls"
If (Err) Then
MsgBox Err.Description
Exit Sub
End If
Paul
_
Hi Hakim
I found this post answered, hence thought to reply the same.
For certification, you can visit Microsoft's web site and search for online
exams / certifications.
For enhancing your learning, you can continue answering the posts of this
group, or you can refer some online PDF book as well.
Hi,
Attached sheet is solved per your requirements. let me know if you still
face any challenges.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Mar 5, 2010 at 11:50 AM, MOHAMMED I
Hi,
What type of data you want to send into power point. I mean are you want to
make charts or tables in ppt.
Regards,
Swapnil.
On Thu, Mar 11, 2010 at 12:58 PM, neil johnson wrote:
> Hi,
>
> I want to send excel data into power point through excel vba .
>
> Thanks and Regards
>
> --
>
> -
Hi Shyam,
Thanks for the code.
I am already doing this.
My main query is after I have made the copies, I want to rename these
files automatically with the names that I have in a list in Excel.
Regards,
Aindril
On Mar 8, 6:30 pm, rf1234 rf1234 wrote:
> Hello Dear,
> Try to savecopyas
>
>
Hi,
How can i send the excel data into power point through excel vba.
Please solve my problem.
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.
Hi,
I want to send excel data into power point through excel vba .
Thanks and Regards
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Hello Dear,
Thanks to provide me bug,i have think about this bug.I think we can solve it
to
use
'''for others
Application.DisplayFormulaBar = False
'''for admin
Application.DisplayFormulaBar = True
in code
Hope It Will Help
Happy To Help
:)
Shyam
On Wed, Mar 10, 2010 at 11:19 PM, Excel
20 matches
Mail list logo
