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 = _
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 (Calculate
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 -
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 sba...@gmail.com wrote:
I am using a macro web query to update a table from intranet.
Every day i have to
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
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 sba...@gmail.com wrote:
I am using a macro web query to update a table from intranet.
Every day i have to change the
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
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 stvn.tay...@gmail.com wrote:
Hi
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
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.
--
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
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 simplyb...@gmail.com
wrote:
Hi ALL,
Please help me in the repeating some calculations by
Use Track Changes option of Excel...
On Thu, Dec 3, 2009 at 10:11 PM, krishnan Gopi excelg...@gmail.com wrote:
Hello All,
Facing problem with date function, the same is explained in the attachment.
Regards
Gopi Krishnan
--
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
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
Hi, can you please tell me what additional information you need.
Thanks,
Bala
On Thu, Dec 3, 2009 at 9:21 PM, RolfJ r...@pacificsound.us wrote:
I'd be happy to help, but would need a bit more information.
Rolf Jaeger
SoarentComputing
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
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 aind...@gmail.com wrote:
Use a string variable say x
And Pass x = Day(Date) Month(Date) Year(Date)
And in your URL pass x instead
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 vishvesh.chau...@gmail.com wrote:
Hello,
I would like to download abc file from x url and saved in on specified
place in comp. And the
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
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
I have copied all in one file.
Now can you please help how to copy matching data.
http://spreadsheets.google.com/ccc?key=0AgUVfFOnkiaKdFBiNDFLamcybXdhWkR6bS05Qnluenchl=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 use
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=2014rep_date1=; x
.WebSelectionType = xlAllTables
.WebFormatting = xlWebFormattingNone
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
24 matches
Mail list logo