I have a csv text file that I want to automatically open with column
the text file is generated from a query to a remote database, so it cannot
contain any code.
pls advise mechanism.
CSV files are just plain ascii text files. They'll never contain code.
So you could have a wrapper workbook that opens the .csv and does your
formatting or you could do it manually.
Igor Lisbaron wrote:
> I have a csv text file that I want to automatically open with column
> the text file is generated from a query to a remote database, so it cannot
> contain ...What does it mean when the computer is 'archiving' automatically
My computer started archiving without my opting to do this? Is this a good
Your computer doesnt Archive, Outlook does
"missprim" <email@example.com> wrote in message
> My computer started archiving without my opting to do this? Is this a
...parameters passed to a macro file.
I have a macro that run from DOS and launching GP, but I need to pass some
parameters like ID Company. Can I do this?
Sorry, you cannot pass parameters to a macro file.
You might find it works better to use a third party tool like Omni Login to
David Musgrave [MSFT]
Senior Development Consultant
MBS Support - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy...Excel thinks a file is already open
Each time I open an Excel file, I get a message saying
that a document with the same name is already open. I
simply press Cancel, and everything is fine.
This happens even when I have just started my computer,
and I am the only user. (This also happens with Word
I have deleted all TMP files and all ~*.* files.
I have used Scandisk and defragmentor.
Look on this page
Regards Ron de Bruin
"Alan" <firstname.lastname@example.org> wrote ...updating your account(constantly)!
updating your account keeps flashing on top right of money 2007, screen
jiggles don't have a clue what to do?
In microsoft.public.money, keeganrob1 wrote:
>updating your account keeps flashing on top right of money 2007, screen
>jiggles don't have a clue what to do?
Tell us more:
Is your operating system XP or Vista?
When you do Help->About.... what is the version?
What is the actual message?
I also am having this problem. New laptop w/Vista pre loaded. Downloaded MS
Money 2007. System seeming locked up as unable to edit any entries or
update/download any b...Why excel close all files when I just want to close one files
I opened several excel files, and now I want to close one file
of the opened file. But when I close one file, all other files are
closed and the whole excel is close. Is there any setting that I need
to change in excel setting? Thanks
There is no setting, but you have to be careful about what X you click on.
If you click on the X at the top (the application window), then you're closing
the application--not just the single workbook.
Yes, excel behaves differently from MSWord.
> Dear all,
> I opened several excel files, and n...Server 2003 R2 Updates Fail
I have a Server 2003 R2 that is able to download the updates from Microsoft
but will not load them onto the server. The updates state that the install
failed for each update. This has caused me to not have this server current
on Windows Updates. Anyone with any possible ways to correct this, please
let me know. Thanks !!
How to troubleshoot Windows Update, Microsoft Update, and Windows Server
Update Services installation issues:
1. See the "Need more help? Tell us what problem you are having" section of
http://support.mic...How do I automatically save an Excel Worksheet?
Anyone know if there is a way to automatically save an Excell Worksheet say
every 5 minutes? I'm not refering to Auto Recovery. I need an actual save.
Download and install the AutoSafe Add-in by Jan Karel Pieterse:
(note: Make sure you download AutoSafe.zip, not AutoSaveVBE.zip)
In article <21FD75DF-E9A1-4B25-83B3-F8CFC0C5C29A@microsoft.com>,
"Tony" <Tony@discussions.microsoft.com> wrote:
> Anyone know if there is a way to automatically save an Excell Worksheet say
> every 5 minutes? I'm not referin...What is wrong with my Select Case?
The following code does not work I do not know why. the number that I am
checking is "0.00338076308652524" which is < 1 but I am not getting the
result which is " less than" in the text box "RF34d" (RF34d =
Private Function NumbertoLetters(numTolet As Integer) As String
Select Case Format(numTolet, "##")
Case Is < 1
NumbertoLetters = " less than"
The forma...reading pane keeps turning on and preview pane keeps turning off
I've been using outlook 2007 for about 6 months and all has been ok until
now. My normal view is to have the reading pane turned off and the preview
pane turned on. however, now things changed all of a sudden. now when ever
I go to the inbox the reading pane is turned on and the preview pane is
turned off. So I go to the view menu and reset the view to what it should
be. if I click on any other folder such as sent items and back to the
inbox, its back to reading pane on and preview pane off. This is the same
behavior for all folders. any ideas how to resolve this?
-- ...ATT00004.txt file coming with attachements
A few people, when sending me attachments, their emails come with an
additional attachement named att00004.txt. When one of them sent a
test message to himself, he didn'treceive this file, but I still seem
I am using Outlook 2003, and he is using Eudora
Thanks a lot,
...update query 01-11-08
I tried to use update query to update data that I didn't have prior to
inputting the rest. I get the data whenever my supervisor can give it
to me which is hours worked. I made a query with the criteria as null
hours. When I change the query to update query the date and employee
id fields ( which is part of the original query field) disappeared. It
only left the worked hours field which I can't update because the date
and employee id field disappears so I don't know who's hours or what
date I am updating.
it's always a good idea to have a backup of your data. You could...Contracts automatically cancelling
We are running Field Service Contract Administration version 9.0. Ever
since upgrading from version 7.5, when we cancel the last or only
contract line on a contract, the system automatically cancels the
entire contract. I am told this was not the case in prior versions.
Anyone know if this is by design now? Any way to keep this from happening?
How do I get a record count afer I filter a column in Excel? Example: I have
a list of 100 names and I filter out those who prefer phone contact versus
e-mail countact. How do I get a count (a number) without manually counting
each record that appears after the filter?
Frances, have a look at subtotals in help, something like this should work,
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2...Listbox Selection
I have a form with a List Box(lst_entry), upon clicking on an entry a
new form (frm_edit) should load up showing the details of the entry
selected in listbox.
In the "On Dbl Click" event I've used the following code;
Private Sub Lst_entry_DblClick(cancel As Integer)
DoCmd.OpenForm "frm_edit", , , "BINPROCESSID = " & lst_entry.Column(0)
" and BINPROCESSDate = " & lst_entry.Column(1)
However I'm getting the following error message every time I dbl
on an item in the list;
Run-time error '3075': Syntax error...How do I modify the menu found under FILE-OPEN?
Marleyb <email@example.com> wrote:
Put your question in the body, not the subject.
Tools>Customize>Commands will allow you to change the menus, but you can't
change anything below Open.
...Open file Slow on Excel 2003
We have upgraded our Office 2000 to 2003 and after the upgrade the response
time to open a file on the network or C drive is slow. Once you have click
on down arrow next to the look in box it takes a few seconds to respond.
All the patches have been loaded. We are running windows XP
...Toolbar for automatic series fill??
I have a customer who swears that in Ofc 2002, there was a toolbar that was
used for automatic fill of alpha and numeric series, i.e. A, B, C and 1, 2,
3, so that he could type A in the first row and B would be entered
automatically when he went to the next row. He has upgraded to Ofc 2003 and
can't find the toolbar, and neither can I. Any ideas?
Perhaps the customer had a custom designed toolbar along with some other VBA,
but AFAIK there is no such default TB in any version of Excel.
There is a Fill>Series dialog box in the Edit menu, but even it will only
work with certain ac...How do you turn off autoformatting?
I am making a spreadsheet that is essentially a record. In one of the
cells, I am entering the old/new values for something as 4/80, which
Excel instantly turns into April-80. I can format the the cell back to
General, but the number that results is not 4/80. And if I go in and
reset it to 4/80 again, the autoformatting kicks in again and the whole
process starts over. While there are plenty of ways I could work around
this, from changing the way I enter the data on up, it has become a
sort of matter of honor now. How the heck do I stop Excel from
overriding everything I enter?
I've got a problem with formatting changes not updating
in linked worksheets...
Simply put, if you have a document that has a linked cell
to another worksheet, the formatting ie...COLORS doesn't
change when you chnge the source document with the linked
Yes, for instance text will be updated... but again, not
formatting like making it BOLD or changing the colors of
Any ideas... I did see a KB article 1009182 regarding a
problem linking WORD with Excel... but not Excel with
Excel and the formatting no holding... it possibly is the
case with Excel ...Automatic control names
I feel stupid asking this question, but I can't find any previous
posts about it.
Is it possibe to set Access 2007 so that the forms wizard will name
the controls properly? The default is to name the control with the
field name of the data source, but it ignores the proper naming
conventions (or at least what I was taught was the convention). A
textbox should be named "txtFirstName", but instead it just names it
"FirstName", which then requires us to have to go through and manually
rename all the controls.
I suppose that a VBA routine can be written, but af...Account register- Automatic Catagories?
I have a question about the account register...just
started using my Money 2002 again. When I download
account activity from my checking account, there is quite
a bit of information already in each trasaction. Then I
try and clean up the month's transactions, and when I
change one transaction, Money automatically updates a
whole bunch (almost all) of others. So, if I change one
transaction payee to "Gas Station," all of the sudden a
bunch of debits from the grocery store become "Gas
Station" purchases as well. Is there some sort of
automatic codin...get the curser to automatically return
How do I get the curser to automatically return to my starting column
(example I’m in A1 and move to C1 enter and the curser will not go back to A2
only up, down, left, right ). Is there a way to set this up so it will return
to your starting point?
Start in A1 then TAB across to C1. When leaving C1 hit ENTER key to drop down
Using this method you will always return to original column and down one row.
Another method is to unprotect columns A to C then protect the worksheet.
TAB will move you across to C then back to A down one row.
Gord Dibben E...Update unbound
This worked yesterday, I opened it this morning and now it
doesn't..... Is there a setting wrong?
Thanks in Advance
Private Sub Trophy_AfterUpdate()
If Check35 = True Then
Trophy.Locked = True
Trophy.Enabled = False
Trophy = Full
Trophy.Locked = False
Trophy.Enabled = True
Trophy = ""
On Fri, 14 Sep 2007 21:39:50 -0700, grubbyr wrote:
> This worked yesterday, I opened it this morning and now it
> doesn't..... Is there a setting wrong?
> Thanks in Advance
> Private Su...Money 2002 Won't Update
My installation of Microsoft Money 2002 Standard Edition (Version 10.0)
running under Windows XP Home SP2 developed a problem with Internet Updates.
The Call Summary message window under Quotes and Exchange Rates reads:
"Money was unable to complete the operation. There is a problem with your
Money installation. Please reinstall Money from your original product
Under Money Updates it reads:
"An unknown error has occurred. Please try the operation again. If problem
persists, reinstall Money from your original product disks"
An update from Wells Fargo Bank is a...