I had gone through the excel file,
I think, the format has to be changed, so as to enable stock splits
and bonus issues.
The important thing, that has to incorporated in the sheet is to add
Running closing stock has to maintained.
Further changes has to be made based upon running closing balance
I
Dear all,
required help in getting data from sql temparary table to excel thru
microsoft query
i have tried using the globel temp ## could not get the data
please provide the steps for the same
On 10/22/10, CAN wrote:
> I have a .CSV file see sample below which I need macro to convert
> to .txt f
Very Good information!
On Thu, Oct 14, 2010 at 6:30 PM, Paul Schreiner wrote:
> Do you mean to change the file associations?
>
> For that, what you do is change your own associations.
> Then go to the system registry (using run -Regedit)
> Find your .xlsx extensions, right-click and "export" the
1)
PropertyID Account#Date Time Net Funded
1212178 2 *10/10/2010* 11:02481
1212178 2*101020*echeck00048100
Do you want current date in YYMMDD format
2)
Will platform are you working?
On Fri, Oct 22, 2010 at 2:28 AM, CAN wrote:
> I have
See the movie enjoy it to click full movie and
photohttp://123maza.com/35/super274/
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/ex
This code make a popup with sheetsList
But I don't understand how it works
On Error Resume Next
Application.CommandBars("Workbook Tabs").Controls("More
Sheets...").Execute
If Err.Number > 0 Then
Err.Clear
Application.CommandBars("Workbook Tabs").ShowPopup
End If
ActiveWi
For examples you can look here:
http://spreadsheetpage.com/index.php/tip/displaying_a_progress_indicator/
http://spreadsheetpage.com/index.php/blog/progress_bars_the_movie/
regards
r
2010/10/21 roberto mensa
> the module of userform is a class module.
> you have two form then you have two cl
I have a .CSV file see sample below which I need macro to convert
to .txt file in an specific format.
Orginal file will be like this.
PropertyID Account#Date Time Net Funded
1212178 2 10/10/2010 11:02481
1212CAS 311 10/10/2010 20:2375
1212CAS 312 1
the module of userform is a class module.
you have two form then you have two class modules (frmMain,frmWaiting)
you can in your loop run a sub for change the appearance of userform, try
the ontime method combined with doevents but you can not get two separate
macros to run at the same time.
you
Thank you for your reply.
But I'm afraid I don't understand very well.
You use "class", and I don't have any special classes??
All I have is the two forms.
The main code in Private Sub CommandButton1_Click() in frmMain does
not contain any loops. It just begins and runs through until the
end. My
If you want to protect the sheet while opening,:
when you press save, you will get a save window, there below left you will
find General Tab ,there you will put an password to your file.
If regarding vba, just right click on the module then vba properties there
you can protect the vba module..
h
Instead of a blank cell, insert the average between the previous and
the subsequent period.
DV
On Oct 21, 7:25 am, Shrinivas Shevde wrote:
> Thanks Ajay and Vijaykumar,Shiv kumar
> Both Option I can not use (Pivot Table and 0 values)
> Is there any another option any setting
> Shrinivas
>
>
>
> O
I'm a bit sketchy on Class Modules, so going through the code, I was a
bit lost. However you posted a sample which is extremely cool. I'm
going to work through that and see if I can decipher it.
I'm so glad I've found this forum. Thanks for all of your help!
Cheers,
Matt
On Oct 20, 6:49 pm, ro
Hi,
Have a look at the attached to see if it does what you need.
Regards - Dave.
> Date: Wed, 20 Oct 2010 20:04:57 -0700
> Subject: $$Excel-Macros$$ Finding student whose marks are improving over
> three consecutive tests
> From: vaaibhavjhav...@gmail.com
> To: excel-macros@googlegroups.com
>
Private Sub Workbook_Open()
Dim pw
pw = InputBox("Please Enter The Password", "PassWord")
If UCase(pw) <> UCase(Trim("abc")) Then
Me.Close (savechanges = no)
End If
End Sub
On Oct 21, 8:56 am, Jai wrote:
> Dear Group member,
>
> please provide the VBA Code to protect the exc
Dear Group member,
please provide the VBA Code to protect the excle file, When we open the
excel file he need passward.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
16 matches
Mail list logo