Shared Spreadsheet with out network access...
Thu, 14 Aug 2008 12:18:21 -0700 (PDT)
I am using a shared spreadsheet on our company network. About 4 of
us use this spreadsheet, and it works perfect using the sharing
function in excel. Is there a way to still use the spreadsheet if I
choose to do some work at home, (i.e. no access to the interna
netowork), and be able to merge my changes when ...
|
Concatenate an Area (Range)
Thu, 14 Aug 2008 09:24:01 -0700
Hello,
I like concatenate Cells A1 to A3 by using a range "{=Concatenate(A1:A3)}"
I can obtain a by matrix formula a result as
{"valueA1"."ValueA2"."ValueA3"}, but i can't convert it in a text chain
"valueA1ValueA2ValueA3"
I there is a way by formula of matrix calculation ?
If not could you please giv ...
|
Protection Password (JSF)
Thu, 14 Aug 2008 12:03:14 -0400
Years ago I created a very large spreadsheet, and I haven't used in as many
years. I would like to use it now and it requires a few changes. However, I
cant remember the password to unprotect the cells. Is there a way to remove
it?
Thanks in advance.
Joe
...
|
How to determine xls file's codepage/collation
Thu, 14 Aug 2008 08:11:22 -0700 (PDT)
Hi,
I'm getting "Selected collating sequence not supported by the
operating system" error when reading xls file using:
ConImp = New OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;
" & "data source=" & LoadLocation & "; " & "Extended Properties=Excel
8.0;")
The problem is I'm fairly sure the xls ...
|
Copy & Paste issues with "Quotes"
Thu, 14 Aug 2008 06:34:37 -0700 (PDT)
Hello All -
I'm having an issue when I copy data from my POS software and then
paste it into Excel. I believe the issue revolves around the use of "
in certain fields.
For example, one of the lines that I'm having problems with looks like
this when I copy it to Notepad:
"AVN12223" "Pipe Ext ...
|
Beta testing website
Thu, 14 Aug 2008 05:54:30 -0700 (PDT)
Hi All,
This is a bit off-topic but may be of interest to some
people. I have just found a website that looks interesting. It lets
companies register their products for beta testing, and testers
specify what sort of products that they would like to test.
Sort of a beta testing dating service - M ...
|
Importing PDF files into Excel 2003
Thu, 14 Aug 2008 05:13:01 -0700
How do I import a PDF file into Excel 2003? I know I can convert PDF into a
TXT file and then import data. However, if my PDF file has columns, the text
file looses the columns and only keeps spaces, so I do not get a nice copy in
Excel.
Thanks for your help.
Gerry Verschuuren ...
|
|
|
Cut and paste macro
Thu, 14 Aug 2008 04:17:22 -0700 (PDT)
I need a macro that will cut the data in a specific range of cells in
a column and paste it to the column immediately to the right of the
last column containing data. I have been able to accomplish the cut
and paste bit but it is pasted over the last column of data rather
than being next to it. I can't simply ...
|
Excel: Replace strings with a Matrix formula
Thu, 14 Aug 2008 03:50:50 -0700 (PDT)
Hello NG,
the following sheet:
- In column A are words in German.
- In column B are the translated words in English.
- In C1 is one English clause with only one single German word in it.
ToDo:
I want translate this word in English and write it o D1. But I dont
want to use VBA or more then one cell for the ...
|
Formula to split text and numbers
Thu, 14 Aug 2008 00:41:48 -0700 (PDT)
Hi
I am trying to create a formula to split the content of a cell into
text and numbers but I can't figure out how to do it
Example
TextString 1 4456
Another TextString 23456
Third TextString 3 2245
The formula I am interested in will find the last number after the
space, in the example above I will be ...
|
