linking to other worksheets and updating a file
This is what I want to do,
Sheet 1 contains a list of surnames in column 1, forenames in column 2 along
with other data in columns 3, 4, .......
Sheet 2 contains a list of suranmes, forenames some of which are the same as
in sheet 1.
I want to add a column in sheet 1 which takes the name of the person from
sheet 1, looks up that name in sheet 2 and chooses data from one of the
columns in sheet 2 and places that data back into the correct row and new
column in sheet 1.
A further complication might be that there are duplicate surnames in the
first sheet so need to look up the forename...Access Developer
We are about to enroll on a mini project and as part of the rollout new
machines are to be installed. Some user's have an application called Access
Developer. I would like to know if we install Access 2003 Pro would that be
sufficient for them e to continue with their Access Development?
Could anyone answer or point me in the right direction.
I assume that ACCESS Developer is the developer version of ACCESS 2002, but
you'll need to confirm that.
If it is, this version of ACCESS allows the owner to create runtime versions
of ACCESS applications, wh...Q/VB.NET: Append data to XML file without loading complete file?
Can someone give me an example how to append data without having to
load the complete XML file.
Is this possible?
"Jonathan Buckland" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Can someone give me an example how to append data without having to
> load the complete XML file.
The ability to append data to an XML file without processing the entire
document greatly depends on the structure of the XML, and the place
in the file where you want to append.
As a simple example to get started with, co...Corrupt File Not Opening
Hi there I am in desperate need of help. I have been working on a
project for school using Microsoft Project. Today when I tried opening
my file I had these message pop up.
I have tried opening a new document to Insert the Project, but that
still did not work.
|Filename: Error.JPG |
-...Dialog prompt during opening of file
Need help here, How can I make my dialog to be run during opening of
markuss's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34966
View this thread: http://www.excelforum.com/showthread.php?threadid=553962
markuss, use a workbook open event, like this
Private Sub Workbook_Open()
MsgBox "You just opened this workbook"
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 ...Is there any standard way to sort a disk file?
I have used the standard template library quite a bit, and std::sort has been
very useful. Now I have reached the point where my memory requirements are
exceeded. Is there some standard way to sort a binary file with a specifically
The only thing that I could think of would be to std::sort portions of this file
in memory, and then later manually merge these sorted portions together using a
home brewed merge sort . Does anyone have any better ideas?
* Peter Olcott:
> [bad cross-posting]
Please don't cross-post to [clc++] and Microsoft-specific groups.
>...Mulitple Excel Files
Ok, I have not iced that if you are editing a cell you can not open a
second file. We are using Office XP Pro. Every once in a while we are having
problems opening a second file even if we are not currently in a cell on the
first file. Any help in this would be greatly appreciated.
One other person is having problems getting Excel to open. It takes about a
minute for it to open, any ideas?
while you're editing a cell Excel' just can't open a file.
"Matt Donohue" <email@example.com> sch...application development
I am designing a downloadable tutorial application
I am using visual studio 6.0 and i have created a client application to navigate through data pages, at the moment just the client framework exists, what is the best and quickest way to create graphic pages with text that can be viewed through an active doc container app i.e Explorer.There will be a lot of pages
Does anyone agree that java is the best method for this.? Or are there any alternatives
The application will be placed on the server and downloaded, files will be downloaded a batch at a time and viewed as local pages. I also need to ...iTechArt-Custom Software Development and Offshore outsourcing Company
iTechArt Group - Custom Software Development and Offshore outsourcing
Offshore custom software development company iTechArt - Web site and
Content Management Solutions development, CMS consulting: Ektron,
Drupal and DotNetNuke
iTechArt Group provides high quality custom software development
services and offshore software development. On December 2006, iTechArt
Group became an authorized Microsoft Certified Partner. This means
that our company has been recognized by Microsoft for our vast
expertise and authorized to custom software development; provide IT
ser...file level permission
I have created a e-service using publisher 2003 and i am publishing my
presentations to a server on the internet. The server asks for a
administrative user credentials before publsihing it on the server. I do not
want to give administrative permission to all users?, How to do solve this.
For you to publish your site your host does need to limit access to you the
customer otherwise your site would be hacked. But your site is viewable by
all once you publish it.
Be sure to use our web forum at microsoft.public.publisher.webdesign in the
future for your web issues.
David Ba...sharing one .pst file on 2 networked computers
what i want to do is have 2 computers on a network share the same
outlook.pst file - i have opened the outlook data file on the second
computer but it cant be open on both computers at the same time - is there a
way to do this.
i hope you understand what im trying to do :)
MS does not support the use of a pst over a network - it will likely lead to
OL requires exclusive use of the pst.
"chris" <firstname.lastname@example.org> wrote in message
> what i want to do is have 2 computers on a network share the same
> ...symbol definition
what does the following symbol stand for ^
is used in calculations to elevate a number for example
2^3=8 means you have to multiply number two 3 times 2x2x2
> what does the following symbol stand for ^
Simply, it means "to the power of"
eg 2^3 is 2 to the power of 3, ie 2x2x2 = 8
> what does the following symbol stand for ^
...Combining Publisher Files
Using Office 2003
I have a 12 page booklet (fileone.pub) and a separate 10 page booklet
(filetwo.pub) which I would like to combine into a new document
(filethree.pub). I think I am looking for something similar to Word's
Insert File option, but cannot seem to find this in Publisher.
Copy and paste.
MVP Microsoft [Publisher]
"BK" <email@example.com> wrote in message
> Using Office 2003
> I have a 12 page booklet (fileone.pub) and a separate 10 page booklet
> (filetw...Opening Multiple Files
How can I create a shorcut on my desk top that will open
several spreadsheets located in various directories
Create a .bat file somewhere.
Inside that .bat file, you'll have as many lines as you need that look like:
start "c:\my documents\excel\book1.xls"
start "c:\my documents\excel\book2.xls"
Then put a shortcut on the desktop that points at this .bat file.
(You could actually just put the .bat file itself on the desktop. But if you
delete the shortcut, you can just create a new shortcut. If you delete the .bat
file, you'll have to create that (...Add-on Developers...
Does anybody know of any other add-on developers for Microsoft RMS, OTHER
than RetailRealm, New West Technologies, ADI, EVT, RITE and NBE Solutions?
I am trying to "crack" into some new retail markets. I have had some GOOD
success. For example, for those who wish to, eGolf has an AWESOME Golf Suite
that works like a charm. Talk about a beautiful addition for RMS.
Talk to you all soon
We focus on the needs of independent specialty retailers including bike,
outdoor, sport specialty, and hardgoods verticals. Visit:
"Tony Cormack...Delete Office Files
I'm trying to clean out my saved files from Office 2002. There are several
files from Word and Excel that I cannot delete, move, rename or open. If I
try to open the file I get an "access is denied" message. "The file may be
read only or encrypted." If I try to delete the file I get a "cannot delete
- access is denied" message. "The disk may be full, write-protected, or the
file may be in use in another program." Most of these files were created by
someone else and sent to me as attachments to email messages.
How can I permanently...Edit Outlook2002 nk2 (autocomplete) file
Anyone knows how to edit outlook2002 nk2 (autocomplete)
file? Tkanks a lot!
select the item with the arrow keys and press Del. is the only way to edit
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Outlook Tips: http://www.outlook-tips.net/
http://www.poremsky.com - http://www.cdolive.com
Expert Zone http://www.microsoft.com/windowsxp/expertzone
Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
"DC" <dcc7...copy doument names from a file into excel
I'm trying to copy 171 document names only into an excel spread sheet so that
I can then talk about the status of each document I don't seem to be able to
copy this information and then paste it into excel
I've tried Ctrl shift ctrl C ctrl V and nothing happens I've tried the Copy
function from the drop down menu but the paste option doesn't appear in excel
Have you tried pasting them into a blank word document and then ctrl v ing
the text from the word document into excel? that might work, other than that
i'm not sure how.
"Lizndc&quo...UI Developer // Bay Area
Location: Bay Area
Duration: 6 months
Pay rate: 40-45/hr
Front-end Developer Required Skills:
1. capable of estimating development tasks and meeting deadlines
2. great attention to visual detail and user interaction design
3. cross browser development, testing, and debugging for Chrome,
Firefox, IE 7, IE8
4. front web page creation from detailed mockups/comps
9. XML and JSON10. Java 6, JSP, JSTL/EL and Java Servlets
11. Team oriented, great communication skills
Desired Front-end Developer Skills:
1. Familiar with mobile web UIs
2. Familiar with...Is there a developer's edition of RMS?
Please forgive the newbie question, but what do developers use when doing
RMS customization work? RMS is not included in either the MSDN or Microsoft
Action Pack subscriptions, and I didn't see anything on the PartnerSource
site other than the Customization Guide. I'm trying to do some
customization work for a customer/friend, but neither of us have enough in
our budgets for an extra SO + HQ purchase that would only be used for
What alternatives do I have (besides a bigger budget <grin>)?
The Customization guide is the only deve...Unable to open file from publisher 2003 after an error
While working with publisher, suddenly there is an error popping out saying
'an error occured,restart the program'. After restarting, I am unable to open
the file('publisher unable to open the file'). How to open the file again?
How to troubleshoot a damaged publication in Publisher
"waichunko" <firstname.lastname@example.org> wrote in message
> While working with publisher, su...Copying files to disc with pictures
I have tried to copy my publisher files from my hard
drive to a cd but when I open the files from the cd on a
different computer the pictures do not show up. Anyone
know how I copy so that the pictures are included as well?
If the images are linked rather than imbedded, the images will not copy. Otherwise
Publisher does not do well opening from a removable disk. Drag the file to your hard
drive and open again.
Mary Sauer MS MVP
"Brian" <email@example.com...Save workbook with preview in open file dialog box
I am taking an excel course which asks how to save a
workbook so that a preview is available in the 'open
file' dialog box. I can't find or figure out the answer.
This one didn't seem to be in the Help.
File - Properties - Summary tab. Save Preview Picture.
mvpearl omitthisword at verizon period net
"Suzanne" <firstname.lastname@example.org> wrote in message
> I am taking an excel course which asks how to save a
> workbook so ...Working with Zip files!!!
I need to work with Zip files programatically. How can i do this? Are there any API's provided for this
Thanks in Advance
There are a number of libraries, including the gzip library. I bought the pkzip libraries
some years ago. I don't know if winzip has a library product. Be careful of the licensing
restrictions on the gzip library; the usual way this is done is to put it in a DLL, so if
anyone wants the source of your component, you just give them the source for your DLL.
On Thu, 22 Apr 2004 16:01:11 -0700, Srinivas Appana <email@example.com....wmv file and text
Can words display over a running .wmv file on a slide?
Only in version 2010
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> Can words display over a running .wmv file on a slide?
"gg" <firstname.lastname@example.org> wrote in message
> Can words display over a running .wmv file on a slide?
Current retail versions of PowerPoint can not do what you want natively.