Check for valid file name before saving
My form copies a file from one locatin, prompts the user to create a
new name for the file, then saves the file to another location.
is there an easy way to ensure the user has entered a valid file name
(e.g. did not use '/' or "^" or anything like that) so the save does
not fail? OR, would it be easier to some how set up error handling so
that if the save fails for that reason, i can prompt the user to try
How would i do either of these things?
You must use error handling for this kind of operation, as there are just
too many things that could go wrong....Free/Busy Option
I'm hating the fact that everytime I shut Outlook 2002
down the error message of "free/busy opertaion failed" - I
have been able to set the minutes checked to 99 - but how
do I uninstall or quit the free/busy option?
...How can I share information between multiple sheets in Excel?
I know now how to use "=sheet1!a1" to copy cells from sheet 1 to sheet 2,3
Is there is a formula that will allow me to enter data
into sheet 2, and have it copy automatically into sheet 1 and 3, or into
sheet 3 going to sheet 1 and 2? So that I can enter the data into any sheet
and have it transfer to all sheets, rather than always from sheet 1 to sheets
2 and 3.
Nothing built into excel (except for the formula you showed).
But I'd be very hesitant to separate my data. I'd do my best to keep all the
data on one worksheet.
You can use Data|Fi...Transfer from Checking into Savings account...
Now I'm really confused. I'm using M05 Deluxe and I set up an ING Direct
savings account. I transfered $20.00 into the ING account from checking but
when I look at the ING savings account register, it shows a poitive Decrease
of 20.00 and a balance of (20.00). As if I owe 20.00 to ING. However, when I
click on the Home tab, it shows that ING has a positive amount of $20.00.
What gives? Am I doing something wrong or is this how it's supposed to be?
Essential Register and/or downloaded transaction data?
What type of Money Account is the ING Savings ...How to create an optional list for a cell
I would like to create a list for a cell in excel that is optional.
The list is only a convience for the user but it does not define all
possible values that can be entered. Does anyone know how to do this?
I used validation but then that restricts the cells values to the
list values which I don't won't.
In the Data Validation dialog box, on the Error Alert tab, remove the
check mark from 'Show error alert after invalid data is entered'
Users will still see the dropdown list, but can type values that aren't
in the list.
Ryan Hubbard wrote:
> I...Call from a different sheet?
I'm wondering if it's possible in Excel to call data from a different
For example if I changed A1 in sheet 2 it'd affect forumlas in sheet 1.
HisHighness's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31454
View this thread: http://www.excelforum.com/showthread.php?threadid=511552
You can link to another worksheet with a formula like
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson...Transfer the total of mutiple entries in a sheet to another sheet in the same file #2
How to transfer the total of multiple of multiple entries in a sheet to
another shet in the same file.
Please help me in this formula
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
...Filter Junk E-mail OWA option
Given an id, this code sets the 'Filter Junk E-mail' option (via OWA)
on. I'd like to inspect the mailbox to see if it is already set. How do
I do that?
strUrl = "https://webdav.university.edu/exchange/" & id & "/"
Set XmlHttp = CreateObject("Microsoft.XMLHTTP")
XmlHttp.Open "POST", strURL,false,strUserName,strPassword
XmlHttp.SetRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE
6.0; Windows NT 5.0; .NET CLR 1.1....HOW DO I CHANGE THE ORDER OF THE SHEETS IN EXCEL WORKBOOK?
my sheets are not in the order I want them. How do I change the order. The
data is already in the sheets.
Click on the tab and drag it to where you want to.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
"joanbaer" <email@example.com> wrote in message
news:1F45...Workflow Check Condition Question
I need help understanding how to utilize the workflow check conditions,
particularly the "In" value.
I was assuming that the "In" value was a way to check a field against a list
of possible conditions: i.e. State/Province is In (VA, FL, TX, etc.). Is
this correct? If so, I need guidance on the proper way to format the
condition, as it is currently not working (i.e. "VA", "FL", "TX", or VA;
If this is not a correct way to utilize the In value, how might I check a
field against multiple values without creating 50 otherwise ch...Check out internet update from the MS
Content-Type: multipart/related; boundary="dmathlqjv";
Content-Type: multipart/alternative; boundary="htcysyiof"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to help maintain the security of your computer
from these vulner...Max number sheets in a file?
How many sheets can an excel 2002 file have if each sheet has only abou
a page of text? I'm just looking for a general idea, if it's lots an
lots and I don't need to worry about it that's a good enough answer fo
Message posted from http://www.ExcelForum.com
The number will be limited by the memory in your computer. Certainly
hundreds of sheets is well within most machine's capacity.
In article <firstname.lastname@example.org>,
bishopwill <<email@example.com>> wrote:
> How many sheets can an excel 2002 file hav...Sheet to sheet copying
I have two spreadsheets. One called nursing and the other medical. I want
to be able to copy certain cells from one sheet to other and visa verca
without the need to copy & paste.
So I want a cell in nursing to search a column for specific text in the
medical sheet, then I want the contents of cells in the row where the text is
found to be copied to cells in the nursing sheet.
The cells B3-G3 in the nursing sheet to search Column A in the medical sheet
for specific text e.g. "G1". When "G1" is found in cell A5 then the contents
of cells B5-G5 in t...Settings not retained in Advance Options when Outlook is closed.
I have a workstation at a remote location that uses POP3
to access our Exchange server. In Advance Setting, I
checked the box for messages to be left on server. Once I
completly close out of Outlook, the setting does not
remain. Any suggestions?
...Check Register to Mortgage Sheet
I am using MS Money 2007. If I write a check in my register to my
mortgage company, how do I get that transaction to update my mortgage
account register? Do I have to type it in twice (Once to my check
register and once to my mortgage register)? I would like to set some
stuff up where items in my check register automatically cary to other
account items. Thanks for any advice on this.
From the Check Register make it a transfer to your Mortgage Account.
Microsoft MVP - Money
For UK tips & fixes see
http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mn...list sheet comments
I have a sheet with a lot of comments. I would like to create a macro
that lists all the comments of the sheet in column F. I=B4ve tried
something similar like this:
For Each cmt in ActiveSheet.Comments
But I don=B4t know how to list each comment in each cell of column F
instead of a msgbox.
Dim StartCell as Range
dim Cmt as comment
set startcell = .range("F1")
for each cmt in .comments
startcell.value = cmt.txt
'come down to the next cell
set startcell = startcell.offset(1,0)
n...blank out rest of work sheet
I was wondering how to blank out the empy cells in my worksheet. For
I have data in columns A-F down about 50 rows. I do not want to see any rows
past that. When I am saving the data as a text file, I am getting extra rows
in my file for some reason and I want to see if this would prevent this from
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.769 / Virus Database: 516 - Release Date: 9/24/2004
See the explanation and remedial notes on Debra Dalgleish's web site:
...Colour code worksheet tabs
Is there anyway to colour code worksheet tabs within an
Only with Excel 2002 and later versions. Right click sheet tab.
"Al" <firstname.lastname@example.org> wrote in message
> Is there anyway to colour code worksheet tabs within an
> excel workbook?
Only Excel 2002 or later.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Al" <anonymous@discus...How to populate one sheet with data from another sheet
I have 2 sheets in the excel file.
On the first sheet the first colum is a part num only.
The second sheet has part num on the first column and descriptions on the
I need a macro or script that will scan the second sheet for part num that
the first sheet part num and populate the description(at the second column)
on the first excel sheet.
One way ..
Assuming the reference data is in Sheet2, cols A and B
col A = part#, col B = description
With col A containing part# in A2 down,
Put in B2:
=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"&quo...No Bound Sheets Found Error Dialog Box-Excel 2000
Hello all. I have a 8.5MB spreadsheet that is the
summary of weekly timesheets that are Excel files. I
have attempted various strategies to reduce the size of
the files. This sheet is all references to other
worksheets. Up until two days ago, when opening the file
and it asks, this contains references to other files...do
you want Excel to update the cell refences, y or N. I
always hit okay and it does it's stuff. Now however,
when the box comes up when opening the file, I hit okay
and it returns a "No Bound Sheets" error dialog box. All
I can do is hit okay and a...Changing from sheet to sheet
Is there a function that would enable me to navigate from
sheet to sheet in an Excel document (instead of using the
mouse and click on the sheet I want to work with)?
Ctrl PgUp and Ctrl PgDwn is one way. Insert > Hyperlink (and after that
clicking it) is another.
HTH. Best wishes Harald
"Greywolf" <email@example.com> skrev i melding
> Hi there!
> Is there a function that would enable me to navigate from
> sheet to sheet in an Excel document (instead of using the
&...Merged Cell Check
I currently have a series of merged cells which I want to be checked
for population before allowing the user to the send the s/sheet off.
I'm currently using :
For Each Name In Range("mandatory_fields")
If Name.Value = "" Then
However, say for example i have a merged cell of h12:o12 called
"mandatory_fields". The macro counts them as individual cells so even
when populated, it can never be validated - wants cell I12 to be
This make sense to anyone?
~~ Message posted from ht...Delete values in sheet 2 that arre found in sheet 1
Is there an easy way to delete values in sheet 2 that match the value from
sheet 1. I have approximately 10000 rows in sheet 1 and some identical rows
on sheet 2 that need to be eliminated? I not sure if this has to be done
pragmatically or if there is some feature in excel 2007 that can handle this
type of request.
If it is the values in a single column on each sheet that make up the
duplication, it's fairly easy. Lets say you want to compare the contents of
column A on each sheet to find duplicates on Sheet2 (that are also on
Sheet1). Your data starts o...Opening Excel Spreadsheet on a tab #4
Thats excellent thanks, exactly what I was looking for!
david.willis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1469
View this thread: http://www.excelforum.com/showthread.php?threadid=26320
...Function to Copy all sheets into one sheet
Is there a way to copy multiple sheets at once to create
one worksheet, rather than one at a time?
You could use a for/each loop
for each ws in worksheets
depends on what and where you want to copy
"Des" <firstname.lastname@example.org> wrote in message
> Is there a way to copy multiple sheets at once to create
> one worksheet, rather than one at a time?