Where I work, we unfortunately use the dinosaur called SAS.
I have a SAS plug in for excel which allows me to ODBC in, execute SAS
code, and retrieve the data set created using the copyfromrecordset
statement.
Problem is this is one directional.
I have a need whereby I have data in an excel shee
Dear group,
The survey has received very few hits till date. Please spare a minute
to share your feedback.
It will definitely help us to take this group to next level.
Looking forward to your active participation.
Thank you so much
Best regards,
Ayush Jain
Group Manager
On May 30, 8:55 pm, ayu
Hi Stuart, Harpreet,
There is no bug in ques. 8. As you are the member of Google Excel
group, Just mark MS Excel Google group (discussexcel.com) option only.
Hope it helps.
On Jun 1, 10:27 am, Harpreet Singh Gujral
wrote:
> My question is the same,
>
> I only check the mails i receive from the g
hi
need any macro that will not allow user to paste any thing in data
validation column
for example i have put validation on col a anyone can copy data from any
cell and paste in any cell of col a .. how can it be stopped or not
allowed .
regards
ashish
--
--
Its Possible !!!
Here is a solution what you are looking.
Add a Picture to an Excel Comment
1. Right-click the cell which contains the comment.
2. Choose *Show/Hide Comments*, and clear any text from the comment.
3. Click on the border of the comment, to select it.
4. Choose *Fo
I think it is working fine. can u please put an snapshot, where u r not able
to view customize button
On Tue, Jun 1, 2010 at 8:53 AM, big smile wrote:
> Thanks for reply
>
> But in excel 2007 - there is no such Button
>
> & one more thing it is not working only in one file -- & not in all the
>
Hi Group,
I am a novice in VBA, is there ne source or website from where i can get an
idea of dashboard designsi.e., if i can have a look at some of the
dashboards, it helps to design one
Harry
--
--
Some import
Dear Harmeet Singh,
It s working thanks a lot
On Tue, Jun 1, 2010 at 4:08 PM, Harmeet Singh wrote:
> *Here you go*
> *use mentioned code*
> *
> *
> *Sub ren()*
> *
> *
> *mo = InputBox("Enter Month number.")*
> *
> *
> *For i = 1 To Application.Worksheets.Count*
> *
> *
> *Sheets(i).
Thanks a lot
Jitendra Kr. Verma
On Tue, Jun 1, 2010 at 3:34 PM, Jitendra Kumar Verma <
jitendra.ve...@globallogic.com> wrote:
> Use this macro to Rename the sheet.
>
>
>
> Sub Renamesheet()
>
>
>
> Dim shtName As String
>
>
>
> For Each sht In ThisWorkbook.Sheets
>
> shtName = sht.Nam
Hi All /
I feel that I am facing a similar problem in word.
My work relates to prepare a large number of reports and I use mail merge
for all this process. I have to save each and every report separately. The
file name I need to use is also generated through mail merge at the very
first line of e
Use this macro to Rename the sheet.
Sub Renamesheet()
Dim shtName As String
For Each sht In ThisWorkbook.Sheets
shtName = sht.Name
shtName = Left(shtName, 2) & Replace(shtName, "05", "06", 3)
sht.Name = shtName
Next
End Sub
Regards,
Jiten
*Here you go*
*use mentioned code*
*
*
*Sub ren()*
*
*
*mo = InputBox("Enter Month number.")*
*
*
*For i = 1 To Application.Worksheets.Count*
*
*
*Sheets(i).Name = Left(Sheets(i).Name, 3) & mo & Right(Sheets(i).Name,
3)*
*Next i*
*
*
*End Sub*
Warm Regards,
Harmeet Singh
http://www.fac
Hi,
I want build a macro open a Userform showing the corresponding values
from a worksheet by entering a value in a Input box. For Example if i
enter a ID Number and click ok button, then one userform with
corresponding values (Name, address, sex, date of birth) should open
to view the values. Ple
13 matches
Mail list logo