Import sales orders with configured items through econnect
Has anyone tried to get sales orders with configured items into Great Plains
through econnect. I cannot find a schema for configured item details in
econnect. Please post if anyone knows how to handle this issue and has done
it so far. Thank you in advance.
...How do I shrink an xlsx file after cutting a big data worksheet?
I deleted an Excel 2007 worksheet that contained lots of data (approx. 40% of
initial spreadsheet size). It resaved to the disk at its previous disk size.
What do you do to save the file in its new, smaller size, i.e. compress it?
I'm new to Excel 2007, previously using Excel XP, so I figure there is some
option to check/uncheck to make this work. I just haven't found it yet.
Thanks for the pointers.
If you deleted a worksheet itself the file size will be smaller.
If you simply cut or cleared the contents of a worksheet then Excel thinks
those cleared cells are still bein...Excel opening multiple files by itself HELP please
Suddenly Escel 2003 has decided to open jpg doc etc etc files by itself
when excel is launched repaired uninstalled and reinstalled stilll same
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
Excel will try to open any files it finds in either the XLSTART folder or
"Alternate startup file location" or "at startup, open files in". This could
be the source of your problem.
First thing I would try is to start Excel in Safe Mode so you bypass an...One resource file per CDialog or VSS solution
Is there any way that each Dialog has their own resource file ?
I need that because I'm working on a big project having many dialog.
Actually we are 4 programmers building interfaces. To share code we are
using Visual Source Safe. The only problem is that we can't works on
interface design at same time because of Resource ID conflict !
Is someone having a solution ?
On Aug 28, 3:19=A0pm, Erakis <Era...@discussions.microsoft.com> wrote:
> Is there any way that each Dialog has their own resource file ?
> I need that because I&...Import Wizard settings
I'm importing comma delimited files into excel. I would like to set the
import wizard settings so that it is always "delimited" (rather than "fixed
width") and "comma" (rather than "tab"). Is there a way to do this?
***This message has been scanned for viruses by Norton Utilities ***
You could record a macro while you do it once and choose the settings
you require for each stage. Then in future you only need to run the
I think Dave Peterson gave a skeleton outline a few day's ago in
response to a similar req...Preferences
If I do the following:
TOOLS > OPTIONS > Click the Preferences TBB > Click JOURNAL OPTIONS under
It then says: Automatically Record These Items
Then it list MS Word, MS Excel, etc.
If I check all these off does it mean that they are saved into the .pst file
so that if I restore after backup everything will be there?
DNS SYSTEMS LIMITED
What this means is that outlook will remember the link and store the
date it was created, modified, etc. As for the file being apart...Quickbooks Import of Items
we are upgrading from QB2002
running all inventory inside QB books
What have people found?
Is it better to use RMS to do the Physical after importing the Items to RMS
(and then Journal the $$ difference)
or do a Physical with the existing books and then Import to RMS?
FYI after this we are starting/linking RMS to a new set of books in QB2004
Do the QB first then import you are still going to have to do a lot of work
in RMS anyway so fixing the qty's won't be a problem. Problems with QB 2004
as I have heard is with the interface to the Chart of accounts.
"ParkRanger" <...How do I keep from printing extra lines on a file in Excel
I am trying to print a file with out printing the extra lines that appear at
the end. One of my files prints without the extra lines; the other one
prints extra lines. I can't figure out the difference in the 2 files
Have yo set the print range?
"Verle" <Verle@discussions.microsoft.com> wrote in message
> I am trying to print a file with out printing the extra lines that appear
> the end. One of my files prints without the extra lines; the other one
> prints extra lines. I can't figure out the...Backup Excel file
I want to take backup of a file every time. I am using - save as - tools -
general option - always create back up. The backup file is in the same
location but I want to put it in a different folder. What should I do, kindly
Jan Karel Pieterse's has an addin called AutoSafe (note spelling).
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them...Questions on importing data from websites
I have created a table in Excel. In one column are hyperlinks to the
balance sheet of a company in the S&P 500. Let's assume that this
column is in A. A1 is titled "Name of Company", and A2 reads "AAPL",
which is the symbol for Apple. When you click on A2, the browser
would have you on http://finance.yahoo.com/q/bs?s=AAPL+Balance+Sheet&annual
Now, suppose that I want to parse some very specific data from this
site. Specifically, I'd like to parse the Total Stockholder Equity,
which happens to be 47,791,000.
How do I go about doing this?
Regarding ...how to download excel help preferably in the form of chm?
how to download excel help preferably in the form of chm?
It comes as a chm file on your Excel CD.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"kang" <firstname.lastname@example.org> wrote in message
> how to download excel help preferably in the form of chm?
...REading Publisher files burned to a CD
Copy the files to your hard drive. Publisher doesn't do well with removable media.
Mary Sauer MS MVP
"Bruno Ottavi" <email@example.com> wrote in message
...get Date() Formatting
I have the following script running on the OnLoad event of my opportunity form
dt = new Date(); //gets today's date
if ((crmForm.FormType == 1) || (crmForm.FormType == 5))
if (crmForm.all.new_date != null)
crmForm.all.new_date.DataValue = dt;
The issue is that unless I change the date on the field it stores the value
as mm/dd/yyyy + time. We are using this field for reporting purpose via pivot
tables and the time is really causing issues.
If anyone has any ideas I'd appreciate it. I have tried putting script on
the onSave event but didn't seem t...WHERE ARE MY SPECIAL PREFERENCES SAVED IN EXCEL?
Could someone please tell me where my special setup choices and option
choices are saved in Excel? Should my boot drive crash, it would be good to
have a backup of such in the event of the need to reinstall. Thank you very
much for any help in this matter.
Excel.xlb (Toolbar customisations)
Personal.xls (Macros that operate on any workbook), (Only there if you have
saved macros to them)
Book.xlt (Template to establish settings for new workbooks (Only exists is
created, not normal
Sheet.xlt (Template to establish settings for worksheets added to
workbooks), (Only exists if c...importing text from Word 2007 to publisher 2007
When I insert a word 2007 document into a text box in publisher 2007, the
bullets and numbering do not tranfer in. they simply disappear. anyone know
how to make this work? it worked fine in previous versions.
You are right. It is another 2007 bug...
I have a document that has numbering & bullets, the first set of numbers came
across, the others and the bulleted list did not. When I copy/paste some, but
not all, the bullets paste.
High-light the text, format the list from the format menu.
Mary Sauer MSFT MVP
news://msn...Converting numbers to date format from csv files
I have data submitted as csv files which i have saved as excel spreadsheets.
Problem is the dates in the csv file are 20020105 etc, I need to convert
these to date format in order for me to calculate between sets of dates. All
I get is ###### (it's not a case of the column being too short). Tearing my
Select the column and use Data / Text to Columns. One of the dialog box
steps allows you to tell Excel that the value is a date - and how it is laid
out. I think it's the third box in and it says something like Column Data
Format in the top right corner.
I use Publisher 2000 (Windows XP) and the majority of my work is booklets,
posters, ID cards, Name Tags, Postcards on a HP 970Cse.
I'm about to replace the 970 with a HP 1200 dnt. Anyone using this printer
and do you consider it a good choice?
Don Schmidt wrote:
|| I use Publisher 2000 (Windows XP) and the majority of my work is
|| booklets, posters, ID cards, Name Tags, Postcards on a HP 970Cse.
|| I'm about to replace the 970 with a HP 1200 dnt. Anyone using this
|| printer and do you consider it a good choice?
Well Don, I had a ni...Attached zip is transformed in dat file
I have a SBS 2003 server instaled,and configured, and when i send a message
with a zip file attached, when the file arrives at the destination is not a
zip file but a dat file.
If i send the message by "hotmail" the file arrive fine.
can someone help me ?
Tanks in advance
Please check the following settings since they could override the message
format you choose in Outlook.
Open Exchange System Manager and go to Global Settings > Internet Message
Format > right click on Default and select Properties. Go to second tab
(Message Format). Should be M...File Attachment #3
When a file is sent as an attachment in Outlook Express, it appears in the
"Attach" field right below the "Subject" field when the message is viewed in
the "Sent Items" folder by the sender or in the "In Box" by the recipient. .
In Outlook, when composing a message, a file is attached, the file shows in
the "Attach" field (as in Outlook Express). But when the message is viewed
in the "Sent Items" folder by the sender or viewed by the recipient in the
"In Box", the attached file shows at the bottom of the message!?
Is ther...Cell formats kep changing to "Time"
I am always changing my cell formats in one spreadsheet from time to
general. I have to keep doing this over and over. Why does my
spreadsheet keep changing cells' format to "Time"? I can't figure out
why this is happening...
Have you got any behind the scenes VBA code that formats the workboo/worksheet
to Time when you open the workbook or activate the sheet?
Do you get the macro warning when opening the workbook?
Alt + F11 to open Visual Basic Editor.
Look through your workbook Sheets and Thisworkbook modules for code.
Gord Dibben MS Excel MVP
On Thu, 13 Dec 2007...Importing an excel.csv file into outlook
I've just set up Outlook to send/receive my yahoo
emails. I'm trying to import the contacts and addresses
from my yahoo address book. When exporting from yahoo,
my address book was saved as an excel file with comma
separated values. in order to import it into outlook,
i've been getting messages saying the relevant program is
not there and i would have to install it or download it.
It said something about frontpage, but i'm not sure what
i need to do...HELP!
...how do i save the graphics out of a publisher file
I need to copy all the pictures used in a publisher document and save them
into a separate file. How do I do this? / Is this possible?
Do you mean a separate Publisher file or in a folder you will create the for
The former is a simple copy/paste operation. You can have many instances of
Publisher open at one time.
The latter, depending on your version, simply drag the images you used from the
source and put them into the new folder.
Mary Sauer MSFT MVP
"KC" <KC@discussions.micros...Importing from previous Outlook
I just changed the disk drive in my computer.
I went through the Export and Import routine.
However, when I imported to the new drive, the only thing that
survived was all my email.
Neither the rules nor the accounts were imported.
Did I miss a step?
The rules & accounts are saved by the Office Save My Settings wizard not by
an Outlook export.
"Mary Hartman" <MaryHartman@TVLand.wish> wrote in message
> I just changed the disk drive in my computer.
> I went through the Export and Import r...Moving database files from single Mail server to a CCR setup.
I would like to setup a CCR environment with two new blades. Currently, I
have my databases on a single blade. I would like to create the cluster and
then import the databases from the "older" hardware. Is there an easy way to
You will need to create the CCR cluster and move the mailboxes to this
"Maav" <firstname.lastname@example.org> wrote in message
>I would like to setup a CCR environment with two new blades. Currently, I
> have my databases on a single blade. I ...Import wizard...
When I try to run the import wizard I get
"Microsoft Outlook cannot be started. Verify that Outlook is installed on
it does'nt matter if I select import contact or leads.
could someone point me in the right direction ?
MS CRM 1.0
I had the same issue when I first tried this. The importing of contacts or
leads required an Active X control to be installed and used during the
process. You need change the setting in Internet Explorer security to
prompt for or Enable ActiveX. To do this:
Go to the Internet Explorer Tools menu, point to Internet Option...