Here are a couple of questions I have:
customer Billable% = Customer Billable hours/Potential hours (H17/
F17):
what do you want to see in H17? I am afraid you are thinking SUM
(H7:H16), but since all the values are percentages this simply makes
no sense. Might it be possible that H17 should be G
Nope.
The question is:
A user turns on the computer, and logs in.
There are event logs that track the date/time the user logs in.
then, at some point during the day, the user takes a break and locks
his PC.
The event log records this also.
the user returns from break and unlocks the machine
(Yet
Try this:
Dim x As String
x = Day(Date) & Month(Date) & Year(Date)
With Selection.QueryTable
.Connection = _
"URL;http://172.16.8.29/depadvpl1.asp?login=2014&rep_date1="; & x
.WebSelectionType = xlAllTables
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextT
I have copied all in one file.
Now can you please help how to copy matching data.
http://spreadsheets.google.com/ccc?key=0AgUVfFOnkiaKdFBiNDFLamcybXdhWkR6bS05Qnluenc&hl=en
On Dec 2, 3:46 pm, Khan <7naumankh...@gmail.com> wrote:
> Why not copy all the data in from one file to the other and then us
Not sure if I am correctly understanding the request here, but I
use the following code in some of my tools to track users usage:
Sub Auto_Open()
Dim serverfile As String
serverfile = "\\org\public\Hittrk\history.txt"
On Error Resume Next
Dim str As String
str = Application.UserName
str = str
Hi Abhishek
Please find attached file and see if this can solve your problem.
Rajeev Nandan
On Thu, Dec 3, 2009 at 3:50 PM, Abhishek Jain wrote:
> Hi all,
>
> Thank you for helping me out in past queries I had.
>
> Again I am stuck at point.
>
> I have a data file with fields - S.No., Customer Na
maybe you can help yourself (with my advice, if you haven't tried yet)
1: It's very useful to choke an error that you'r expecting and don't
care how it's going to be solved (relying on defaults), the way you
did before making & naming a new directory (folder), BUT you should
stop choking those er
try searching *URLmonikers* u will get the code on google, for unzipping
also u can get the code by googling
On Thu, Dec 3, 2009 at 7:43 PM, Vishvesh wrote:
> Hello,
>
> I would like to download abc file from "x" url and saved in on specified
> place in comp. And the downloaded file is ZIP file,
Andy could you please help with the syntax
Like " URL;http.and how do i get the s (string variable) here ?
On Thu, Dec 3, 2009 at 5:16 PM, Aindril De wrote:
> Use a string variable say x
> And Pass x = Day(Date) & Month(Date) & Year(Date)
>
> And in your URL pass x instead of the date
Hi All,
Is there any site or a graphic tutorial that teaches MS Excel, my minds
picks thing fast when they are depicted via pictures, so that I can learn
basic function in Excel??
--
Warm Regards,
Abdul Rehman.
"Woods are lovely, dark and deep
But I have promises to keep,
And miles, miles and m
Hi, can you please tell me what additional information you need.
Thanks,
Bala
On Thu, Dec 3, 2009 at 9:21 PM, RolfJ wrote:
> I'd be happy to help, but would need a bit more information.
>
> Rolf Jaeger
> SoarentComputing
> http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm
>
>
> On
I've struggled with this one for several years.
I finally did come across a VBS (Visual Basic Script) version that
could generate a report and clear the log files.
but I haven't been able to migrate it to Excel VBA.
I was kind-of hoping that your post would get some responses
and I wouldn't have t
You could place the following function into a standard VBA module of
your workbook:
Public Function LastUpdated() As Date
LastUpdated = FileDateTime(ActiveWorkbook.FullName)
End Function
And then use it in the cells you would like to show the date of the
last saved update by entering the form
Use Track Changes option of Excel...
On Thu, Dec 3, 2009 at 10:11 PM, krishnan Gopi wrote:
> Hello All,
>
> Facing problem with date function, the same is explained in the attachment.
>
> Regards
> Gopi Krishnan
>
> --
>
> -
I'd be happy to help, but would need a bit more information.
Rolf Jaeger
SoarentComputing
http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm
On Dec 2, 4:52 am, bala Subrahmanyam puligadda
wrote:
> Hi ALL,
>
> Please help me in the repeating some calculations by using the macro.
>
>
Hello All,
Facing problem with date function, the same is explained in the attachment.
Regards
Gopi Krishnan
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downl
Hello,
I would like to download abc file from "x" url and saved in on specified
place in comp. And the downloaded file is ZIP file, so i also wanna extract
it.
Please send me VBA code for the send
Thanks in advance.
--
---
The syntax for referring to named ranges is Range("{Name of Named
Range}"). Also, I would strong recommend to work with Option Explicit
which will require you to explicitly declare your variables. That
makes your code easier to read and maintain. Give this a try:
Option Explicit
Private Sub Works
Try this:
.Formula = "=SUMPRODUCT((C1:H1= " & UserForm1.ComboBox2.Value & ")*
(A2:A13= " & UserForm1.ComboBox1.Value & ")*(C2:H13))"
Hope this helped,
Rolf Jaeger
SoarentComputing
http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm
On Dec 2, 9:54 pm, sgltaylor wrote:
> Hi All,
>
> I
Hi all,
Thank you for helping me out in past queries I had.
Again I am stuck at point.
I have a data file with fields - S.No., Customer Name, Supplier Name and
Size Type. I need to prepare a customer wise and supplier wise report
(consolidated) at the end of month. All Customer names would be pl
Hello Balachander S
please check out the link,
calender.xls is there,may it help to u
http://groups.google.com/group/excel_vba
On Thu, Dec 3, 2009 at 3:06 PM, Balachander S wrote:
>
> I am using a macro web query to update a table from intranet.
>
> Every day i have to change the date. I have
Dear Sven,
Check if you have enabled formula view, Press CTRL + ` (grave accent).
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Nov 30, 2009 at 5:59 PM, Sven D wrote:
> Hi there,
>
> I
Use a string variable say x
And Pass x = Day(Date) & Month(Date) & Year(Date)
And in your URL pass x instead of the date
Regards,
Andy
On Thu, Dec 3, 2009 at 4:36 PM, Balachander S wrote:
>
> I am using a macro web query to update a table from intranet.
>
> Every day i have to change the date
Dear Umesh,
I have re-formulated the attached workbook.I don't think a macro is required
in this revised scenario.
Please check and get back to me in case of any queries.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
Dear Umesh,
Try following macro - easy to understand as well.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
I = ActiveCell.Address
If I = "$G$31" Then
Range("H31").Formula = "=F31*10%"
Range("i31").Formula = "=H31*2%"
Range("j31").Formula = "=H31*1%"
ElseIf I = "$G$32" Then
MsgBox
I am using a macro web query to update a table from intranet.
Every day i have to change the date. I have tried to create that as a
variable but not able to do so . Any suggestion
With Selection.QueryTable
.Connection = _
"URL;http://172.16.8.29/depadvpl1.asp?login=2014&rep_date
26 matches
Mail list logo