Cheers,
Excel can not handle 6 millions of rows, so I guess you want Excel to return only the rows that match the criteria you specify.
I suppose what you want is something like following:
1. All zip code records are unique
2. You enter a value in the first cell (zip code)
3.In another cell...
Hi,
Is there any possibility to have an Outlook Express rule run during certaing period of time, for example from 8 P.M. to 8 A.M.?
I need this rule to be on and off automatically, i.e. without manual adjustment, depending on period of day.
Thanks in advance
Hi all.
I have problem when exporting CR 8.5.
Reports are generated and stored at SQL Server 2000 DB which resides at Windows Server 2003.
When users try to export data to Excel, everything works fine, but we also have a number of users accessing application and reports through terminal...
Hi, David
Check if "Unread messages in this folder" instead of "Messages" was chosen. If so, messages are visible while unread. Upon reading they are hidden, since filter is applied.
Choose "Messages".
Option is available as a drop-down list on toolbar.
We have .mdb created in Access 2002, at comp. running 2000.
When trying to run .mdb file on computer running XP SP-2, Office 2003, we receive message: "The expression Got Focus you entered as the event property setting produced the following error: A problem occred while (command) was...
Yes, it was about Office 2003 critical update!
I have followed your link and installed Office 2003 Critical Update: KB828041. After installation, everything worked fine.
Thank you very much!
Hi to all,
A user has created a .ppt file in PPoint 2000 on Windows 2000 Pro. After we have transfered the file to another computers running XP Pro with Office 2003 Pro, we received an error "PowerPoint can't read (FileName)".
File can be opened normally at computer of origin.
There are no...
Hi,
You could link an excel file/sheet within an existing Access DB. Then, make a query connecting access tables with excel sheet - if possible.
However, excel part will become a part of access DB, and - therefore - you will access it through a single data source.
Regards,
Hi,
If you want to upgrade, you have to install outlook separately.
If you want to do it all together, than do not upgrade, first de-install an old version than make full installation of the new version.
Hope this helps
Hi,
I have had the same problem and got solution from here. What I wanted was a script to run a macro (search&replace) against several .doc files.
Create folder "c:\convert" (or whatever name you want), and put (copy) all .doc files that you want to replace items into.
In Word, create macro...
Just one thing more:
I think that Excel does not calculate values correctly if there are more than 55 formulas on a sheet. Just for case, check your formula results randomly.
Regards,
Your both were of great help. It works fine for now. For future modificiations I will have to do something myself, not to bother you guys.
Thanks a lot once again!
Hi guys,
Sorry for my misbehaviour, but I am new here. Also, English is not my mother language.
Anyway, solution that I have found is like this:
***************
Dim i, objWord
Dim aryDocs(99)
aryDocs(1) = "c:\doc1"
aryDocs(2) = "c:\doc2"
aryDocs(3) = "c:\doc3"
' making an array of documents...
Greetings, snotmare!
You were of great help!
I hope it is not too much if I ask you for just one thing more:
Could you add some code into script that you have already provided? What I need:
It would be perfect if I didn't have to enter names of the files in the script individually, but just...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.