Automatically naming a file using cell contents
How do I use the contents of a cell to automatically name a file using a
macro to populate Save As?
Include this in your macro:
Activeworkbook.SaveAs Filenmae:=Range("A1").Value & ".xls"
> How do I use the contents of a cell to automatically name a file using a
> macro to populate Save As?
...Send/Receive--Error Nos Ox800cccOd and Ox800cccOf
I've been having problems recently sending and receiving
email on Outlook 2000. I get a "server cannot be found"
message with the error number Ox800cccOd and a "tcp/ip
connection was unexpectedly terminated by the server"
message with the error number Ox800cccOf.
An earlier poster identified the same problem and was able
to fix it by closing down Outlook and then opening it
again. This, however, has not worked for me. Does anyone
have any other suggestions as to how I might fix this
...Budgetting problem encountered
I am having a problem with the budgeting function of
After entering my expense categories, I proceed to the
next screen entitled: "Review your current budget
status." The software has added an additional budget
category entitled: "Special" with a subcategory
entitled "debt." It has added an amount for this
category that I had not entered in my budget. There is
no telling where it got this figure, nor why it should
have added something to my budget that I do not want
Moreover, I cannot delete this budget category. The only
way to ...Error posting batch
I just upgraded to version 8.0 from 7.5 and everytime I post a batch I get
this error The stored procedure glpBatchCleanup returne the following
results: DBMS 0, Great Plains 20488.
When I click the More Info button I see thsi Select on Batch_headers
failed. Can somebody point me out on how to fix this.
Have you applied any 8.0 service packs?
"Mathieu Momy" <email@example.com> wrote in message
>I just upgraded to version 8.0 from 7.5 and everytime I post a batch I get
>this error The stored procedure glpBatc...Error Message #29
I am using Outlook 2003 on Windows XP. I cannot send or
receive email. The error message is:
Task "Hotmail: Folder:Inbox Synchronizing
headers. 'reported error (0x800CCCF4): "An unknown error
has occurred. Please save any existing work and restart
...Word has encountered a problem
I get this message the first time I open a file in Word after Windows startup
using File/Open. If I restart Word it works OK and I don't see the error
again during that computer session.
The error does not occur if I open a file in Word using Recent Documents or
by double clicking on a file in Explorer. It only occurs on the first
I have tried the following:
- resetting the normal.dotm file
- turning of Microsoft Security Essentials
- running winword.exe as Administrator
The text of the error message is as follows - interesting that it sa...Dsum returns #Error
I created a report based on a query that uses Dsum function. This query runs
well in the server where I created it. But when I ran it in a different PC,
it gave me #error on the query result on the field that uses DSum. I compared
reference files used on both server and the PC and they were the same. Is
there any specific dll I need to add to the PC to make it work? I have to
modify it to sum(iif()) to make it work now.
>I created a report based on a query that uses Dsum function. This query runs
>well in the server where I created it. But w...Error on creating new attribute
I am trying to simply create a new attribute in MSCRM using the tools
provided in the app (Settings->Customization->Customize Entities->Account),
and it fails with the oh-so-helpful message "An error has occurred, contact
your system administrator". I checked the windows event logs, nothing. I also
tried to enable debug tracing in MSCRM but that didn't tell me much either.
Has anyone seen this before and know how to fix it?
I tried creating attributes for several different entities, different types,
different names, etc. but no joy.
Thanks in advance fo...Project error
In the Progress Billing entry screen I am getting this error: "Error has been
detected in retention fee and/or recievables account : changes can not be
How do i fix this?
...Sending error #4
I'm getting a sending reported error 0x800ccc69
The tricky thing is that there is nothing in my outbox.
What is it trying to send?
Make sure your are running the latest virus protection
and spyware removal program.
>I'm getting a sending reported error 0x800ccc69
>The tricky thing is that there is nothing in my outbox.
>What is it trying to send?
...Error Messages #2
Hi I hope you can help...
I am using vlookup functions and as we know if it can't find a value i
returns a cell value of #N/A.
However the result of the lookup is used to calculate another part o
the worksheet. So if there is an error #N/A I want it to appear in th
spreadsheet either as a blank cell or as a value of 0.
Is this possible
Message posted from http://www.ExcelForum.com
> Hi I hope you can help...
> I am using vlookup functions and as we know if it can't find a value
> it returns a cell value...Report Services Error on Client -- but reports work on the server
When I try to run reports on a client a get reporting error.
But when I am on Remote Desktop to the CRM server, all reports work.
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Note: SQL Report Services is installed on a different server than SQL...Serialize error
I have a CTypedPtrArray m_ListNames. I input names and with serialize I save
those names to disk. It all works fine until I try to save my document after
I have either deleted one of the objects in mListNames or I delete and object
in m_ListNames and I then SetAt(same_index) a new object in m_ListNames. I
have put breakpoints in the program and found that I get an error at run time
when it reaches serialize objects of m_ListNames. Is there code that I am
forgetting to add or is there an error in the way that I am deleting objects
Just code error. ...Error opening email.
After installing office 2003, everything was great,
untill I had to close and re-open outlook. now,
everytime I try to open an email, it says something to
effect of that there is not enough memory, close
someother programs and try again. This is after a fresh
reboot, no programs running, and 1 gig of memory on the
...Index/Match ... Excel has encountered an Error
Excel2003 WorkBook with many INDEX/MATCH Formulas ...
Issue ... When I attempt to write a new INDEX/MATCH Formula I am having a
problem with Excel each time I attempt to enter the "M":
=Index(myrange,m ... at this point I receive pop-up stating I have an
"Identify" conflict & I need to select a Cell to use ... Seems no matter what
I do at this point I receive the Error message "Excel has encountered a
problem & needs close".
Above said, my work around has been to copy/paste an INDEX/MATCH formula
from a different cell & then to edit ...Incremental number error
[This is a re-post. Accidentally sent to wrong group]
My form creates an incremental number for a job sheet when a tick box is
checked and this is stored in the underlying table. Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.[JobSheetCheck] = True Then
Me.[JobSheetNumber] = Nz(DMax("[JobSheetNumber]", "[Events]"), 49999) + 1
The JobSheetNumber field is locked and, once ticked, the tick box is locked
so that neither can be deleted.
The problem I have is that if any changes are made to any other field on the
form, when you re-ent...Error message #15
When I leave Money it states "The exception Floating-
point overflow occured in the application @ location".
Any idea what this means. Is it a problem I should be
In microsoft.public.money, donna wrote:
>When I leave Money it states "The exception Floating-
>point overflow occured in the application @ location".
>Any idea what this means. Is it a problem I should be
What program are you using?
...Change name direction
How do I change the name John Smith to *Smith, John*
Message posted from http://www.ExcelForum.com
have a look at
="*"&MID(A1,FIND(" ",A1)+1,255)&", "&LEFT(A1,FIND(" ",A1)-
>How do I change the name John Smith to *Smith, John* ?
>Message posted from http://www.ExcelForum.com/
...How can I generate a user friendly error message when validating XML against a schema?
When validating xml against a schema, the most frequent error I get is
something like "The 'FOO' attribute has an invalid value according to its
data type. An
error occurred at , (25, 913)". That error message is not very user
friendly, so I'd like to extract the data in the failing node along with its
parent node data, and show that to the user.
Do you know a way to do this? I don't think there's any other information
about the error position than the line number and position.
Yes, line number and position is the only information that you have to...Subsystem Spooler has encountered problems
The last couple of days my Outlook has been completely
frozen - nothing gets in and nothing goes out, and it's
impossible to close it down (see Colin's email about
having to use taskmanager to close it) - when I open it
up, the above error message appears:
"Windows Messaging Subsystem Spooler has encountered a
problem and needs to close."
Please someone help!!
...Outlook 2000 Error Message #4
When I attempt to open my inbox I get the following error
Unable to expand the folder. The set of folders could not
be opened. The Exchange Server has detected that you are
using an old copy of your OST file. Please delete your
OST file and create a new one from the server.
Do a search on your C:\ drive for *.ost, rename
outlook.ost to outlook.001. When you open Outlook, a new
*.ost file will be created.
>When I attempt to open my inbox I get the following error
>Unable to expand the folder. The set of folders could not
>...Blank Distribution Accounts
Was wondering if any of you came across this problem in
GP. Have a client who was able to post transactions from
AP with NO account distributions. The system did not give
them any errors in the subledger. When they tried to post
the batches in GL, that's when they received errors about
the missing distribution accounts. When they drill back
on the AP transactions, the amounts are there but the
accounts are all blank.
Any ideas? The client is on GP 7.5.
...Reserved error (-1524); there is no message for this error.
I am trying to run a pretty simple select query in Access 2007, and I
keep getting the error message "Reserved error (-1524); there is no
message for this error." There are no linked tables in the database -
the design of the database is very simple.
I should also note that I ran the "compact and repair database" tool
and I am still getting the same error message.
I don't think I'm using any reserved words...Here is the SQL:
SELECT E_CURRENT_DATA.Prefix, E_CURRENT_DATA.LastName,
E_CURRENT_DATA.FirstName, E_CURRENT_DATA.Address, E_CURRENT_DATA.City,
E_CURRENT_DATA...Sa Login Error
Recently on our test machine the password for sa was rest in the db. Now
when I am trying to connect to my CRM application it is giving me an error,
which in event viewer is :
Event Type: Error
Event Source: RLSERVICE
Event Category: None
Event ID: 0
Time: 11:47:46 AM
Start: Login failed for user 'sa'.
How can this be resolved?
...sent items doesn't show name of addressee, just sender
Under my hotmail account in Sent Items the addressee name always shows my
name, not the person to whom the email was sent. What's wrong?
Dick from NJ
> Outlook 2007
> Under my hotmail account in Sent Items the addressee name always shows my
> name, not the person to whom the email was sent. What's wrong?
There is no Addressee field. There are From and To fields depending on what
fields you choose to display (depends on which view you choose or how you
have customized it).
In OL2003 to customize the view, right-click on t...