parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...moving payables data from open to history
A client says that someone imported data about a year or two ago into Great
Plains from their AS400.
Many payables documents that were imported should have been coded during the
import as open, instead of history. The client knows that she can take care
of this herself within two hours, by simply turning off the posting to the GL
and entering and posting the payables documents to move them to history.
But, she is wondering if there is a quick and easy way to do this on the
I'm familiar with the open and history payables tables within GP. And, I
know through a T...Money Central Portfolio #2
My print function has gotten corupted. When I print it flips to WORD / format
and prints in a format that is 4x normal.
I am pretty new to using (or attempting to use) a Macro in a workbook. I am
having trouble following how and what to do to even start the process; ie If
there needs to be a worksheet already in progress or can I start from a new
THEN where to go from there.
Can I have some help in this area? Can some one supply me with a sample
Any help would be greatly appreciated
The best way to get started with macros is to use the Macro
Recorder. Go to the Tools menu, choose Macros, then Record New
Macro. Then, carry out some simple tasks and examine the code
that is produced.
...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <email@example.com> wrote in message
> How can I merge 2 cells without losing data from the other...Statements #2
How are statements sorted? Alphabetically by name or by account number? Does
Any help is appriciated, Deb
Mine are done alphabetically by name.
"Deb" <Deb@discussions.microsoft.com> wrote in message
> How are statements sorted? Alphabetically by name or by account number?
> anybody know?
> Any help is appriciated, Deb
...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email firstname.lastname@example.org ��and
windows2003 + exchange 2003 Server "B" email@example.com user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...RMS Status Codes
Just wondering if anyone has a list of what the RMS Batch.Status codes 0-15
mean? I can't find them defined anywhere. I'm specifically looking at how
to identify Blind Closes so I don't count them in totals until they'e been
There is a Knowledge Base Article that covers the different Batch Status
codes from 0 - 31. Just search for 'batch status codes'
RMS Systems Inc.
"Zim" <Zim@discussions.microsoft.com> wrote in message
news:C72515DB-AD45-4C7D-B8DE-0A18E4A6D0D0@micr...Vb.net 2008 ContextMenuStrip logical error when running code
I have a connectmenustrip item that when clicked runs the following code
Now if the event is called by the button i.e. cmdDeleteingBooking.Click the
linq query returns the appropriate value.
However when called by cntMnuCancelBookingItem.Click is returns 0 even if a
checkbox is of 'TRUE' value.
Debugging shows the code runs exactly the same code (which loops around rows
in a datagridview checking if the checkbox has been checked).
Could someone explain the reasoning why the same code would return different
Private Sub cmdDelete...Excel worksheet with VBE codes don't work elsewhere
Some of my excel worksheets with embedded controls and VBA codes don'
work when I open it on another PC. Is there another way to make i
lazybear's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3519
View this thread: http://www.excelforum.com/showthread.php?threadid=54955
Specifically what problems are you having? Saying "don't work"
means absolutely nothing.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
ww...disable Review toolbar which came up automatically when opening a.
How can I disable the Review Toolbar which comes up automatically when
opening a file?
In the Workbook VBA actions.
The top left hand corner there is an Excel logo, not the one in th
blue program bar, but in the menu bar.
Right Click and select "View Code"
There will be two drop down boxes one that will probably say General
if this has never been entered previously.
Change the box on the right to Workbook.
Then Change the right hand box to "Activate"
Insert the following code
Application.CommandBars("Reviewing").Visible = False
exit the VBA screen and t...Need code snippet to read offline PST file
I have a PST file in my local hard disk and have requirement to read
PST file and parse through all folders and then each message item in
all folders and then segregate them to different folders based on
Please kindly send the code for the above requirement.
Thanks & Regards
You're going to have to write your own code. Do you know anything about
Outlook programming at all? You can start out by looking at information and
code samples at www.outlookcode.com.
[MVP - Outlook]
http://www.slo...SharePoint (WSS) 2007 / Outlook 2007 - Alert
This is a multi-part message in MIME format.
We have setup a SharePoint Server (WSS) 2007 and are using the alerting =
After we changes stuff on WSS, an alert message is generated and sent to =
an email account.
This e-mail account is hosted on an Exchange 2003 server.
When using Outlook 2007 to open the e-mail, we get:
Cannot open this item.
Wenn using OWA the e-mail can be opene fine.
Does somehow have an explanation for th..."the wizard is unable to open your query in datasheet mode, possi
"the wizard is unable to open your query in datasheet mode, possibly because
another user has a source table open in exclusive mode. your query will be
opened in design view"
what this message mean ,and how can i solve it
Please provide more details as to what you are doing when you get the error,
what your database setup is (i.e. split Fe/BE?, multiuser?, version? etc).
Without more information, we can only guess.
>"the wizard is unable to open your query in datasheet mode, possibly because
>another user has a ...Excel 2000 vs. Excel 2002
I am having troubles with a workbook that I created that is havin
I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.
Now I also made a very similar report that works just fine whe
trasferred to excel 2000.
Here are a couple of stats on the workbook that is having problems:
500+ externel links
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting
Message posted from http://ww...Macro
Here is one for you experts - I am a novice
I want to add a macro to a worksheet that will print selected information
held on certain rows of the worksheet.
Once the 'button' has been selected a mesage box will pop up asking the user
to input which row number he/she wishes to print.
On input that number is matched to the corresponding row of the worksheet
and that row is copied (without any formula - just cell values) and pasted
into another worksheet where it is placed into other formats and printed.
Seems like a simple(!!) job - but far to difficult for me to programme
Can an...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...Opening .prn files in XL2000
I am using a software that does not save data/reports in .csv or .xls
formats; only in printed versions. Is there a way to save the printed
report in a file and open the file in XL2000? If there is, how is the print
file produced, where is it saved, etc? A friend suggested setting up a
generic printer but didn't know how to go about it.
You may want to give that other software just one more chance--look under File
and see if there is a SaveAs option. You may find something upon further
But if you want to add a generic printer, I think it'll depend on your version
of win...Sum amount if = 2 value's
I have a spreadsheet of payment types for which I want to sum the tota
amount per type per month
A B C
Type Amount Month
I'm able to get the total amount per type by usin
=SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for eac
type each month
Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????
loscherland's Profile: http://www.excelforum.com/member.ph...Excel pivot table #2
i encountered an error in my pivot table.
i created an olap cube using the analysis manager.
the cube displays the correct data of my measures but on my
pivot report, it displays #N/A....
i need help to fix this one... thanks.... =)
...Trying to open the current db in Access 2010 through Access Basic
I haven't programmed in Access Basic in quite a long time. Through Access
Basic coding, I use to be able to open the current database and then open a
table and walk through each record. Now I can't even open the database.
Does anybody have an example of how to do the following:
1) Open Workspace
2) Open Current Database (assume name is unknown during run time
3) Open specific table
4) Step through each record and access the fields
George C. Derkacs <George C.
>I haven't programmed in Access Basic in quite a lon...Outlook Express 6 Spell Check #2
I am using Outlook Express 6 on Windows XP, and I have a
problem with spell check. When you send an email, it
says "spell check has been haulted, do you want to send
anyway" and if I ask it to spell check, it says an error
has occured in spell check. All my spelling options are
correctly set, so I don't know what the problem is.
Kimberly McNabb <firstname.lastname@example.org> wrote:
> I am using Outlook Express 6 on Windows XP, and I have a
> problem with spell check.
Ask in an Outlook Express newsgroup.
I'm new to Outlook.
I hear of an Outlook database in other threads. Is this synonymous with the
..pst or .ost files people mention?
Does it corrupt often and if so are there tools to repair it?
There's a utility called ScanPST.EXE that will scan and attempt to repair
Yes, typically when a user says Outlook database they're referring to their
"Craig Roberts" <email@example.com> wrote in message
> I'm new to Outlook.
> I hear of an Outlook d...unique with 2 columns
I have 2 columns with duplicates in the first column and no duplicates in the
second. I neeed to only see one value for each in the left and only one of
the accounts from the right.
ie: abc 1234
I would like to see either of the abc with the 1234 or 12345
I would like to see the bcd since it's individual with the 251
I would like to see either of the eft with the 600 or the 607
Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the...