Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
protecting macro code26 Jan 2006 02:23 GMT2
Yes, I know that this is a subject frecuently asked, in fact, i want to
ask something related to a previous post
from
http://groups.google.com/group/microsoft.public.excel ...
Generating Hex key/password26 Jan 2006 02:07 GMT1
anyone have any links to sites regarding generation of random passwords
(upper / lower case, numbers & symbols) - will use to generate keys for use
in encryption.
an added bonus would be some base64 / hex converters etc.
how to set up master page that will auto update smaller pages26 Jan 2006 01:22 GMT1
i am trying to set up a tracking program that will enable my platoon to type
in all students into a data base, then everyrtime we update the master copy,
it will also save under each individual company.  would it be better to use
an access database vs. excel.  it also has to be ...
assign a unique  number26 Jan 2006 00:56 GMT2
I have a database working fine.  Data get input through a form.  I like
to fine if there is a way I can make the form or any additional code to
give the new data row a unique number.  Please help.  
Thank you
Sum Data in Col B, Add % of Total Col C, Add Rolling % of Total Co26 Jan 2006 00:48 GMT2
Another challenge for a noob like me:
I start out with this, with the headers at Row 6:
Security    Value
Apples    10
New object/automation error26 Jan 2006 00:11 GMT2
I need to create a new sheet in my macro.  So far the code I've been using
looks something like this:
Dim sheet7 as worksheet
sheet7 = new worksheet
Is it possible to edit multiple pivots at one time?26 Jan 2006 00:08 GMT4
Say I have 5 pivot tables that all have in the drop down menu "Geography" in
A4.  I would like to know if excel has a capability to select say Americas
from the drop down box and the same be selected and updated for every pivot
you have within the file.  I thought perhaps my ...
Question on a Chip Pearson macro26 Jan 2006 00:07 GMT4
All -
It is with no little temerity that I post this question about a Chip
Pearson macro found at:
http://www.cpearson.com/excel/deleting.htm
Userforms25 Jan 2006 23:44 GMT1
Is there a way to get one userform to pop-up and another one to pop-up in
front of it in one action.
Nestling of functions25 Jan 2006 23:40 GMT5
I want to insert a certain number of row texts into 20 identical spreadsheets.
When I copy the area I want to insert then my macro stops after the first of
the 20 sheets.
I use "for x=1 to 20" "Next x" to acheive the repeated copy.
Run-time error 100425 Jan 2006 22:29 GMT1
I use a macro to save an XLS workbook (created from an XLT template) to HTML
format for our intranet. It works fine once, but the second time it opens the
saved HTML file before running the macro, which causes the error:
Run-time error '1004': You cannot save this workbook with ...
referencing a cell within a header25 Jan 2006 22:24 GMT1
Is there a way to reference a cell's value in a header? I have a time card
that within the header is a pay ending from and to date that I must manually
fill out (argh!). Since the information is already in the spreadsheet every
week,[ always B5 and F5 ] I would like to be able to ...
Find Range for Pasting of Records25 Jan 2006 21:58 GMT1
I am pasting data into inserted columns.  How do I figure out the range of
the records that I have so I know when to stop pasting down the new inserted
columns?
A  B  C  D  E
setting where cursor is25 Jan 2006 21:48 GMT2
hello: what code would I need to add in my macro that records where the
cursor is (eg-cell A14) when the macro button is pushed and then return
to that spot (A14 in this example) at the end of the macro.
German VBA Problem25 Jan 2006 21:48 GMT3
I have a problem with a German VB file which I am sure is related to
the time and date format used in the UK dd.mm.yyyy
If i sent my PC to location Germany then the code works.
Can any help, here is the code
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.