Post to GL vs Post Through GL Files
Ok.....a stupid question here. What exactly is the difference is having the
boxes checked to Post to GL and Post Through GL Files? Is there any problem
with having one vs the other or both of them checked? I would assume that
not having the Post Through GL will require you to post each batch to the GL.
I am surprised that you can have both boxes checked. In that instance, I am
uncertain what would happen. Normally, you would have only one of the boxes
checked. (You could also have none of the boxes checked if you don't want to
post to the GL. For example, you might unmark these s...Duplicate files
I am getting duplicate transactions in my bank accounts.
I will create checks or download info from my bank. The
next time I open money 2004 I will have duplicate
transactions. This happens 3 or 4 times for every
transaction. They will not delete either. I have to mark
them as void to just find out what my balance really is.
When I balance an account, it doesn't even recognize
these transactions as being there, but it does show them.
If anyone has the same problems I would love to hear how
you fixed it or do I have some new virus?
In microsoft.public.money, Frank G wrote:
...CArchive for reading binary files
My application needs to read from binary files. Is a CFile associated
with a CArchive the best way to do this? Or do I just stick to using
The files are supplied by an external application and could have a
large size (say larger than a 100 megs). My application just has to
read from them and process the data.
> Hello all,
> My application needs to read from binary files. Is a CFile associated
> with a CArchive the best way to do this? Or do I just stick to using
> CFile independently?
> The files ar...Error on opening file from taskbar
I am using Excel 2007 with Windows 7 on a ThinkPad X61. When I right-click
the Excel icon on the TaskBar, and then click on any spreadsheet shown in the
list I get the message "There was a problem sending the command to the
program." The same error happens if I click on the same file from a folder
view although I can easily open it via the Excel menus. As I really like this
feature of Windows 7, it's a real annoyance.
Richard I Morris Jr
I'm not sure if this will help you at all, but I suppose it's worth a try:
In Excel 2007, click the Office Button ...Where is the "File" menu?
I am using Excel for Office 2007 and I am trying to include some rows in a
header so I see these rows at the top of every page.
So I google for instructions, and got many hits.
One of the hits instruct me to go to the file menu and then the page setup
menu. Like this:
But I don't even see the File menu.
How can I get the File menu to be visble?
You are looking at instructions for an older version of Excel than you have.
Microsoft got rid of the menu bar in Excel 2007 and replaced it with the
Ribbon... you w...Maximum file size for excel documents?
Does anyone know what the maximum file size for a excell 2000 workbook is?
I'm currently upto 38mb, just need to know how much further I can go.
Lots of data....
> Does anyone know what the maximum file size for a excell 2000
> workbook is? I'm currently upto 38mb, just need to know how much
> further I can go.
> Lots of data....
"Frank Kabel" wrote:
...PST Files #5
I have a freind who uses outlook 2000.
He is currently at about 400megs on the pst file.
He can open outlook, he can read, sort, view and download
more email. But the second he double clicks on an email
to open it to respond..etc. Outlook locks up, window
error message say... dangerously low on system resources.
He is running 98 with the latest patches, 25 gig of free
space on the hdd, and 512megs of ram.
Im of the opinion that its just to large of a pst for the
computer/os to handle. Ive had him clean it up, used to
be 712megs in size. He was okay till about 2 weeks ago.
No idea what ...Hiding worksheets
Someone on one of these NGs was asking recently how to prevent co-workers
from seeing worksheets. I've just discovered (and it wasn't mentioned at
the time) that it is possible in Excel to hide worksheets. It's not
guaranteed that someone with sufficient knowledge will not come along and
unhide the worksheet but it does put it out of sight.
I hope whoever was asking spots this post.
"Bill Ridgeway" wrote:
> Someone on one of these NGs was asking recently how to prevent co-workers
> from seeing worksheets. I...Excel file
I accidentaly replaced a file with a wrong file and then the wrong one was deleted. Is there any hope of me recovering the Excel sheet I replaced??
I think that, in your heart of hearts, you know the answer to this question,
don't you ?
Yes / NO / Don't Know
Have you backed it up recently ? That's your only chance
"Carice" <firstname.lastname@example.org> wrote in message
> I accidentaly replaced a file with a wrong file and then the wrong one was
deleted. Is there any ...Importing accounts and transaction etc. from one money file to another
Is it possible to import accounts, transactions, categories etc. from
one money file to another?
My problem is that I have a money file which is protected with a file
password (not .NET passport though) and I cannot seem to get rid of
it. When trying to use the Password Manager to either assign og
disable .NET Passport services for the given money file I always get
the error message that the sign-in name is not associated with file.
However, a sign-in name has never been associated with the file
because it has only been protected by a single password (like i
earlier version of money).
Now ...How to open 123 files with excel
A client gave me files in Lotus 123. I have Excel 2002. Is there a way to
open these files and convert to excel. The WK4 files he gave me convert but
not the 123 files.
There is no filter that allows Excel to read .123 files. So you have to
convert them to a format Excel can read using 1-2-3 or Conversions Plus from
"Jeff B 813" <Jeff B email@example.com> wrote in message
|A client gave me files in Lotus 123. I have Excel 2002. Is there a way to
| open thes...Money File on Network
I have a wireless network and I have M2005 deluxe on my home computer and
M2005 basic on my laptop. When I try to open the money file on my desktop
computer from my laptop computer, it will not let me open the file. It says
that it is read only and cannot be opened. Does anybody have any ideas on
how to fix this problem??
Make sure with, say, notepad, that you can save a file in the same shared
folder from the client. There are lots of possibilities here. Many of them
have nothing to do with Money.
One other possibility comes to mind: are both machines at the same Money
versi...Open workbook to specific worksheet
Is there a way to have a workbook open to a certain worksheet regardless of
which worksheet was active when the file was saved and clsoed?
Worksheets in workbook - data, budget, analysis, comments
Saved and closed with data worksheet active
On open have budget worksheet active
Dave, you could put some code in the workbook open event like this
Private Sub Workbook_Open()
To put in this macro, from your workbook right-click the workbook's icon and
pick View Code. This icon is to the left of the "File" menu this...Question about how VB6 uses dependincy files
I seem to remember a discussion here about putting ocx and other files in
the program folder instead of in the system folder and that the vb program
would find them there. I was not able to find what I was looking for so
thought that I would ask the experts here, to go over it again. I tried this
once and it did not work and I moved the dependent files to the system
folder, but I may have been trying to do it wrong. :-) Not unusual for me.
1) For instance if I put the sqlite dll in the program folder will the vb
program look for it there first? If so will it load it for db use a...Writing XML File from Dataset
Read many of the posting but still doen't understand the process.
I have a dataset with child records.
I have a specific XML "Account.XSD" format that I need to write this out to.
How do I marry these (2) items to create the output file.
Dim dataSet As DataSet = New DataSet("AccountRecord")
Dim AccountRecord As DataRelation =
data...How to recover data from OL2003 OST file when Exchange Server is no longer available
After Exchange Server (in Windows Small Business Server 2003) is no longer
available, I still have an OST file (created in OL 2003), just under 2 GB in
size. Can one recover the data from this OST file?
Yes, you can get the data out of it. Do you still have the exchange profile
or very recently deleted it? if so, it's a matter of moving the stuff to a
pst. If not, you need a tool - see
http://www.slipstick.com/problems/repair2gbpst.asp for tools that you can
Diane Poremsky [MVP - Outlook]
O...Consolidation of Data from more than one worksheet file
I have my company inventory on 15 different excel 2003 worksheet files. Is
there any way to consolidate those file and reports for each item? I do not
want the Pivot Table way. Because the structure of the worksheets is not
comfortable for that.
Let's get the nomenclature down first
a file is a workbook
a worksheet or tab or sheet is the worksheet in the file.
You need so specify the workbook(s) and also the worksheet(s) within each
for each wb in workbooks
Don Guille...Sending a file from the explorer
When I do a right click with my mouse on a file in the explorer, I can send
it by mail. In farmer times using Outlook Express, this file was directly
sended. Now I have to open my Outlook 2003 and I find the file in my drafts
folder but not really send automatically. What can I do?
Dumb question, but are you clicking the Send button on the message that
appears? It would appear in Drafts only if you created the message but
closed it without sending it.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers...pst file to Lotus Notes
We will be connecting to our Corporate office over a WAN. We are currently
using Exchange Server locally. The Corporate office is using Lotus Notes.
We will be using new computers with Lotus Notes installed, Outlook not
installed. How can we incorporate our outlook pst file into Lotus Notes?
If there is a way to do this, are there instructions available?
Thank you for your help in advance!
...Cannot delete files in my local folders
Can anyone help
...how do I make a 4 page brochure from8 separate existing files?
I have 8 pages for a flier but I can't figure out how to get them to print
sequentially and back to back. They are all Publisher files created
Seems easy but i am wasting alot of time trying to get it to work. Right now
I am having to print each one separately, run them back through to print
another page on the back, etc. Can anyone help?
Insert choices are only for blank pages????
What size are the flyers? If they are letter size, In page setup, select booklet. If
you have a large format printer, setup the printer first for tabloid (11 x 17). Open
your flyer public...Not able to save changes to system settings
I have 3.0 with sample data. My issue is that I'm not able to save any
changes to the system settings. I have SA right. Any idea? Thanks.
This is normally caused by a incorrect SQL Reporting Services setup. Check
that your SRS Server is working, check that srs's url is well configured at
deployment manager. And if it doesn't solve the problem you should read this
> I have 3.0 with sample data. My issue is that I'm not abl...Save Mword Macro?
How do I get a Microsoft Word macro to save for future use in other
Losse's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24813
View this thread: http://www.excelforum.com/showthread.php?threadid=386529
I realize this is normally an Excel forum, but can anyone help me wit
this basic bit of information for Word
Losse's Profile: http://www.excelforum.com/member.php?action=getinfo&...save changes
How can I get excel to stop asking me to save changes when i didn't make any
changes? ver 2003
If the workbook you opened was created in an earlier version of Excel you will
get the "save changes" message.
Save as 2003 version.
You will also get the message if you have used any volatile function(s) in your
Could be a NOW() or TODAY()
List of volatile functions........
Any one or more of these would cause the workbook changes.
Gord Dibben MS Excel MVP
On Wed, 24 Jan 2007 14:41:54 -0...Hided values appears when I'm copying/pasting it to other worksheet
in one worksheet I have some data and there is some colums hided.
When I selecting all that data and pasting to other worksheet, al
these hided colums or rows values appears and I have to hide it again.
Is there possibility to copy/paste in such way, that these hided value
don't appear again?
Thanks in advance
Aivaras_Bakanas's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2518
View this thread: http://www.excelforum.com/showthread.php?threa...