Hi Ashish,
First of all congrats! You are a big help to all of us :)
Also, Thanks a lot for your help. you. I tweaked your code a bit and
got it to work the way I needed. now I have another problem:
I am combining files from different location into one sheet (a new
workbook). The list of files t
eChanges:=False
End With
k = Len(Dir(strPath))' Just to change the Dir to strPath- it does
change the path to strPath but starts from 1st file again and again
and again
strExtension = Dir
Loop
I searched a lot but could not find anything that I understand. Your
help is greatly apprecia
B$1
.Range("E" & i).Formula = "=$A$" & (i - 1) & " & " & " - " & "$B$" &
(i - 1) ' Does not work
.Range("E" & i).Formula = "=$A$" & (i - 1) & " & " & Chr(34) & " - &q
:
http://www.tek-tips.com/faqs.cfm?fid=4090
So I changed the sheet's (name) in the properties window to "shtBonus"
and then used it like this: shtBonus.Range("A1").select
Once again, Thanks for your help and directing me to right direction.
Best regards,
Nasim
On Feb 15,
Dim WSB, WSH As Worksheet
Dim u, t, p, q, LastRowH, LastRowB As Integer
Set WSB = ThisWorkbook.Sheets(9) ' :I changed it to Set WBS =
Thisworkbook.Sheet9 and it does not work
Set WSH = ThisWorkbook.Sheets(2)
I am still so confused. I appreciate if you could explaine this a bit
more.
excel 2010?
I appreciate your help.
Best regards,
Nasim
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN gr
tly.
Thanks a lot for your help.
Nasim
On Jan 6, 6:38 am, Paul Schreiner wrote:
> I don't see where you're setting the variable: excelFile
>
> in the Editor, set a breakpoint at the statement:
> Do While Excelfile <> ""
>
> and step through.
>
> an
nt.
Thanks,
Nasim
On Jan 5, 10:44 pm, ashish koul wrote:
> try this it may help
>
> Fpath = BrowseFolder(Caption:="Select the folder .")
> excelFile = Dir(Fpath & "\*.xls")
>
> Do While excelFile <> ""
>
> If excelFile <
Hi Paul,
Your recommendation solved my problem. I removed the if statement I
had and replace this line:
Do While excelFile <> ""
with this
Thanks a lot for your help.
Nasim
On Jan 6, 6:38 am, Paul Schreiner wrote:
> I don't see where you're setting the v
ot;Combined Manual
Timesheets.xls").Sheets(1).Range("A" & (LastRow + 1))
' Paste:=8 will copy the columnwidth in Excel 2000 and higher
.PasteSpecial Paste:=8
.PasteSpecial xlPasteValues
End With
Application.CutCopyMode = False
ActiveWork
Hi All and Happy New Year!
My users' files need to be email to me everyday. I know how to send
the sheets with email but if a user does not have outlook it gives an
error message. How can I check if user has outlook installed?
Thanks.
box) to PROPER but I noticed that if user tabs out
of the box then it passes the text to the cell and when user clicks on
save the tab does not happen so nothing is passed to the cell. How can
I mimik a tab on last box to be filled?
Thanks.
Nasim
Hi,
I have a combobox that is populated from a named range on a sheet
(days from1 to 31) I changed them to text to show as (01 to 31) but my
combo box still shows 1 instead of 01. Can this be fixed?
Thanks.
Nasim
I can see that this file is blank, but cells are protected!
so there are 3 problems:
1- the xls file can not be opened
2- the save as for .xlsx opens
3- even in the .xlsx file the celles are not copied
Thanks for your help. below is my code:
Nasim
Private Sub cmdSave_Click()
Dim NewWorkbook As
. I would appreciate your help.
Thanks,
Nasim
On Nov 30, 5:26 am, Paul Schreiner wrote:
> What you're looking for here is a thing called "modality".
> What it EFFECTIVELY means is that the "mode" of the user form
> is tied to the workbook.
> if you look at &q
Hi,
I have a userform which I would like to open in new instance and also
minimize excel so only the userform is visible. I am using excel 2007
to write the codes but am saving it as excel2003. later i will need to
create both versions for people with differnet versions (if it does
not run on exce
16 matches
Mail list logo
