How can I change the column order using VBA
I have written code that appends data to a table. Occasionally, I need to
add more columns. To do this I am using a bubble sort to compare with my
existing table weather i already have the column or not. Because of this, I
make my new table in alphabetical order, but I would like to be able to
reorder the columns into something other than alphabetical. Is there a column
order property for tables? Any suggestions?
> I have written code that appends data to a table. Occasionally, I need to
> add more columns. To do this I am using a bubble sort...Personal workbook does not save when it changes
I am using XL 2002. I created a Personal workbook, put it in the XL
startup folder, and hid it. But when I add a macro to it, I am not
prompted to save it when I shut down XL. Why?
When you start Excel and click on Windows - Unhide, does the Personal.xls
file appear? Or is Unhide grayed out? I don't know how you created that
file but you should let Excel create it and place it. To create the file,
click on Tools - Macro - Record New Macro. When it asks where to place the
macro, specify Personal.xls. I know it doesn't exist. Click OK. That's
...Changing right side scrollbar bar row number box?
In excel when you click and hold the right hand scroll bar and move up and
down the worksheet it displays the row number you are on. Is there any way
to change that to pick up the value within column a instead?
I don't think so.
In fact, when you upgrade to xl2k, those numbers disappear and the worksheet
will scroll live--you'll see the worksheet change right before your eyes.
(It works that way in xl2002. I _think_ xl2k is the first with this newer
> In excel when you click and hold the righ...preventing a workbook being changed? (not as simple as it sounds!)
i am trying to prevent anyone being able to make changes to a workboo
and something strange is happening.
Ive put a password on the workbook by going to tools/options/securit
and adding a "password to modify".
now in theory this should prevent anyone ever being able to change m
workbook without knowing that password.
however ive had the workbook put onto the intranet, clicking the lin
to it opens it in IE. if i make some changes in the workbook and the
click the back button in IE, i get prompted to save the workbook due t
changes. I can then click save and save the workbook to m...Change Calender Start date
I want to add this to my code
If [ckb7] = -1
Me!tbDateFrom = DateSerial(Year(Date), Month(Date) - 1, 7)
Is this possible?.....Thanks for any Help............Bob
Private Sub Form_Open(Cancel As Integer)
Select Case Me.OpenArgs
Me.Caption = "Owner Statement"
tbDateFrom.value = Format("01-" & Month(Now) & "-" & Year(Now),
tbDateTo.value = Format(Now, "dd-mmm-yyyy")
...Pages keep changing position
I recently had Microsoft Office 2007 installed on my computer at work, and am
having awful problems with Publisher 2007.
I produce a multi-page newsletter which I originally created in Publisher
2000 and have imported into 2007. However, when I am in the middle of working
on it, the pages seem to move around by themselves, so that page 1 may end up
on page 7 and page 3 suddenly appear on the front cover! This makes me
reluctant to save even the tiniest change in case other pages have moved
spontaneously while I was working. Nothing in particular seems to trigger
Has anyb...Date changing to current date when doc reopened
When I draft a letter and save it and then reopen it later, the date always
changes to the current date, even when I do not use the auto insert date. i
erase the date and put it in manually but it still happens.
sounds like you used teh insert date feature of Word. This inserts a current
field, which will update every time opened. Try replacing the current date
field with teh Create date field. HTH
> When I draft a letter and save it and then reopen it later, the date always
> changes to the current date, even when I ...Print preview in Publisher 2003 changes doc from landscape to portrait
A friend of mine is attempting to print out an 11x17 double-sided flyer in
landscape mode on her XP Pro system. The 2-year-old template she uses
prints correctly in landscape form, but if she changes the text and
attempts to print or do a print preview, the orientation of the page
immediately changes to portrait and will print out in that form. The fact
that the original Publisher 2003 versions printed correctly but the newly
edit version does not sounds like there is a page formatting problem
occurring, but regrettably I'm not a publisher expert. Anyone have any
insights what mi...Changing the font style, fore colour and back colour of an individual cell in a VB6 listview
Again, another I've always left rather than sorting is the ability to style
(bold, underline, italic), colour the text and colour the background of the
text in a vb6 listview CELL.
Are any of these permitations possible? Am I better using an MS Flexgrid
and hidden textbox (for the edit bit)?
"Mojo" <email@example.com> wrote in message
> Hi All
> Again, another I've always left rather than sorting is the ability to
> (bold, underline, italic), colo...edit word art text?
I am trying to edit word art text created in an earlier version of Publisher
(1998) with Publisher 2007, but it is not supported. Any ideas how to do
this? The recent version will allow changes to everything but the text.
There is a WordArt compatibility utility. You use it by Insert, Object, Scroll
down to WordArt 3.2. If you have the old WordArt on your screen and you have
installed the utility, simply double-click the WordArt.
Publisher 2003/2002 Add-in: WordArt Compatibility
http://www.microsoft.com/downloads/details.aspx?FamilyId=897AA11B-A37D-4586-A1A7-54BBEA375AE2&displayla...How do I fill down keeping one cell calculation from changing in .
If I have a calculation I want to fill down which has multiple calculations.
How do I fill it down keeping one of the calculations constant. Meaning one
of the calculations always uses the same cell for a calculation, it doesn't
change as the cells go down.
eg =SUM(A2*F13-J13) I wand to keep the A2 all the way down but want the
to change as it is filled down.
Look up About cell and range references in the HELP files.
And try this:
Please keep all...Inserting Template truncates subject line text
When I insert a template into an email being written in CRM, it seems to
truncate the original text in the subject line, and replace it with that of
the template. This is not helpful, as it removes the subject line that
should stay with the email, and even though i'm sure another identifier will
be added to the email once sent, I have had to type out a manual subject line.
An example of this is using templates to store a signature block.
Since this didn't happen in 1.2, and I can;t see any way of turning it off,
can anyone suggest a workaround, rather than copying & pasting...text color
This is my second post on this problem. Using Pub. 2002
and HP6122 printer.
Created a postal card and had a color problem. Created
the card and changed some of the lines to a blue ink.
Saved the doc. and decided to change the blue back to
black. When I printed it out it wasn't sharp. In
looking under a Magnifying glass I could see the blue
color edge behind the black and it makes the type fuzzy.
Contacted HP and they suggested I try the same procedure
in other applications as Word, Notepad, Wordpad, Works,
etc. The problem does not happen in other programs. HP
says it is n...Opening text file using Excel
When I choose Microsoft Excel Program to open a text file I get thi
error "This file does not have a program associated with it fo
performing this action. Create an association in the Folder option
I used to open it few days back But I don't know what happened :-( al
of a sudden it stopped working. I uninstalled and reinstalled O2k Pr
with SP1 & SP3 still not working.
Can someone help me out on this one.
Message posted from http://www.ExcelForum.com
If you right-click on the file, you should get an 'Open with . . ' option.
Cli...How to update Ft End Queries when changing Bk End Table Name?
I changed the name of a table on the Back End of the data base.
I thought I could just repoint the queries in the Front End to the new
table name by changing the query properties.
Nope. Didn't work.
How can I get the Front End to keep up with changes I make on the
backend like changing a table name?
thanks for any help.
> I changed the name of a table on the Back End of the data base.
> I thought I could just repoint the queries in the Front End to the new
> table name by changing the query properties.
> Nope. Didn't work.
&...How do I change the color the cell becomes when doing a FIND
When I do a FIND or FIND / REPLACE, when Excel finds the value I am looking
for, it highlights the cell, but the highlighted cell is in white, which is
the standard sheet background. How can I change a setting so anytime I try to
do a find, when the cell is found, it shows this cell in a totally different
color say purple or red or yellow etc.. I find sometimes trying to identify
which cell it has selected in a full screen of data can be tough. I jst want
to be able to locate the selected cell easier.
Thanks for your help
Two known and common options to search ALL WB sheets....Can someone PLEASE let me know how to change my desktop settings in Vista?
I have a Nikon D3000 which takes shots that are wider in ratio
to their height than my monitor is. When I was running XP, it
automatically displayed the wallpaper as widescreen, with bars at the
top and bottom.
My Vista set up doesn't do that automatically and I don't know
how to make it happen. I'm no expert, but I've managed to do a little
more in terms of fixing things than a lot of comp owners who aren't
programmers have, but this baffles me, despite the fact there are
probably teenagers in this city who use a machine 20 minutes a week
who would know. And th...Find Text in List Box
I've looked hi and lo for code to find text in a List Box using
the Find input box in AC 2007. Finding text in the form works
ok but finding it in a List Box doesn't seem to work.
Can anyone point me to a web site or let me know what code I might need
to accomplish this?
List and combo boxes are objects (controls) that have row and column
properties. You need to find or write a routine that visits each column of
each row in turn and tests for your search string.
It seems to me this is a classic case for using VBA's OOP functionality.
Design a class ...VB6 - ADO
First I must to say Sorry, because my English is not the best. I have
some values that I write into an Excel XP sheet from VB6 using ADODB
connection. The problem is that in Excel XP sheet the numbers in the
cells are formatted as text. (All the cells In Excel have a green
error indicator in the upper left corner). To write the values in
Excel sheet I use INSERT INTO � or AddNew and Update methods of the
I would like to now how can I copy the values (or one column) of the
MSFlexGrid to Clipboard. It is to Past to another application, like
Excel Sheet or OriginPro 7.
Thanks any He...Changing Graph Title W/ Pivot
If I have 3 items I am showing on a pivot chart: cost of pears, cost of
peaches, and cost of apples, can I make the title of the graph change if I
just want to select a specific element . For instance when everything is
select the title for the graph is "Cost of Fruit". What I want is if I only
want to show apples I want the chart title to read "Cost of Apples". Any way
to do this?
Thanks in advance!
Select a cell on the worksheet.
Enter a formula that refers to the pivot page cell, e.g.:
="Cost of " & IF(B1="(All)","Fruit",B1)
...Excel: Can't save changes to print number of copies setting
I inherited an Excel workbook that has the number of copies to print set to
10. I change it to 1, then save the file, but it always reverts back to ten.
...excel case changes on a column of first names
Could somebody please tell me how to work the "proper" formula so that it
will change a column of names from all caps to just first letter cap?
I can get the formula to work for the first cell, but I can't get it to copy
or paste, or paste special to the column below it. (I don't use excel very
often and therefore have limited knowledge of these functions.)
One easy way is to insert a new column next to the column that has the
non-proper (upper or lower) case words or names. Presuming that you'd have
the names such as JOHN DOE in A1 a...Text Box in Forms
Why is it called a text box if I can't format it to accept text? I need to
have a control/input on the form that will accept 1102A as an input to a
query.Can you help me here?
"Gringarlow" <Gringarlow@discussions.microsoft.com> wrote
> Why is it called a text box if I can't format it to
> accept text? I need to have a control/input on the
> form that will accept 1102A as an input to a
> query.Can you help me here?
There's nothing inherent about a Text Box that would prevent entering
"1102A". Perhaps if you gave so...how do you change the data order in a graph without modifying the.
how do you change the data order in a graph without modifying the table?
I know it is possible if you change your table, but it is not very convenient.
You can change the order of the series: double click a series, then rearrange the
series in the Series Order tab.
If you need to change the left-right order of categories along the X axis of a
chart, you pretty much have to modify the table. If the table is for display, you
could chart from a separate table, both tables linked to the same source data.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutor...my cursor won't change to a crosshair pointer in Publisher
When I click the text box button on the objects toolbar in MS Publisher '03,
and move my mouse back to the area where I just deleted a text box, the
pointer is supposed to change to the "draw a frame" or "crosshair" pointer,
but nothing is happening. Can you tell me why?