Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...Vista Access 2003 & Ole
I have a DB I've been using, updating for several years. I use a =
different BMP on every record. Today I started to update it again. Last =
update a few weeks ago on my XP.
Today I went with 'insert object' 'create from file'. with XP I couldn't =
use JPG's so I made bmp's. Today even a bmp is just an icon.
How do I get the create from file to work again ?
more pix @ http://members.toast.net/cbminfo/index.html
...Macros for worksheet copy & paste?
I have 6 different excel files. How can I combine all 6
of them in one single excel file under individual
worksheets (E.g. Worksheet1 for File1, worksheet2 for
File2 ....etc)? I do not wish to copy & paste it
manually. Can I use a macro to take care of it? If so,
where can I find further info on how to go about it?
Assuming (1) this is a one-time need, and (2) your workbooks have
only one sheet each, this would probably be faster done by hand:
1) With all the files open choose one of the files to be the
2) Select the sheet in the subsequent books, one at...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <email@example.com> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...Creating a template using Publisher
I need help creating a neighborhood directory template using Publisher and
merging an Excel spreadsheet into it. It keeps printing multiple pages of the
first page after I merge.
What version Publisher?
If you have 2003 use the catalog merge for your directory.
Otherwise you need to setup your page as though it is labels. Determine the size
of the area you need for each entry, select labels in page setup, type the size
you determined in the page setup. Adjust the gaps and margins when you are ready
to print (2000 and bel...unable to access mail after re-enable account
After enable an disable account and change its password,
it can login to its mail account. What's happening. Is it
Thanks a lot
What is the error message when user tries to access mailbox? Does the user
still show in ADUC has having Exchange attributes? Have you looked at the MB
using ESM to see if it is disconnected?
"Raymond" <firstname.lastname@example.org> wrote in message
> After enable an disable account and change its password,
> it can login to its mail account. What's hap...Keyboard hooking through Accessibility
I am looking for a method to hook the keyboard without running a
background process. I know there are APIs for hooking
(SetWindowsHookEx), but I want to avoid the overhead of running another
background process for this and make the task do by windows itself.
I am thinking of tweaking the Accessibility option in windows for this.
Can we anyway do this by writing any script or modifying or adding
registry entries for Accessibility? Or is there any Accessibility
specific APIs which can re-program the Accessibility feature to do our
tasks when we press a key with Accessibility feature-on.
An...Keyboard shortcut for current date and time
Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me
Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.
Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?
Thanks in advance.
CTRL+; then SPACE then CTRL+SHIFT+;
Portland, Oregon USA
wrote in message
Ctrl+ ; inserts current dat...Excel 2000 macro security Level
Hi! I am running an ASP.NET application which ideally opens an Exce
spreadsheet with a macro included in it. When I try opening
spreadsheet without a macro, everything works fine, but with macros, i
hangs on the opening command. I tried to go to Excel 2000 and go t
Tools->Macros->Security Level->Low but it still hangs when I try t
open the macro spreadsheet. All works fine with the spreadsheet no
containing macros, so it really is a question of macro security. But
put it to low, so I don't understand how it is still not opening!! An
help would be greatly appreciated!
Thanks and...Running an Excel Macro from an Access Command Button
Can anyone help me with this, I am trying to run an excel macro from an
access command button.
I want the macro to Bold the Headings on a excel spreadsheet.
The code runs without any errors but the macro doesnt seem to work, I think
I have got the line
ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong
Private Sub cmdRunMac_Click()
Dim ExcelApp As Excel.Application
Dim ExcelBook As Excel.Workbook
Set ExcelApp = Excel.Application
ExcelApp.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and
Settings\...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Creating a worksheet in Spanish
Is there a way to create a worksheet on MS XP Pro running
Office 2003 Pro all in Spanish?
All valid formulas -except the ones from the Analysis Toolpack- will
automatically translate to the language of the Excel it's opened in. So any
spanish speaking Excel will translate formulas to spanish, no matter which
version it was written in.
The rest, text constants and such, has to be typed or pasted. Excel will not
translate this herself.
HTH. Best wishes Harald
"Kent" <Kent@discussions.microsoft.com> skrev i melding
news:ACCCBA3A-53B4...vba code to enable macros
Can we write a vba code to enable macros. In most of the sites it says
we cant do that . The only thing we can do is change the macro setting or
work around is hide the sheet which has macros. But none of them will work in
my case. Can we change an excel security setting to from macro on open so
that macros are enabled.
No. If we can do that with code, then so could a hacker with bad intentions.
"varsha12" <email@example.com> wrote in message
> Can we w...Times Subtraction Whith Access
I need to know how to subtract between two times variants and to get a
time result (With Access).
Access really isn't intended to do things like that, but
?Format(#18:05:50# - #08:00:10#, "hh:nn:ss")
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
<firstname.lastname@example.org> wrote in message
> I need to know how to subtract between two times variants and to get a
> time res...DAO, Access, zero-length strings?
How can you set that you want to allow zero-length strings
in a MS Access database with DAO?
Also, how can you set that you want default values? Access
doesn't seem to allow "DEFAULT" property...
...Macro on a protected worksheet in a shared workbook.
I have a macro in protected worksheets that can't run once the Workbook is
I have wrapped the Macro code so as the worksheet is unprotected for the
time the Macro runs, and unable the Autofilter.
The code is as follow at the moment:
Sheets("Critical Path").Unprotect ("")
' Newaction Macro
' Macro recorded 17/11/2004 by Clifford
Selection.AutoFilter Field:=1, Criteria1:="="
Sheets("Critical Path").EnableAutoFilter = True
I'm about to pull my hair out. I have no problem accessing system
attributes, but the second I try to get or set a value for a custom
attribute, I get an error (null or not an object). My problem is I am
checking the changed input to a field, and if it fails a certain
criteria, I need to reset the original value. The best way I could
think to do this was to store this value in a new attribute and then
restore it if needed. Any help would be greatly appreciated.
> I'm about to pull my hair out. I have no problem accessing system
> attributes, b...Importing into Access 2000
I have a text file 13187 characters long. It will not
import or link. Any suggestions?
Suggestions? First one is to give us a bit more information:
What happens when you try?
Can you import other text files?
What's different about this one?
Separated or delimited?
How many fields?
Where did it originate?
On Fri, 7 Nov 2003 14:57:16 -0800, "William Madison"
>I have a text file 13187 characters long. It will not
>import or link. Any suggestions?
John Nurick [Microsoft Access MVP]
Please respond in th...Import excel named range into Access error 3011
Hi, I've read a few posts on this topic, but none addresses my
I use Office 2003 on an XP SP3 machine.
I am using transferspreadsheet to import a named range in an excel file
This has worked beautifully until suddenly it stopped working.
I find now that if I extract the address of the named range from within
the Access VBA code,
it looks like this:
rather than this, which is what it should be:
When I open the spreadsheet and get the address of the named range in
the immediate window,
it also has the #REF error....Access 2000
I have suddenly started experiencing a very strange phenomenon.
If I edit a report and change anything in it, when I click on save,
Access shuts down completely without saving the changes !
I have tried all of the various compact and repair scenarios, I've
created a blank database and imported all my items into it - with no
success, finally I've uninstalled and re-installed access again with
This is drving me nuts !!!!!!!
Did you try a decompile?
Try these steps in order:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect...Opening Excel from Access
Wasn't sure where to drop this question.
I'm using Access 2003. After I dump a bunch of data to an Excel file, and
save it off, I'd like to give the user the prompt to open the Excel file the
app just created for them. I did a little digging, and found out that the
FileDialog object does not support the Open file dialog type in MS Access, or
as MSDN puts it:
msoFileDialogOpen Not supported in Microsoft Access.
So, anyone know of a workaround or a different approach to be able to prompt
the user to open an Excel file from within Access?
On Thu, 2 A...Output to macro to sharepoint
Hi all i need help please,
Using Access 2000 and up
I have an update macro that is doing update to tables and produces a
report that normally gets printed out. Now i need to stop printing
reports and distribute them electronically. My idea is to have them in
SNapshot format and push them to a SharePoint library. I have tried
this several times and get 'The report snapshot was not created
because you don't have enough free disk space for temporary work
files'. It then goes on to tell me to empty my recycle bin. I have
done a disk clean and nothing changed. Is it that i can't sa...Accessing Mailboxes
In Exchange 2003, is it possible for me to access a users mailbox through
exchange system manager, and delete mail from a folder?
This message will self destruct.
No. ESM does not give you any access to the actual mailbox structure.
"Dave" <email@example.com> wrote in message
> In Exchange 2003, is it possible for me to access a users mailbox through
> exchange system manager, and delete mail from a folder?
> This message will self destr...How do I protect a macro to prevent change ?
I have protection turned on for both the worksheets and the workbook. Even
so, the user can open Visual Basic Editor and change the macros. How to I
protect the macros from being changed ?
In Visual Basic go to tools > vga project properties > protection
and you will see a section for pass words
Try to keep the same pass for all of your work to make things easy if you
need to get back in.
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"Keisamcasco" <Keisamcasco@discussions.microsoft.com> wrote in message
news:12E280B5-02DB-4F77-AD51-59EC0D...Access 2003 Timecard form
I've been asked to create a timecard form to track employees start and end
times, lunch times, meeting times and break times. Is there a template
somewhere or something I can use to get started? Thanks
I would suggest Google. I found a timecard template in less than 30
On Fri, 18 Dec 2009 07:53:01 -0800, Pedw4220
>I've been asked to create a timecard form to track employees start and end
>times, lunch times, meeting times and break times. Is there a template
>somewhere or something I can use to g...