Using VBA to change Excel layouts
Our company has designed 4 different spreadsheet designs. The same
data gets stored in any of the 4 spreadsheet layouts....the only difference
is that some spreadsheets use different colors, have different fonts and
cell sizes and etc...
I thought it would be nice to create just ONE spreadsheet that contains
a combo-box or list-box or drop-down box which allows the user to
select 1 of the 4 layout choices, then I want VBA to programattically setup
the spreadsheet layout according to the users choice. Does that make sense?
Does anybody know any good ways to implement something lik...Is there a way to use the previous record value in a formula?
I've created a report to show checks cleared for a certain month and want to
place an asterik next to a check number which is out of sequence. Is there a
way to use a previous record value in an expression =iif([check
no]-????([check no])<>1,"*","") ?
On Tue, 4 Dec 2007 10:38:03 -0800, zzamba wrote:
> I've created a report to show checks cleared for a certain month and want to
> place an asterik next to a check number which is out of sequence. Is there a
> way to use a previous record value in an expression =iif([check
> no]-????([chec...UDF: select field by its string name
I am looking for a way how to select field value, if the table and
field name both are available as string parameters.
I am aware that in SP it could be done, by using exec function. I am
also aware of the fact, that this is kind of bad practice, ie it
includes SQL injection threat, is not effective use of server engine,
etc. Nevertheless, I hope that I will be shown the solution rathter
than taught not to try.
The reason I need such function, is the nature of record IDs in the
database - they are not automatically populated, and they are random
(rather than consequitive...using excel to update data in access
Hello all. I was lookin for anyone who knows how to
directly edit data in access through excel. I have used
the import process but this is too manual. I was looking
for more of an autometed process.
Any help would be appreciated.
One way is to link the Excel table in Access (File>Get External
Data>Link Tables. Then, you can edit the data in either application.
> Hello all. I was lookin for anyone who knows how to
> directly edit data in access through excel. I have used
> the import process but this is too manual. I was looking
> for more of an au...USING DATES IN FORMULAS #2
I foubd a problem with excel 2003
If you introduce a formula using dates (in spanish version) (dd/mm/yy),
excel doesnt makes the calculation........... ???? Can somebody hep me
In the USA version (English), I could use:
=if(a1=date(2005,10,27),"It's Oct 27, 2005","it's not")
to refer to a date.
I don't know what the Spanish function is for =date(), though.
Carlos Benavides wrote:
> I foubd a problem with excel 2003
> If you introduce a formula using dates (in spanish version) (dd/mm/yy),
> excel doesnt makes the calculation........... ????...VBA needed to select a random name
I'm trying to set up a button that selects a randomly select a name from a
list of 10 names. I guess I need some VBA to do this. Would anyone know what
I got as far as making select a random number into a cell then putting an IF
formula into another cell but it doesn't work.
I thought there must be an easier way.
You could use
* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
"jj66" <email@example.com> wrote...How can I delete bold horizontal lines that I can't select?
I have encountered bold horizontal lines in a document that I didn't create.
I cannot select them for deletion or remove the pages on which they are
located; they just reappear on the page prior to the one I deleted. What can
I do? I'm using Word 2007 in Vista.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"GPorter" <GPorter@discussion...Serial number already entered for selected item
On a SOP Return I'm getting the message "This serial number has already been
entered for the selected item" when trying to specify a serial number. I've
checked serial number inquiry and this particular serial number is not
listed. I found a KB article that described the problem but didn't have a
This serial number has been sold, returned, sold again and is now being
returned again. The first 3 transactions areposted and all are listed in
SOP10201. I've also checked in IV00200 and it's not listed there. Any idea
where else this serial number co...Inventory Transactions using Integration Manager
I am trying to import inventory transactions (adjustmnet) using the IM, the
key thing is I want all lines in a single transaction.
I memic the sample in IM. but its not working imports all linesbut I am
getting this error: Object 'Adjustment 1' already exists -- cannot Insert.
I think the problem is related to te documnet number, I am using a cloumn
that conatains the same number for all rows (in order to import all the lines
in a single trx)
Am I missing anything? any hint?
Look at the "group by" function in the IM manual.
An import will consist of hea...Edit/Replace using VBA in Excel
Hi I'm a newbie and trying to implement some VBA code that automaticall
runs a the edit replace tool in a number of sheets. The problem I hav
is that I want the What:= & Replace:= values to refer to cells on a
index sheet (i.e not the activesheet).
Can anyone please help.
Message posted from http://www.ExcelForum.com
Fully qualify the range object:
Replace:= ThisWorkbook.Worksheets("Index Sheet").Range("A4").Value
MS Excel MVP
"Froojam >" &l...Weight Scales Used w/ Store OPs
In Quicksell, we had Toledo weight scales intergrated with the POS. With
Store OPs v1.2 we can't seem to get the scales to work. The only info I can
find on compatible scales in the KB is a scale / scanner combo. I called the
manufacturer but the combo is the only thing they offer and doesn't realy
apply. I e-mailed MS and they referred me to the discussion board.
Is there a way to incorporate the existing scales or does anyone know a
make/model of scale that can be intergrated with Store OPs v1.2?
Have you checked with Toledo yet? I know that some of their models ca...how to indicate on chart which axis (primary or secondary) in use
How can i indicate on a chart which series is using which y-axis when I have
a secondary axis? For example I have several series on a line chart, some
using the primary axis and some using the secondary axis. If I use the legend
it bungs them all together with no indication which axis which line is using
- I can change their order in the legend but this doesn't really help. This
seems to be a fundemental flaw with the legend - how are you supposed to tell
what is happening on a chart when you have no idea which y-axis is used by
each line??? The only way I can see to...XP Style button using MFC 4.2
I am using Visual C++ 6, MFC 4.2. Windows XP SP2.
My problem is, how could I get the XP Style buttons on the dialog. If i
dynamically create the button using CreateWindow() the button still looks
I've tried 'Button Controls' article on MSDN but no luck.
Could anyone help me?
Themes are handled by the system, and not on a button-basis.
The way to give your application running on XP the themed look is to include
a manifest resource. The resource can either be a resource compiled into
your EXE or it can be a separate file in the same directory as your ...How do I use a pivot table to get an average count? #2
I have a list of transactions with colum headers of Month, Date, Weekday,
Time and the transaction data. I would like to see the average number of
transaction per hour per day. Can this be done in a pivot table?
...double use of Substitution Function
to eliminate spaces from a data validation phrase, I can enter "
=Indirect(substitute(M12," ","")" and find the named range i need
create a List.
But, suppose I need to substitute for 2 characters...space, and comma
(,). How to I write the function to do
On Apr 9, 10:37=A0am, Tonso <wthoma...@hotmail.com> wrote:
> to eliminate spaces from a data validation phrase, I can enter "
> =3DIndirect(substitute(M12," ","")" and find the named range i need
> create a List.
> But, suppose I ...How to validate an XML Fragment against a schema using XmlValidatingReader class
I need to validate an XML fragment against a schema, the issue i got
is that the fragment i want to validate his root element if defined
in the schema as part of a complex type.. so if i dont have that root
element part of my XML fragment it wont validate, it simply said that
it cannot find any of the element. Is there anyway for me to say to
that XML fragment that is part of a complex type ??
the xml fragment xpath is : "//Company/Person"
that return me each Person element and his content, so far so
good(THAT THE RESULT I M EXPECTING TO VALIDATE), but when i need to
vali...copy-paste tables after useing package wizard and runtime 2007
I have made an access 2007 application. I have used package solution wizard
and runtime 2007 to deploy the database but after using the package wizard
it is no longer possible to use copy-function with mouse's 2nd button with
I have made the same database with access 2003 and after using package
wizard I am still able to use copy-paste-fuction with tables. How can I make
it work with access 2007?
best regards and happy new year
...Macros to select multiple sheets to make simultaneous change
I need to have a macro such that it'll select all sheets
from the first to the sheet before a sheet called "test".
After selecting these sheets, i want to make simultaneous
changes to them. So how do I add the code in the macro to
choose all these sheets?
I can't put the names of the sheets coz the names changes
This will loop through the sheets
Dim num As Integer
Dim a As Integer
num = Sheets("test").Index - 1
For a = 1 To num
MsgBox .Na...How do I add and then rename a worksheet using a macro?
When I try to rename a new worksheet in a macro, it will make the worksheet
but will not rename it.............. and gives an error because the new
worksheet has a different sheet number than the one the macro just made....
All I want to do is compile a macro that makes a new worksheet and will
rename that sheet a different name. . . . . . . .
The inserted worksheet will be the active sheet after the insert, so after
inserting it, you can write:
ActiveSheet.Name = "New Sheet"
mvpearl omitthisword at verizon period net
----------------------------...selecting from multiple OR statements
Any idea why this query returns ALL the rows:
select * into #temp2
substring(Firstname, 2,1) <> ''
substring(Firstname, 2,1) <> '.'
substring(Firstname, 3,1) <> ','
substring(Firstname, 3,1) <> '.'
substring(LastName, 2,1) <> ''
substring(LastName, 2,1) <> '.'
substring(LastName, 3,1) <> ','
substring(LastName, 3,1) <> '.'
*I think it'...DropDowns
In a 17 worksheet workbook I need to allow one of 32 possible dropdown
entries to be used but once. I have the custom validation box with the 32
entries in worksheet 1 but can not figure out how to eliminate the the
already used entry in worksheet 2, the used values in worksheets 1 and 2 to
not show up in the dropdown or worksheet 3, the used entries in worksheets 1,
2, and 3 not to show up in worksheet 4 and so on?
Any help appriciated.
PS: yup it's me again as football season draws near...
To those who have helped in the past and those about to help, Thank You.
There is an int...Some Public Folder mails not visible using IMAP
Windows 2000 SP4 server/Exchange 2003 SP
Strange thing happened yesterday. In the the course of 2 minutes about 200
mails appeared in one of our Public Folders, mails which had been received
earlier into one of the other Public folders. All the mails have correct
sender/receiver/subject but have blank messages. The receiving dates have
been changed to yesterday's date, but looking at the details in Outlook
these mails were all first received on Jan 6, 2006.
Even stranger is that when viewed using IMAP these mails are not visible,
but using OWA or Outlook in Corporate mode, they are visib...Cut, Copy, Paste using Insert Key in Outlook 2007
Since I am left-handed and use the mouse with my left hand, I have grown
accustom to using Ctrl-Ins for Copy, Shift-Ins for paste, and
Shift-Delete for Cut.
While in an opened message in Outlook 2007, I can use these key
combinations (due to an editor option in mail format tab of the options
dialog), but in the preview pane, I am not able to do it.
Is there some way to enable these key combinations in the preview pane
of Outlook 2007?
cd <firstname.lastname@example.org> wrote:
> Since I am left-handed and use the mouse with my left hand, I have
> grown accustom to using Ctrl-Ins for Copy, Sh...An error message occured while using sa logon into GP7.5
"An error occured granting rights for tables in the 'DBName' database; GPS
Please help! Thanks
have you installed any service packs?
On Oct 31, 2:40 pm, Jim <J...@discussions.microsoft.com> wrote:
> Hi all,
> Error message:
> "An error occured granting rights for tables in the 'DBName' database; GPS
> Error: 58"
> Please help! Thanks
Yes, I do. I had installed latest service packs
I'm new with XML. Please give me some advice.
I wonder there are any difference between XML that is automatically generated
from ADO and XML file that shows in many textbooks. I found that the formats
are a bit difference. At the begining of the one that is automatically
generated from ADO is usually like this
<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:
- <s:Schema id="RowsetSchema">