Refresh Excel file
After refreshing an Excel file, does the record stay at the one you were
working on or does it go back to the first record of the file?
This doesn't seem like an Excel question. Maybe you could explain what
you're trying to do.
"excel dummy" <excel email@example.com> wrote in message
| After refreshing an Excel file, does the record stay at the one you were
| working on or does it go back to the first record of the file?
...Access 07 much slower than 2000/2003, multi user
three new PC withh access 2007 trial and an exsiting access 2000 mdb on a
Performance is slower but acceptable OK with one user, with additin users
(up to 3) it becomes very slow. record scrolling is slow but the main
problem is adding records.
When typing in the edit boxes it can take > 1 sec for the text to appear,
same database saved in 2002/3 format works with any delay in typing or
Office 07 SP1 installed, and previous versions of the office removed when
Did same tests with linked tables to sql2005, same results.
...Backup on file close
Is there any way to make Publisher create a backup copy of a file as you
close it after making changes to a publication. I sometimes forget to
'save as' when I have revised a publication so when I close the orginal -
which I intended to keep - it gets overwritten. I know it asks if you want to
save changes, but I forget that I haven't actually 'saved as' under a new
Word creates backups - for which I am grateful as I can then open them and
I would suggest doing a Save As when you first start on your revisions
rather than at the end. That way it...Upgrade Publisher 2000 to version 6.0
I'm running Version 5.0 and can't open documents created in 6.0.
...Have free download for Excel for viewing files only.
I have received a file in an email and I cannot view it because I don't have
Excel. PowerPoint has a free download so that you can view a presentation.
If Excel had this same option, people would be able to view a spreadsheet
sent to them for free. If that person wanted to make any changes to the
file, THEN they would need to purchase Excel.
You can download XL viewer from here
Watch for text wrap,
"CJPrevette" <CJPrevette@discussions.microsoft.co...Money 2003 Deluxe
When I go to Reports/Taxes/Tax Software Report I get a summary of what
should be included in the various Federal Tax Forms. Everything looks
reasonable except for the Capital Gains and Losses Money generated when I
bought or sold a stock. It looks like some of the transactions ended up
under Schedule C! Can someone give me a hint on where I have to go to tell
Money how to handle the generated gains and losses? I have been to all the
obvious places like "Catagories" and "Taxes" but I must be missing
something. Thanks in advance.
In microsoft.public.money, Ken wrote:...application.getopenfilename to open a file saved on a server
How do I set the current drive if I wish to us
application.getopenfilename to open a file if the folder I wish to vie
is on a server
Message posted from http://www.ExcelForum.com
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"dovrox >" <<firstname.lastname@example.org> wrote in message
> How do I set the current drive if I wish to use
> application.getopenfilename to open a file if the folder I w...NetBank / Money Setup
I've seen in some older posts that there have been problems connecting
to NetBank via MS Money... I'm having the same problem, and so far,
NetBank support has been no help. Has anyone out there found a
solution to this problem yet?
...Can't create file: FAX.TIF
I keep getting this error message when I try to open faxes that come down
over our server. Here is the entire message.
Can't create file: FAX.TIF. Right click the folder you want to create the
file in, and then click Properties on the shortcut menu to check your
permissions for the folder.
I have checked the properties for the Inbox and for the Office Document
Imaging and all of that is fine.
We were able to open faxes fine, then one day a Smiley bar appeared in
Outlook and then we were not able to open the faxes anymore. Also, I have
removed Outlook and reinstalled. I hav...Passing an Array created in a Function or Subprocedure back to the calling Subprocedure
I want to have a Function or Subprocedure that can create an array with
52 specific values in it. I then want to call this Function or
Subprocedure from a main Subprocedure and be able to access the
contents of the array. Everything can be of type variant for the
purposes of this exercise. Can anybody help, please?
This worked ok for me:
Dim myArr As Variant
Dim iCtr As Long
myArr = BuildArray(myArr)
For iCtr = LBound(myArr) To UBound(myArr)
MsgBox iCtr & ". " & myArr(iCtr)
Function Buil...Attach file in header
MS Access 2007.
I am having users enter and update data in a split form. I would like to
put an Excel Workbook file as an attachment that can be downloaded by users
(so that they could populate that template with many rows of data instead of
manually entering on Access form). I put an attachment field in the header
and attached the file, but that only "stuck" on the record that I was on at
How can I make an external file always available for download?
...puttin money 2004 on a new pc
i bought money 2004 onlline and installed from a download, i want to put the
program on my new pc but seem to have inadvertantly deleted the file. i
have no disc to install from and the tech support at microsoft is just giving
me the runaround. does anyone know where i can get the install file?
> i bought money 2004 onlline and installed from a download, i want to put the
> program on my new pc but seem to have inadvertantly deleted the file. i
> have no disc to install from and the tech support at microsoft is just giving
> me the runaround. d...Converting Publisher Files to PDF Format
When I try to convert Publisher files to PDF format I get a message that says
"The size of the paper you have chosen is too small to show the printer
markings", but when my commercial printing guy takes my same Publisher files
and converts them, it works. What am I doing wrong. I've already talked to
Adobe and they think that my Acrobat Distiller is set up properly. I have
Adobe Acrobat 6.0 Standard, Windows XP Professional, Publisher 2003 and an
IBM desktop with 260 gigabytes of memory
> When I try to convert Publisher files to PDF format I get a mess...Debug Assertion Failed Message in afx.inl at line122 & afshtml.inl file at line 57
I am getting some Debug Assertion Failed in afx.inl at line 122 and in
afxhtml.inl at line 57 Messages on PCs. If i do "Rebuild all" again on
my PC then the code starts working. But it gives "Debug Assertion
Failed message of afx.inl file at line 122" on other PC. And if i do
"Rebuild All" on that second PC then it gives "Debug Assertion Failed
message of afxhtml.inl file at line 57" on my PC. It is a debug build.
If i take the exe and create a installer then also the installer works
on many PCs but gives the message of afx.inl file.
The afx.inl li...Enumerate open file handles of a process
Can someone please tell me how to enumerate all the open handles of a
My objective is to write an application that monitors a process and if
it acquires a handle to a particular file, I want to close that handle
from my monitoring application.
Get Nebbitt's "Undocumented Windows 2000 API"
On Sat, 25 Aug 2007 15:27:37 -0700, RedHawk <email@example.com> wrote:
>Can someone please tell me how to enumerate all the open handles of a
>My objective is to write an application that monitors a process and i...Help! Can't Import Quicken 2001 Deluxe Data into MS Money 2004 Standard
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2004 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Size of files allowed with Outlook 2003
I am having trouble sending large attachments through outlook 2003. Is
there a limit to the size you can send. I have one with about 24mb of info.
It is stuck in the outbox. I saw how to go offline and delete it but I
really don't want to because I scanned it all and don't want to do it again.
How can I get this file to go through?
Windows XP, Outlook 2003
Outlook is not in play here. Your mail provider is.
"Pearl King" <firstname.lastname@example.org> wrote in message
&g...Outlook 2000 will not open-not enough memory
Have Outlook 2000 installed on XP Pro. Has been working
fine, but one day, boom! Will not open. First I was
getting Virtual memory is too low error when opening. I
set virtual memory to let windows determine paging size.
Still got the error. Now today, error when opening
Outlook - There is not enough memory to run this program.
I have uninstalled, reinstalled Outlook 2000. System
restore as of last week when it was working. Nothing has
I have a Dell Dimension 512mb. Has been working fine, but
all of a sudden , nothing.
If anyone has a solution, please email karlaf@jwbur...Cannot download .pdf files in one webpage only
I've a paid subscription to a newspaper and have problems getting in and
downloading subscription via .pdf. Before it used to work fine.
I tried with Mozilla Firefox, Chrome and Internet Explorer. It doesn't work
in any of the two computers at home with any of those browsers. In the
office with office computer it works but at home with office computer it
I thought then it would be a problem with the connection.
Checked first with the Newspaper, then with the Wireless router technical
service and last with the internet provider and everything is fine. ...Saving Outlook Email As Text File Extract
Hello Outlook Group:
I'm normally an Access and Excel VBA programmer, but my client wants me to
scrape the text from a select email address and insert it into an Access memo
Does anyone know how to configure Outlook (VBA approach would be fine) so
that when an email is received in a selected account, the message would also
be extracted to a directory as a text file and then the Outlook message would
be moved to some history folder.
Once the text file exists in a predefined folder , I will just have Access
periodically check the folder for files, grab the text, ...WAV File not downloading properly
I have a application that stores a wav file into the database. I
retrieve the wav file through a web service call that gets the file.
When I try to send the file through the response stream it seems the
file gets changed. If I save the file to disk it works properly.
Here is my latest endeavor
Response.AddHeader("Content-Disposition", "attachment; filename=" +
BinaryWriter bw = new BinaryWriter(Response.OutputStream);
Response.ContentType = ATACUtility.getMim...PST Files #3
This is a multi-part message in MIME format.
I copied my pst files to the server.
The n I upgraded my workstation from Win 98 to Win 2000.
When I try to import my pst file, back to the workstation, it copies =
over, but there is no data...
Can someone tell me what is happening???
Charles L. Ph...Office 2004--what's the 3rd installation CD for?
I just purchased and installed MS Office 2004 on my brand-new Mac Mini.
Everything seems to be working fine, but the installation process only
required two of the three CDs. What's the third installation CD for,
and if I didn't use it, am I missing anything from the installation?
Maybe it's the CD for Virtual PC (if you have the professionnal version of
On 18/11/05 1:43, in article
> I just purchased and installed MS Office 2004 on my brand-new Mac ...Unwanted formating (excel 2000)
We have to import a file (CSV) where data in a column is in "999:99" or
For unknown to me reason the built in logic treats that data as Time
and Excel converts some data in this column into wrong format.
23:25 will stays 23:25
25:00 will be converted into 25:00:00
120:00 will be converted into 120:00:00
When I format column as text
23:25 will be converted into 0.975695
25:00 will be converted into 1.041667
120:00 will be converted into 5
How can I disable this madness?
If you rename your .csv file to .txt, then when you open th...Sharing an excel file onto webserver?
MS Excel 2002 (SP2)
Is it possible to put a spreadsheet up onto a webserver
and have different members of our company (who are
located in different cities[!]) each access the same
Ideally it would lock itself if anyone was trying to
do edit /update the spreadsheet, so as to stop anyone
else from over-writing their content at the same time...
- Is this possible... anyone tried it?!
I have managed to get two PCs *reading* the same
copy of an Excel (2002)...