Problems saving a worksheet with Links
Does anyone know how I can resolve this issue ... I have a directory which
contains 129 worksheets which have links to external data (in a Master
Spreadsheet) -- I need to copy these files into a New Directory, but kee the
Master Spreadsheet (which they are linked to) in the original location. If
I do a simple Cut & Past, the Reference Link to the Master Spreadsheet gets
moved to the New Directory (where the file does not exist), but if I open
the worksheet (in the original directory/location) and Save As to the New
Directory, the worksheet saved in the New Directory maintains its link t...Setting series values on Excel Chart
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as i...Passing data from one form to another
Hello I have a form called frmMaindB and it has 5 text boxes on it
(txtEmployeeTime, txtDTRegular, txtDTReason1, txtDTReason2, txtDTMaintenance)
when I double click on the text box it opens up a pop up form named
frm_DecimalConversion. On this form I have two text boxes one box I enter
data into and the other calculates or converts the data to a decimal. The box
that converts the data is called txtDecimal. Then I have a close button which
I want to use to close the pop up form and insert the data into the text box
I double clicked in to get the pop up or (frm_DecimalConversion). I have r...data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields
called [ContactFirstname] and [ContactLastName]from my table
There are however some customers for whom I do not have names and therefore
instead I would like Sir/Madam to appear in the field in the form
I think I have seen this done somewhere using ELSE? but can't find it
Any help/ideas gratefully received
Perhaps something like this:
Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam")
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access use...links in emails
When I try to open a link included in an email nothing
This problem can be caused by several different things. Do you receive an error message when you click on a hyperlink, or does nothing happen at all? Can you use hyperlinks in other programs,
such as Word?
Please have a look at the following Knowledge Base articles to see if these resolve your problem.
OLEXP: Internet Shortcuts in Outlook Express Do Not Start Web Browser
You can access this article by clicking on the link below.
257464.K...Pivot Table Question #15
Love pivot tables but i have a question, the table is set up as so
Month Pallet# BoxesPur BoxesSold Price Frt Gross
Jan 1 5 1.0
..3 Formula Formula
2 5 2.0
3 10 3
Jan Total 10 10 6.0
So, the problem is in the Jan Total row, is there a way...Timestamp value of GINA window presentation
I am currently troubleshooting slow logon times for a client with computer
infrastructure spread across the globe. Before I start invesagating I want to
create a baseline for logon times.
I have modified the clients logon script to record when it starts and when
it ends. I am using the computers tick count to record how long the computer
has been on, but realize that there is a space of time between the user
authenicating to the computer (control-alt-delete) and when the logon script
starts, if the customer turns his computer on and then leave for an extended
period of time I ...Intermittent display
Hi, recently i encountered this problem on my PC. When i press the ON button, the monitor shows the normal starting up image for only 1 second and then it went black. Then, because my computer has a CPU FAN error (probably because the starting speed of my fan is a little slow), it would beep 3times and prompt me to press F1. During this time, the image would appear on the monitor for 1sec and then, becomes black again. Then, as it loads and enters window, it will flash yet again and i can see the cursor of my mouse at the center of the screen for that 1 second.
Everything is running normall...display name #2
i have this problem: when i send a mail massage from an application by
exchange 2003, in outlook i see the e-mail address (xx@mydomain .com) and
not display name (Customer Care)
how can i resolve it?
An application should allow you to specify display name for sender. Does it
send via SMTP or MAPI?
> i have this problem: when i send a mail massage from an application by
> exchange 2003, in outlook i see the e-mail address (xx@mydomain .com) and
> not display name (Customer Care)
> how can i resolve it?
Please re...how to query my web site from VBA and return a value to VBA
From VBA I would like send a value to my web site, and have it return
a value. I've learned how to use FollowHyperlink to send a value to
an ASP script, but how can the ASP script send a value back to VBA??
You can use xmlhttp to make a request to your web page:
Private Function WebResponse(sURL As String) As String
Dim XmlHttpRequest As Object
Se...Help ! formatting data to text
I am creating data in an Excel spreadsheet. I then want to get that data
into a simple text email. I have some problems and questions...
1) how do I get the columns of data to line up evenly when I copy the data
to email text ? Keep in mind I need to be in simple text format, not HTML
or rich text.
Every time I do this, all columns become chaos and are unreadable.
2) Is there a simple way to automate the creation of an email from an excel
file ? this is less important to me.
Thanks in advance
#1. I think it may have to do with what email client you use, too.
I copy and ...How can I stop charts from refreshing when changing source data?
My problem is, that I am working with a lot of data and when I change some of
the ranges all charts in my view refreshes and it takes much time. My pc is
aP4 3GHz, 2GB RAM so that should not be the bottleneck. Is there any way to
force the charts not to update all the time?
...Assign values for one column to another.
I have in column T certain numbers and texts that that I require to assign a
value to as below, in the adjacent column. Again any pointers would be much
Well, imagine that two-column table occupies cells Y1:Z20. Put this
formula in U1:
and copy down.
Hope this helps.
On Oct 14, 4:26=A0pm, Celticshadow
>...how do I remove fx from the function line, can't enter data
I have the fx displayed just under my toolbar, and I can't enter or change
data in any of the cells in the file. I can't get the red X, the Green check
mark, or the black = sign to appear. There are very few areas that are not
"greyed out" under the headings at the top. This situation applies to all of
the excel files on this computer. I have Excel 2000. Please help.
Can you move the cursor around anywhere in the spreadsheet?
> I have the fx displayed just under my toolbar, and I can't enter or change
> data in any of the c...Excel formulation to automate values
I have a little problem on arranging a small multi-worksheet excel here.
Let me explain in a short way then give some details on it.
I am trying to make an offers recordsheet which has two worksheets in it. One
for products(and their base prices) and an offer sheet. I would like to use
a bit dynamic data here. So when I type the name of the product excel would
give me the price from other worksheet.
Prices worksheet is something like:
1 Product BasePrice
2 mouse 5
3 keyboard 8
And the ...How to obtain enumerated attribute declarations from a DTD using MSXML & VB?
I have a VB (VB6, not .NET) application that reads an XML file (using MSXML
v3.2 parser); the XML file contains a reference to an external DTD.
The DTD has numerous enumerated attribute declarations like so:
MyAttribute (One | Two | Three) "One"
The VB code needs to generate dynamic pick-list for all the attributes that
appear in the DTD as part of a data-entry application; each dynamically
created pick list should contain all the allowable values for the attribute
as defined by the DTD (and presented in some kind of multiple choice control
like a comb...how do i recover data in publisher
i have been entering addresses to set up a mail merge. i cllicked the "ok"
in the window and lost all data . can i recover it
Look in a folder in My Documents named "My Data Sources". Publisher data is
saved as .mdb(Access) file.
Did you try selecting "Edit Address List" in the Mailings and Catalog menu
"dee" <firstname.lastname@example.org> wrote in message
>i have been entering addresses to set up a mail merge. i cllicked ...Excel not displaying German characters correctly.
This is a real puzzler. Has our entire office and IT
We have two machines (M1 / M2) which are equal spec/
operating system, applications, versions, etc...
The only difference that we can see between the two
machines is that one (M1) has Internet Explorer encoding
set to "UTF-8" with "Automatic" selected.
The other (M2) has "Western European ISO" with no automatic
Now, when the machines log into a web application and
choose to download a German Excel file, M1 and M2 get the
file correctly if they have their encoding settings...Outlook 2003 not displaying multipart/mixed messages properly
This is a multi-part message in MIME format.
I know that Outlook is known for having problems displaying =
multipart/mixed messages but this is just weird.
I am using Outlook 2003 with a POP email account and occasionally with =
an email that has been exchanged a few times already and I will send out =
a reply and when the person replies back to me what they wrote no longer =
appears in the email. I basically get back a copy of the email I sent =...Using subtotals as single data entries
Sorry about the subject--I couldn't figure out how to describe it
I have a large file (16,000 records) of amounts billed by roughly
10,000 service providers. A number of these providers have multiple
office locations, so each record is unique to a specific office
location. In other words, a provider who billed from 3 different
office locations will have 3 entries. Each provider has a unique
provider ID number, which stays the same regardless of which office
location he is billing from.
I want to be able to subtotal the amount billed by each provider for
all their office locations...How can I keep track of when (date and time) data is entered into.
I am trying to create a spreadsheet for a high school class. I need to be
able to track when a student has entered data into specific cells of the
spreadsheet. Any ideas?
In the code behind the worksheet, enter (eg)
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(1, 1).Value = Now()
This will enter in Cell A1 the date and time at which any entry is made in
If you need the location of the time-stamp to vary according to which cell
is changed then you can test the value of Target and vary the destination
Return email address is n...How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
This is driving me ABSOLUTELY NUTS!
How can I keep the rows & columns of data that I am copying and pasting
off a website (my own in this case!), into a spreadsheet... WITHOUT
taking all the data formatting?
If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep
columns (something that doesnt happen if I paste out of FireFox, fwiw).
But it pastes with all the formatting & URLs etc - which I DONT WANT!
OK, I can save as .CSV, close, 2 warnings, and re-open but when done
REPEATEDLY this is a damned nuicance!
ship w...Retrieving sorted data from same table.
I am working on a table (mentioned below) I am looking for a query
which can get me the data according to the =93id=94 column with respect to
The condition is that I have to get three consecutive entries which
have speed > 60
Below is the sample table with data on which I have to retrieve the
data on above condition.
The output i need can be as given below
DVXC002 12/10/09 0:12 96
DVXC002 12/10/09 18:40 89
DVXC002 12/10/09 19:43 65
DVXC005 12/10/09 11:56 69
DVXC005 12/10/09 15:26 62
DVXC005 12/10/09 17:35 85
Need your help urgently....Thanks in advan...Relationshiprole attribute
I were not able to find the attribute that stores the relationshiprole
between two records of the entities contacts, accounts and opportunities.
Help me out if anyone can.....
'Relationship Role' is the list of Relationship Types that can be created,
editable through the Administration area.
'Customer Relationship' is the name for the instances of the Relationships
created through the Account, Contact or Opportunity Forms.
Unfortunately whilst you can find both in the Customisation area, neither
entity type can be modified.
Kind Regards, Pa...Import directory data into Excel 2003
I have over 1000 media files that I would like to extract information
from and put into an Excel spreadsheet.
Using Explorer, I have defined the fields I would like to see, such as
title, duration, comment etc. Now, I need to import this data into
So far, I've not been able to find a way to do this. Can someone offer
some suggestions please?
www.myoldcontacts.com - Tell your friends to tell their friends
www.sysadmininc.com - Consultancy, Service, Sales, Networking...
www.british-expats.com - Connect with British Expats World Wide