Hi Jack,
Can u share a test file with us?. Thanks
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jun 15, 2009 at 11:44 PM, Jack wrote:
>
> Hi I need to create a link to other workbooks on c
Hi RCGUA,
'Assuming you have the formula in cell A1, use the following code.
Sub test()
Dim i As String
i = Range("a1").Value
MsgBox i
End Sub
'Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jun
what kinda ten Q's u need?
where does the names and tel numbers come from? you want to fill it in r
must it come from the sheet?
Do you want to view the sheet? print the sheet?
etc
please reply with more spesific specs. would be nice if you can attach a
sample or pix of what you vision
Hello,
Can someone kindly help me how to show a company logo, disclaimer, etc (a
jpg picture) at startup.
Thank you, in advance.
Regards
Ahmet
--~--~-~--~~~---~--~~
-
Some importa
Hi Ahmet,
For that, you have to save the Excel file which contains the Company logo,
disclaimer into *C:\Documents and Settings\User\Application
Data\Microsoft\Excel\XLSTART.*
Where *User *is Windows Login User.
Thanks!!
On Tue, Jun 16, 2009 at 1:04 PM, Ahmet Yalcin wrote:
> Hello,
>
> Can s
use userform show in workbook open
create a userform with a picture and label on. have it show with either a
timer or a button the user can click to hide
try and let know...
This email has been forwarded using a mobile phone with a internet/wap
application. Go to www.operamini.com for more info
Thanks Nishant for your assistance its woring perfectly fine..
Wish there is a rating system in this group where in we can give stars to
best reply...
Cheers
Niraj
On Sat, Jun 13, 2009 at 9:29 PM, Nishant Jain wrote:
>
> I have revised your file and have sent you an email... hope it will be
>
Name & tel Would come from a sheet1 Cols a and b Also questions from
sheet 2 cols a & b - I need to collate the answers on sheet 3 and
only the user can view the quiz user form
Thanks for you reply
On Jun 16, 8:09 am, Phillip Swanepoel wrote:
> what kinda ten Q's u need?
>
> where does the na
What i need is to be able to link to this workbook by using a cell to
define the week I dont think a test file woult help
='G:\Support\[WEEK 35.xls]Data'!$B$3
I want to use this formula on weeks 1 to 52 workbooks in a
folder ??
Many thanks for the reply
On Jun 16, 8:16 am, Dilip Pandey wr
What is the criteria on the name? does the user at some time enter his/her
name and number of does the develeper do this on the sheet? the develeper
select his/her name from a list on the userform?
This email has been forwarded using a mobile phone with a internet/wap
application. Go to www.op
Thanks thats great but Name & tel Would to come from a sheet1 from
Cols a and b (like a data validation field ) Also questions from
sheet 2 cols a & b - I need to collate the answers on sheet 3 and
only the user can view the quiz user form & I all
Cheers
On Jun 16, 9:15 am, Phillip Swanepoel
Hi Jack,
Many thanks for sharing the logic with us.
Look at the attached file, it may help you in achieving the task.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jun 16, 2009 at 2:41 PM, Jac
Hi ac737,
This is actually a good query. Same is solved and attached. Thanks.
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jun 16, 2009 at 4:41 AM, ac737 wrote:
>
> Hi,
>
> I have two li
Exactamundo Cheers Dilipandey
On Jun 16, 11:33 am, Dilip Pandey wrote:
> Hi Jack,
>
> Many thanks for sharing the logic with us.
> Look at the attached file, it may help you in achieving the task.
>
> Thanks,
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dil
I would fill in a sheet for name & number so there are no mistakes
when choosing
a drop down
Cheers
On Jun 16, 10:30 am, Phillip Swanepoel wrote:
> What is the criteria on the name? does the user at some time enter his/her
> name and number of does the develeper do this on the sheet? the deve
Hi Brian,
As you said in the end note of your email, please share trimmedown worksheet
with us. Thanks,
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jun 15, 2009 at 11:50 PM, Brian Wolfe
Hey..Dilip
that was great...
On Tue, Jun 16, 2009 at 4:16 PM, Dilip Pandey wrote:
> Hi ac737,
>
> This is actually a good query. Same is solved and attached. Thanks.
> Dilipandey
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@y
Hi Niraj:
If you don't mind can you send the working code that Nishant helped u with.
I am also having a problem getting it to work. I am also trying to do
something similar.
Thanks.
Mog
On Tue, Jun 16, 2009 at 3:49 AM, NIRAJ KOTHARI wrote:
>
> Thanks Nishant for your assistance its woring perfe
Thanks that gives me the resulting path but does not link to get the
value of the path only if i paste special values
hmmm stumped on this one !! cheers
On Jun 16, 11:33 am, Dilip Pandey wrote:
> Hi Jack,
>
> Many thanks for sharing the logic with us.
> Look at the attached file, it may help you
Hi All,
I want a few cells to be in a definite number format.So while a user enters
data in those cells the code should check and throw up a msg if format is
not matching.
I hav used the below code with an event.
But the problem is when the code Range("B25").Value = "" is encountered the
loop st
here it is
Function interest_cal(Principle As Double, rate As Double, days As Integer)
Dim i As Integer
Dim x As Double
Dim y As Double
Dim z As Integer
Dim j As Integer
Dim a As Double
Dim a1 As Double
Dim P1 As Double
Dim d1 As Integer
Dim interest_cal1 As Double
Dim interest_cal2 As Double
a1 =
Hi All,
I move some excel workbooks from computer A to another B. Computer A
has Bloomberg excel addin, but Computer B doesn't have, not even has
Bloomberg.
Strange thing is that now when i start any Excel session on Computer B,
the Excel has an Bloomberg add-in, although it doesn't work.
Thanks ! Paul!
this is very thorough and precise!
Thanks so much. Sometimes, I can feel the differences..but can' t
summarize and tell. i guess it is because I don't understand too deep.
Again,thanks so much
Vincent
On Mon, Jun 15, 2009 at 5:50 PM, Paul Schreiner wrote:
> Without get
Well... the short answer is "Yes and No".
First, what does this have to do with the title "Vlookup"??
Your question is WAY too vague.
There can BE no files called "c:week25", "c:week26".
they would have to be at a MINIMUM "C:\week25.xls", etc.
Also... are they all really in the root of C:\ ???
th
If the formula is in cell... E2 then:
Range("E2").value
Range("E2").formula
will give you the value and formula...
I'll let you figure out which is which
;-)
Paul
From: RCGUA
To: MS EXCEL AND VBA MACROS
Sent: Monday, June 15, 2009 5:35:29 PM
Subject: $$Exce
The problem is that, in your macro, you're changing the value of the cell... so
that fires off the change event AGAIN.
What I would do is, in the first line of the macro, add:
Application.EnableEvents = False
then, before the End Sub, add:
Application.EnableEvents = True
It will then only run
First, you use the FileSystemObject to obtain the list of files.
Like:
Sub FileList()
Dim fso, File, Files, FldrName
Dim Fldr, msg
Set fso = CreateObject("Scripting.FileSystemObject")
FldrName = "C:\temp\"
If fso.folderexists(FldrName) Then
msg = FldrName & Chr(13)
Try this...
Sub copy()
Dim i As Integer
Dim j As Integer
Dim k As Integer
i = 1
k = 1
'check the end of the loop
Do While ThisWorkbook.Sheets(1).Range(Cells(i, 1), Cells(i, 1)).Value
<> ""
'copies the range
ThisWorkbook.Sheets(1).Range(Cells(i, 1), Cells(i, 2)).copy
'activates the shee
Hi
I'm trying to use an Excel file to archive configs. So far I have
been able to find the files and input them into sheet1. with the 1st
code. However the file name entries have the file name's path
attached to the name. Is there a property option to only put the file
name in column 1?
Secon
Do you need to use sendkeys to specify the file name? In the Adobe PDF
printer preferences box, if you set the prompt for file name option to an
existing folder, then all the .PDFs generated are dumped there. The files
are by default saved with the primary name and .PDF suffix. You can then
progra
HI
i m sending 1 file in this i need tp find out the frequency based on
different intervals and on that need to make chart which show average
an frequancy based on time. plz help me
regards
ruchi
--~--~-~--~~~---~--~~
--
Hi Dilip
can u plz help me to understand this query?
plz elaborate it
thanks
regards
ruchi
On Tue, Jun 16, 2009 at 10:51 PM, Paul Schreiner wrote:
> Well... the short answer is "Yes and No".
> First, what does this have to do with the title "Vlookup"??
>
> Your question is WAY too vague.
>
Hi!
I need help with the an Excel macro.
On my worksheet, I have a monthly calendar where we can enter
someone's working time.
Beside it, starting on cell Q4, I have a 4 columns table that takes
the information from the calendar and make it ready to be transfer to
another worksheet where we wil
I have a shortcut on my desktop that will open a specific workBook in
Microsoft Excel 2003. How can I open that workbook to a specific
workSheet? For example, "sheet3"I need to use a shortcut or some
sort of batch file because I am running it from a fingerprint
reader.
The fingerprint read
Thank a million... Sample file was very helpfull. :)
2009/6/16 Phillip Swanepoel
>
> use userform show in workbook open
> create a userform with a picture and label on. have it show with either a
> timer or a button the user can click to hide
> try and let know...
>
>
>
> This email has been
Thank you...[?]
2009/6/16 Mahesh R
> Hi Ahmet,
>
> For that, you have to save the Excel file which contains the Company logo,
> disclaimer into *C:\Documents and Settings\User\Application
> Data\Microsoft\Excel\XLSTART.*
>
> Where *User *is Windows Login User.
>
>
> Thanks!!
>
>
> On Tue, Jun 16
Thank You to all of you. I knew this was something simple but I just
couldn't get it to work.
On Jun 16, 2:21 am, Dilip Pandey wrote:
> Hi RCGUA,
>
> 'Assuming you have the formula in cell A1, use the following code.
> Sub test()
> Dim i As String
> i = Range("a1").Value
> MsgBox i
> End Sub
>
try this
Sub Copy()
Dim i As Integer
Dim j As Integer
'find the next available cell to paste the data
j = 2
Do While ThisWorkbook.Sheets(2).Range("B" & j) <> ""
j = j + 1
Loop
'check whether the next cell is "X" and if yes then paste the value in
next sheet
i = 2
Do While ThisWorkbook.Sheets
38 matches
Mail list logo