How do I create a sample in Excel?
I am trying to create a sample, needing every 20th record out of around 3000
You need a VBA procedure.
Dim RowNdx As Long
Dim DestRng As Range
Set DestRng = Worksheets("Sheet2").Range("A1")
For RowNdx = 1 To 3000 Step 20
Set DestRng = DestRng(2, 1)
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Mary" <Mary@discussions.microsoft.com> wrote in message
news:ADE0AD7F-B459-41AE-8B2...How to import messages from an OLD OE 5 ?
1) I have an old IE 5 inbox file, which I had saved as (let us
say) in directory 1 (Inbox.dbx in directory 1)
2) Then , some months ago I went on the re install OE 5 - which had
/ has its own Inbox.dbx ( say in Directory 2)
3) Now when I move to Outlook 2003, I am given an option to
import from IE5 , which recognizes only mail from (2) above -
since the second OE 5 must be the one in the registry
How do I import messages from the old OE 5 - in this e.g. from
Directory 1 ??
***How do I import from any other OE Inox.dbx file ??***
Start OE and create a new ...Can't find file from Windows 7 on XP
I saved a word document on my flash drive from Windows 7. I do not have a
working printer so I am at the library trying to print it out but I cannot
find the file. Is this because I am on a diffferent OS? I am on XP now. I
should be able to pull up any file I was told regardless of the OS.
Assuming that the computers at the library have a version of Word that can
read the file, you should be able to print it.
Microsoft Word MVP
"mosakitty" <firstname.lastname@example.org> wrote in message
Could anyone help me out, I am trying to convert excel column, into a
database (as shown below)
Substance Misuse Service
Telephone: 01466 794433
7 Castle Street, Huntly, Huntly, AB54 8BP
Open: Monday - Friday: 9am - 5pm
(2 ROW GAP)
Substance Misuse Service
Telephone: 01467 620660
8 North Street, Inverurie, AB51 4QR
Open: Monday - Friday: 9am - 5pm
(2 ROW GAP...THOUSANDS OF RECORDS ETC)
I need to fill column B with the name of the organisation, Column C
with the telephone number Column D with the address (more on which in a
minute, and column E with the Details........No Data on Form Open
I have the following code on a cmdButton
Dim strwhere As String
strwhere = "[tbl_Reports].[FltPhase] = '" & Me![cboPhase] & "'"
DoCmd.OpenForm "frm_MainView", acNormal, , strwhere
DoCmd.Close acForm, "frm_SearchPhase"
I would like to display a message "No data qualifies" and not open the form.
Not sure what the If statement should read.
Teach me to fish! Thanks for the help.
you can check recordset count on form's open event, and cancel it:
if Me.Recordset.RecordCount =0 then
Canc...Reports not opening
The reports created in a MS Access database are not opening. Also the icon to
open a new report in design view is not working either. I think it something
related to the settings, but I can quite figure it out.
I tried to put the security level in Low but it did not work.Any help is
This is almost always due to either not having a default printer defined in
the Windows Control Panel or an old printer driver.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
...Option Assignments in Money Plus Delux
I do option trading as part of my investment activities. I can record the
purchase and sale of options (either call or put, short or long), which is
fine. However, I do not find a way to handle assignments resulting from being
short in call or put options. Need help on this issue, thanks.
In microsoft.public.money, Durai wrote:
>I do option trading as part of my investment activities. I can record the
>purchase and sale of options (either call or put, short or long), which is
>fine. However, I do not find a way to handle assignments resulting from being
>short in call or ...Can macro/userform run depending on HOW workbook is opened?
I'd like to show a userform (and/or run a macro) when I open my
Template Wizard database workbook...but NOT have it run when Excel
opens it in the background to copy new records or update existing
ones...any way to do this?
If you put your code to show the form in Auto_open() (in a general module), then
that'll run when the workbook is opened manually.
If you open the workbook via code, it won't run (unless you run it explicitly,
see RunAutoMacros in VBA's help for more info).
Alternatively, you could put your code behind ThisWorkbook (workbook_open).
This code will run...Hidden Columns in Excel Become Visible
There are some hidden columns in a Excel file.
When I open that excel file using below code and then perform some
operations on Excel file and then save the file back and view it, all the
original hidden columns are also being shown.
I do not want the original hidden columns to be visible.
_objExcel = CreateObject("Excel.Application")
_objExcel.displayalerts = False
_objBook = _objExcel.Workbooks.Open(Application.StartupPath & "\" &
_objWorksheets = _objBook.Worksheets
During th...in Outlook2007 inbox and calander opens simultaneously
When i open Outlook 2007 Client first it opens inbox and also seperate
window for calander simultaneously.
One more issue is that subject line comes in message box
nits <email@example.com> wrote:
> When i open Outlook 2007 Client first it opens inbox and also seperate
> window for calander simultaneously.
Close the Calendar window first and then when you close the Inbox window,
use File>Exit. Outlook should remember you had only one window open when
you close and reopen only that window.
> One more issue is that subject line comes in mes...Custom Reports Using MS Access?
Ran across a thread where Glen Adams suggested using MS
Access to create custom reports instead of Crystal
Reports. But Glenn never said where to point Access to
obtain the needed information to create the reports.
Glenn, if you are watching can you give us some more info
on how to use Access to create a report?
I'm not Glen...
I think you would use ODBC... to connect to the RMS database. Then use
Access to connect via ODBC...
"Dan" <firstname.lastname@example.org> wrote in message
&g...Excel not opening
When I double click Excell icon from the desktop, it opens excell without
the default new sheet. when I double click any excell file from explorer,
then excell and the file opens normally.
Why excell is behaving like this? Pls help.
Look at the icon properties and remove the switches such as "/e" or
"/embedded" after "Excel.exe".
> When I double click Excell icon from the desktop, it opens excell without
> the default new sheet. when I double click any excell file from explorer,
> then exce...Excel Writeback functionality with SSAS
I am working on Excel 2010 writeback functionality with SSAS.
Writeback functionality works when the cube is of small size.
Writeback functionality fails when the cube is of have size say 50lakh
I get an error as
Data cannot be retrieved from external data source.
Error Message written by the external data source
Server: The operation has been cancelled.
...Opening a query with a filter in Access 2007
Since under Access 2007 reports can no longer be exported to Excel, I'm
attempting to open the query that the report is based on so that I can
export the query to Excel. I'm wondering, though, about the best way to open
the query since I need to apply a filter. It was easy enough to do in the
OpenReport call by using the WhereCondition parameter, but OpenQuery has no
such parameter. What is the best way to filter a query through code?
A fairly simple workaround is to save the query you want to use for
exporting. Then write its SQL property before you do t...Problem with Huge PST File
When I went to start up Outlook 2003, I got a message that my PST file was
not closed properly last time. Outlook went through it's process. Now, my
PST file is 823MB, even though when I do a folder size on it within outlook,
it says the PST file shou be about 10MB.
Does anyone have some suggestions?
Are you checking the .pst file size from the root of your personal folders?
If you search your hard drive for the .pst file, what does Windows report as
the file size?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Sw...Excel 2002 post-service pack 3 hotfix package
Hello, does anyone know where I can get hold of the Excel
2002 post-service pack 3 hotfix package May 6 2004 please?
You have to contact MS like it says in the MSKB article.
"Noel" <email@example.com> wrote in message
| Hello, does anyone know where I can get hold of the Excel
| 2002 post-service pack 3 hotfix package May 6 2004 please?
| Thanks, Noel.
...money 2005 crashes every time I try to open an account
This happens with only one account I have. Its a checking account
with online banking at keybank. Other online features work fine.
Whenever I try to open the account I get an error message the money
must be restarted. I have tried using the salvage utility and it does
not find anything wrong. I have also tried reinstalling money. I
still get the same error.
My guess is that there is something wrong with the "data" in that
Has anyone else had a similar problem? Any ideas of what to try so
that I can fix this. Its somewhat urgent in that I can't send any of
my onli...pst Rebuild / Import Not Working
I have reinstalled office along with Outlook (2003), and then went to import
my contacts, etc from my previous *.pst file. Now when I open a new mail
message window and click on the "To" button to invoke the contacts list, I
get "The address list could not be displayed. The contacts folder associated
with this list could not be opened; it may have been moved or deleted, or
you do not have permissions."
Please advise as I have never had this problem before when I have imported
my info...thank you for any assistance.
Try using the following steps:
ht...Excel wont let me take an old workbook & save as to make a new 1
For some reason excel will not let me do a save as on an old workbook to make
a copy it just stops responding?....Rik
Did you just update windows?
"Rik" <Rik@discussions.microsoft.com> wrote in message
> For some reason excel will not let me do a save as on an old workbook to
> a copy it just stops responding?....Rik
...Excel 2010 05-14-10
Hi I have excel 2003 Professional. THis summer we are getting Microsoft 2010
and I am concerned regarding all the add in and macros and reports I have
created. Will I be able to transfer all my macros, add ins and files to
I found with 2007 and 2003 that I finished up with 2 "Personal" files which
made life confusing when I wanted to Unhide the one that applied to the Excel
version I was using. I needed to keep both versions because I had contacts
who had one or the other version. I also found that 2003 no longer opened a
blank file au...Failure to open data files in Access 2000 on a XP machine
I had a Win98 machine on which I successfully opened and ran several datbase
files in Access 2000.
I now have a Win XP machine and after loading Office 2000 Premium on it I
cannot open imported/exported data files from my old PC.
It is driving my nuts. I feel I have tried everything but am probably
missing something easy.
When I try to repair the programme it is coming up with an error message for
4 .dll files (msolap, msmdcube, msmdgdrv and msolapui), it says failed to
...Other Program Windows Keep Opening
I don't know how to remedy this problem.
One of the computers in our office tends to open other program windows
at random. Do you know what might cause this to happen.
It seems to have an eradic cursor.
Thanks for any suggestions you can make.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Tools Option General Delete anythign in the box labeled Alternative startup
"Fran" <Fran.firstname.lastname@example.org> wrote in message
news:Fra...XML cannot be opened, try again, opens?
Greetings all, my first post to microsoft.public.excel.
I have created about 30 xml spreadsheets. To create the sheets I
saved a workbook as XML. I removed the "ss:ExpandedRowCount=".
Choppped the XML file into a header & footer & my application supplies
from <row> to </row> in the middle.
Most of the files load okay but about 1 in ten comes up with a 'Cannot
open XML' message from Office Assistant.
The thing is, I go back to File Explorer, press enter to load the same
file & it loads just fine into Excel.
Im running Excel 2003 (126.96.36.19968) SP2 o...I get a file in use message telling me that the file is locked ?
This is a one user computer and the file is not being used. The box
containing the error message says "FILE IN USE". If I reboot I can get into
the file once only before having the same error message. I have tried saving
the file under a different file name but that file acts the same. I have
checked permisions and that is not the problem either .....HELP!
...Opening Publisher #4
I work for a company that has got a load of lisenced office disks
One of them is publisher, I have installed this before and never had any problems
I recently had to format my PC, and when I tried to install publisher ( which worked fine ), then run it ( this is where I had the problem ), it is asking for a product key. I have never had to put a product key in before so why is it asking now
It is only asking for the product key when you run the program. Not when you install it
The company hasn't got a product key for this disk, but we have got one for office XP. (Publisher i...