Changing Rows to Columns
Is it possible to easily rotate a spreadsheet or part of a
spreadshet, to change the data in rows to columns? Do to a
sorting problem in the charts I create, it seems I have to
sort the data in the spreadsheet first.
Any help would be appreciated.
Sure is a way. select & copy your data. then select
the cell where you want to re-paste; right-click and
select paste special; in the dialog box check "transpose".
>Is it possible to easily rotate a spreadsheet or part of
>spreadshet, to change the data in rows to columns? D...VBA code to say Yes or No if any VBA code is present in ActiveWork
Using XL 2003 & 97
Would like hit Ctrl+Shift+V and have an answer either yes or no as to the
presence of Any VBA code in the Active Workbook.
I do know that about the VBA editor/Explorer or to press the Run Macro
button and get a list from various sources .
I would like to stay at the keyboard and process a series of macros
including one to let me know if I even need to evoke the VBA explorer.
There is no bootstrap macro to tell you whether you have macros
or not. If there were there would be no limit to virus writers.
David McRitchie, Microsoft MVP - Excel ...POS Receipt format change
I would like to have the "Sales Receipt" read "Sales Invoice" or "Invoice".
Also I would like to have "Transaction #" replaced with "Invoice #".
Can anyone help me with this? I have been able to edit the "Sales Receipt"
portion in an xml editor but have not been able to change the "Transaction
#" as there must be some other coding that needs to change.
Thank you in advance.
you can find the SUB: PrintTransactionType and then locate the
Transaction.ReceiptReferenceNumberCaption reference field. this...SLOW FUNCTIONS
I have a 'new" excel 2007 & need to run in compatability mode because most
of my associates have 2003.
Almost all functions - from cut and paste or copy and paste are delayed
while the little blue circle thing spins. Usually form 4 to 10 seconds. it
really adds up. What can I do to correct ?
I am running 2007 on a 5 year old PC and do not experience what you describe.
Is your PC really old?
Do you have much RAM? (this thing has 1G of RAM, running WinXP)
Do you have any add-ins loaded that might not be completely compatible with
&...Print, Merged Cells, and VBA
I'm looking for a code that will help me with a print job
for a worksheet. There are a lot of merged cells and a
lot of "IF"s to be used in the VBA for range selection.
Thanks in advance,
...Use VBA to update Access table or Query from Excel
Can I use VBA to update Access table or Query from Excel?
Thanks in advance
> Can I use VBA to update Access table or Query from Excel?
Of course, using ADO or DAO.
Jan Karel Pieterse
Thanks. I think ADO is what I want.
But I am not only want to export from excel to access.
I want to edit some data in access table.
For example, Access has a table "ProductList"
I want to use Excel to call the product by "Pro...Remap F2 key function to Enter key?
Could someone please tell me how I can set the Enter key to edit the
selected cell in Excel 2002? (just like F2 does by default).
On Nov 20, 12:08 pm, mark.hand...@gmail.com wrote:
> Could someone please tell me how I can set the Enter key to edit the
> selected cell in Excel 2002? (just like F2 does by default).
> Much appreciated
If your keyboard software allows re-mapping you may be able to do this.
I would think that using the ENTER key for cell editing could cause some
problems and would not be intuitive.
How about just double-click the ce...3.0 Lastname change ???
I made a new user and then changed the way it show lastname name to name
How can I get the first user to be in this format ?
Can I just change the full name for the user en the table for systemusers
??? There hasn't been created other things than this user in the system ?
"Jack" <jackdSPAM@jackd.dk> skrev i en meddelelse
>I made a new user and then changed the way it show lastname name to name
> How can I get the first user to be in this format ?
You can...Reserved names in Excel
Does anybody know a list of predefined names in Excel ?
I know names like Print_Area and Print_Titles, but are
There's another called FilterDatabase (from data|filter|Autofilter).
And probably lots more.
Get this name manager by Jan Karel Pieterse's (with Charles Williams and
Matthew Henson). You can find it at:
NameManager.Zip from http://www.bmsltd.co.uk/mvp
Then open this addin and run it against a workbook that you've used a lot. You
might see lots of stuff that you never knew about.
> Does anybody know a list of predefined n...VBA and Scheduled task in Outlook
Hi, how can I:
a) pull the query from somewhere and send it by e-mail automatically. E.g. I
want to take a temperature table from
where 2009/7/10 is the date of yesterday put it into an e-mail and send it
automatically each day at 8 o'clock?
b) if this is not possible, how can I send an e-mail with the attachment
c:\Documents\query20090710.xls each day at 8 o'clock?
my boss wants this automatized, I know how to write the VBA code for Excel,
but don'...vba select field
having a button on a form, is it possible to select only some fields
(all from the same table) of the current record instead of all fields?
I've tried this code:
Forse dipende dei dati nel record.
but it selects ALL fields in the form.
On 10.04.2010 18:01, remigio wrote:
> having a button on a form, is it possible to select only some fields
> (all from the same table) of the current record instead of all fields?
> I've tried this code:
> RunCommand acCmdSelectRecord
&...I can't change fonts. Why??
I have a strange problem, with Publisher. I only can use some basic fonts in
textboxes. If I choose one (for example Jokerman), the font bar jumps back to
Times or to other basic fonts.
I have this problem on Vista-Office2007 Beta 2, XP SP2-Office 2003, XP
SP2-Office 2000 too. What is interesting, that I can use all of them in the
In Word I can use all of the fonts too. What could be the matter?
Could you help me?
Thanks, Gábor from Hungary.
...VLOOKUP in VBA
On the worksheet I can insert in a cell
=VLOOKUP(C5, Hobokee.xls!AcsLow, 2)
and it works perfectly, looks up the value in column 2 of the range named
AcsLow in the same workbook.
But elswhere I want in a macro to lookup the same table and assign the
result to a variable BalAmt.
BalAmt = VLOOKUP(AccNum, Hobokee.xls!AcsLow, 2) does not work.
It gives a function not defined error on Hobokee. If instead of Hobokee I
put Workbooks("Hobokee"), it gives function not defined error for VLOOKUP
which it changes to VLookup.
I have been overVLOOKUP in the Help file and see nothing wrong.
W...get change operation on coCustomLinks cannot find table
I have this client that has deployed their server in Singapore but has
a branch in Thailand. Since Thailand also needs to use Great Plains,
they have installed a GP 8.0 application in a workstation in Thailand
and connects to the database deployed in Singapore. But when the staff
in thailand logs onto her workstation, she gets the error
"get/change first operation on coCustomLinks cannot find table"
then all suceeding document processing (i.e. GL entries), go haywire -
the next journal entry number doesn't generate.
They went through the same installation procedures ...Excel VBA/Macro programming for beginners
I know a bit VB 6.0 programming. Will it help me to write exce
vba/macro(same thing?).can anybody help me by providing some fre
websites where i can have informations/codes for VBA/macro.
Please tell me how could i make a *command Button * in a cell in th
sdebu_2000's Profile: http://www.officehelp.in/member.php?userid=430
View this thread: http://www.officehelp.in/showthread.php?t=118812
Posted from - http://www.officehelp.i
Try David McRitchie's "getting started with mac...Unable to Open received PO (change to "change order")
Great Plains will not allow me to change this Purchase Order from Received to
Here is the message I get:
However, if I try to enter a quantity cancelled, I get:
How can I re-open this Purchase Order so I can change the price???
Unfortunately, the pasted messages did not come through.
Once a line item is received, you can change its cost only during invoice
matching. The process would be to return the item; add a new row with the
correct cost; and receive and invoice the new item. Not an elegant solution,
Charles Allen, MVP
&quo...calling function in another UI thread
I created another UI thread from the main thread using
AfXBeginThread. I defined a new function in the new UI
thread. Can I directly call this function in the main
thread, or do I have to PostThreadMessage? If I can
directly call the function, what kind of IPC mechanism is
it? I am little confused. Thank you!
class CNewUIThread : public CWinThread
a thread does not have functions, it is a sequence of instructions, usually
including a loop that processes messages or does some other computation
until it either finishes its work or is killed by...Turn pc speaker on/off with vba code
Is this possible?
I found something here on how to do it withVBScript. You can probably modify
it to work in VBA
> Is this possible?
I'll have a go
(I need to improve my web searching skills)
"Barb Reinhardt" wrote:
> I found something here on how to do it withVBScript. You can probably modify
> it to work in VBA
> ...How do I change the type of Outlook I have...from Corporate or Workgroup to Internet Mail Only?
How do I change the type of Outlook I have...from Corporate or Workgroup to
Internet Mail Only?
Umma Gumma, you wrote on Mon, 18 Jun 2007 04:56:01 -0700:
> How do I change the type of Outlook I have...from Corporate or Workgroup to
> Internet Mail Only?
"Christian Goeller" <email@example.com> wrote in message
> Umma Gumma, you wrote on Mon, 18 Jun 2007 04:56:01 -0700:
>> How do I change the type of Outlook I ha...Loading a Form from VBA
Hi all, I'd like a module to open and load a form in my Access 2003
database... How can I do this?
Use the OpenForm method. Look in the Help file for details.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Mike" <firstname.lastname@example.org> wrote in message
> Hi all, I'd like a module to open and load a form in my Access 2003
> database... How can I do this?
On Jul 18, 10:58 am, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com&g...File> ... Can I see more file names?
When I click on File I see (below the list of available options) four
previously saved xls files.
How do I see more , say the last 10 saved files?
<Tools> <Options> <General> tab,
And increase to 9 (max) the number of entries in the "Recently Used File
Please keep all correspondence within the Group, so all may benefit!
"SouthAfricanStan" <me@there> wrote in message
When I click on File I see...How do I protect specific cells from changes in Excel?
Please can someone help me. How do I protect specific cells from changes in
Excel? I have a spreadsheet that I would like users to only be able to change
certain cells, the others need to be protected from change
Go to Format>Cells. On the Protection tab, uncheck the "Locked" box for any
cell you want to be editable. After you protect the document, the user will
only be able to edit the cells you unlock.
"LarryH" <LarryH@discussions.microsoft.com> wrote in message
> Please can someone help me. ...my paste special function won't let me copy formulas
I am using Excel 2007 and I can't seem to copy and paste formulas from one
workbook to another. Instead I get a dialogue box asking me if I want to use
paste or paste link and to chose from a list of formats. Does anyone know if
there is something that I can change in Excel to fix this problem?
It sounds like you have the workbooks open in separate instances of excel.
Close one of the workbooks (and its instance of excel) and then back to the
Hit ctrl-o and open your second workbook and try the copy|paste.
> I am using E...Excel and VBA
I am very interested in learning more about using VBA in office, especially
Excel. Can you post some resources (online, books, etc) that can be used to
help learn about using Visual Basic in office.
Here's a good place to start:
Does that help?
"Bob Sinclair" wrote:
> I am very interested in learning more about using VBA in office, especially
> Excel. Can you post some resources (online, books, etc) that can be used to
> help learn about using Visual Basic in office.
Is there a way to get the name of the current company through VBA in Great
Thanks for all your help.
open GreatPlains. Add the current window, it will add the
Toolbar then add fields choose the company name on the
top left after the user id.
>Is there a way to get the name of the current company
through VBA in Great
>Thanks for all your help.
Thanks. I tried, but I couldn't add company name to the field list. It opens
up the login screen instead.
Any thoughts? Thanks again.