All macros failing part way through with different error messages
All the macros I have in various workbooks are failing - usually part-way
through - with different error messages each time. When I check the debugger
and try to edit the text, there seems no reason why there should be a
problem. The macro has so far stopped on instructions to :
- open a workbook
- select a worksheet
- paste a column in a different place
Several times the macro has just stopped running without completing and
without showing an error message.
I cannot run a host of urgent daily reports without using the macros. Please
NO way to help unless you tell us exactly...converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...Twist Data?...
I've got the following in a dataset:
19 30 1200 FI FI 20030906 36
19 30 1324 FI FI 20030906 36
and I want the following result:
19 30 1200, 1324 FI FI 20030906 26
Any guess on how to do this?
Not quite clear:
The data is arranged in columns, I assume
It looks as if both items in the same column are the same, you want just one
item, otherwise the one in the top row first, then the one from the bottom row.
But what about the last 36s that should yield 26? Typo?
Does the dataset have more columns or more rows or both? And how big is it?...moving payables data from open to history
A client says that someone imported data about a year or two ago into Great
Plains from their AS400.
Many payables documents that were imported should have been coded during the
import as open, instead of history. The client knows that she can take care
of this herself within two hours, by simply turning off the posting to the GL
and entering and posting the payables documents to move them to history.
But, she is wondering if there is a quick and easy way to do this on the
I'm familiar with the open and history payables tables within GP. And, I
know through a T...How do I convert a word table into an excel document?
I have managed to get the info accross no problem but the formatting is all
over the place. For instance - 07/10 meaning July 2010 is appearing as 07/Oct
despite me going into format cells custom then enter mm/yy which has always
You can't use it like that regardless of formatting, you need to put in the
whole date or else Excel will always assume the current year so any real
date used for calculations needs to be numeric and needs a day, so you can
enter (assuming US date format) 07/01/10 and use a custom format of mm/yy
or if you don't need it for...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <email@example.com> wrote in message
> How can I merge 2 cells without losing data from the other...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Trying to create an Update query based on HR data to find upline V
Hi All, looking for some advice. I have an HR table that contains employee
information but does not contain management chain info. Basically i am trying
to determine who the employees upline VP is. The fields i have to work with
are [Employee Name], [Manager Name] and [Job Title]. I figure the logic would
be to check the employees' manager and if the manager is a VP (based on job
title), return the manager's name to a field called [VP]. If the manager is
not a VP then check that manager's manager, so on and so forth until a VP is
Any ideas would be much appr...Transformation of data into columns
I have the data from a flattened spreadsheet in a table in the
f1 f2 f3
period to: Scheme1 Scheme2
31/01/2005 Net Gross
28/02/2005 Net Gross
31/03/2005 Net Gross
30/04/2005 Net Gross
31/05/2005 Net Gross
30/06/2005 Net Gross
31/0...How can I sort duplicate text data in excel?
I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
After selecting your data go to filter Advanced filter and check "Unique
You can even copy it to another area all uniques entries if you want to ...
"TinaScheu" <TinaScheu@discussions.microsoft.com> wrote in message
>I have a large list of noames that I need to make sure that none of them
>...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...Publishing Layout and tables
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to copy and paste text from one cell of a table to another cell in the same table. The document is in Publishing Layout. The paste command deletes the text in the destination cell and then places a big empty text box on top of the table. I do dozens of these documents that are primarily tables and graphics. Previously I used Publisher on my old PC. Should I go back, or can this be done in Word for the mac?
On 2010.01.29 8:44 AM, in article 59bb1ce2.-1@webcrossing.JaKIaxP2ac0,
"Toni_T@officefor...Data Validation List not showing
I'm using Excel 2003. My data validation lists have stopped working on one
sheet in my workbook. It is working on all other sheets.
I have googled the problem and found the following advice:
1. Make sure freeze panes is off.... check.
2. Select "Show All" under Tools->Options->View->Objects ... check.
The problem remains. Any ideas?
"Stopped working" doesn't do much to describe your problem. When you select
one of the "stopped working" Data Validation cells, do you see the drop-down
arrow to the right of the cell? When you select t...help with dynamic tables
This is a bit complicated to explain but I'll try my best. In columns A, B,
C I have different drop down lists. Column A has Store1, Store2, Store3,
etc. Column B has Dept1, Dept2, Dep3, etc. Column C has ProductA, ProductB,
ProductC. As of right now, these lists are not dependent on each other, I
can choose anything from any list regardless of the previous category. Also,
the length of these lists is undefined, meaning I will constantly be adding
to them in sequential rows below. And then columns D and beyond have data
such as Sales, Profits, # of items, etc.
What I...Is there any way to...
Hey there, New to excel and trying to figure out how to set up a formula
that would let me use one Column (C) to decide whether or not a value in
the same row but in column b gets used in a =Sum function.
Basically I have a list of items in column A, Their prices in column B
and a Total in Column D for all the prices. Now, since some of the
things in column A are packages of several items at a lower price then
the items individually the only way to get just the value with the
packaged deals is to edit the =Sum function to skip over the cells with
the individual items prices ( least as ...Querying multiple records in two tables
Hi, in my database I have tables for users (UserID, UserName),
projects (ProjectID, Project Name), and qualifications (QualID,
QualName). I have join tables for users_qualifications (UserID,
QualID), and projects_qualifications. (ProjectID, QualID).
What I need to do is run a query for a project to show which users
have the exact matching qualificiations.
Users can have many qualifications, projects can require many
qualifications, users may only work on a project if the qualifications
required/held match exactly.
Assuming that ProjID, and QualID are numeric, the following sho...Any FREAKIN' way to import DBX files into Outlook 2003
Importing via Outlook | Import from another Program or File
Importing via Outlook | Import Internet Mail and Addresses
Exporting from Outlook Express
Tried Many, many times...
Can Microsucks make this any more complicated...
It's a FREAKIN' DBX file collection
NO - No other Application has it Open.
YES - The Files ARE there
YES - the Internet Account IS there
Yes - I've wasted more of my time IMPORTING into Outlook Express in
VISTA just to RE-EXPORT back to Outlook. What a bunch of freakin'
Another 2 hours wasted - because one Microsoft applica...Adding extra data options
Is there a way to customize CRM to allow for adding another heading? I would
like to add a second field similar to topic and would like to call it type.
Can you add extra data fileds and types in CRM 3.0?
You can add extra data fields to an entity. Go to entities customization at
> Is there a way to customize CRM to allow for adding another heading? I would
> like to add a second field similar to topic and would like to call it type.
> Can you add extra data ...Is there a way to sort a column without invoking a macro?
I am trying to get a feel for some probabilistic properties. For
example, I am trying to look at the statistics of the intervals between
randomly occurring pulses. I have no problem getting a column of
uniformly distributed pulse times, but they are unsorted, Every time I
recalculate with cmd-=, I get a new unsorted set of pulse times because
of the use of the RAND function.
Is there a way of taking this unsorted column and pasting it into
another colun that would be sorted without invoking a macro?
To simplify and be more specific consider the following.
1. In A1:A100 I have a set...Excel pivot table #2
i encountered an error in my pivot table.
i created an olap cube using the analysis manager.
the cube displays the correct data of my measures but on my
pivot report, it displays #N/A....
i need help to fix this one... thanks.... =)
...Using "fixed" decimal place function data for charts
Is there a way to graph data which utilizes the "fixed" function for decimal
places? When I try this it will not graph, as the data has become text or
something - even though I've selected number in the cell formats.
If you've fixed the number of digits using only number formats, the values remain
numeric, and they should chart just fine. This means selecting the range, going to
the Formatting menu and selecting Cells, and on the Number tab, selecting Number in
the category list, and setting a number of digits.
I'm not familiar with a "fixed function". I...Tables in 2007
What are the advantages to converting a list to a table in 2007? Why does
the table have a name?
I did read in help that you can post a 2007 table to sharpoint services.
What does that mean?
Go to the excel help and type Tables then open the one that says Demo:
Organize your data by using an Excel table, and then in How to do it, click
on Overview of Excel Tables
if this helps please click yes, thanks
> What are the advantages to converting a list to a table in 2007? Why does
> the table have a name?
> I did read...Easy way to copy fields?
I have made a lot of customizations to the Leads form by
adding a lot of fields. Now I want to add most of those
fields to the Contacts form so that when I promote a Lead
the info carries forward. Is there an easy way to copy
and then link these fields or do I have to manually
create them all all over again as Contact fields and then
You need to create the exact same fields in contacts then create mappings
betweek leads and contacts in the deployment manager-schema manager.
Have a look at the tool and see if it makes sense. As always I recommend you
test this out on your tes...Deleting a Batch from company DB table SY00500
This is a multi-part message in MIME format.
Is there a way to see all the TRX in a Batch saved in SY00500.
Also, what if we delete a batch in SY00500 will there be any other place =
to look for; besides this? I had a batch sitting here for a long time =
and there were few (3) trxs ( Sales Credits) in it as well.
I wonder if I could retrieve those one by one and then delete them as =
well as these belong to a fiscal period which is closed plus we...Does table size make a difference in how well Access protects data
I am having a problem that has been going on for several weeks now. I am
slowly trying to figure it out. the problem is that Access 2003 keeps
deleting records after they are entered. Quick view of database: running
Access 2k3 back end and frontends, 12 machines access the DB at any one time,
mixture of Win2k Pro and Win XP pro all patches and service packs installed
for all OS's as well as Access 2k3. Running Client/server set up controlled
by Small Business Server 2k3. database resides on a machine running XP Pro.
when new orders are entered into the system, the DB will tell the d...