Export-Import XML data
I want to export and import data into MS's Excell file using XML,
I can do it when it simply exporting or importing data, but there's a
I have to lock some cells without using VBA,
I can change the data format, for example BOLD, using XML
but can't lock the cell and don't know how to do it,,,,
I have been searching a lot of pages and tools but there's no
Does anyone know how to do it ?
...How to get 2 A5 flyers on 1 A4 landscape page
I have designed an A5 size flyer in publisher. I now want to rotate the
design so that I may fit 2 flyers side by side on an A4 landscape page?
On the Printer Setup, set the paper size for A5 paper.
Then on the Page Setup, set the paper size for A5 paper.
"Terri" <Terri@discussions.microsoft.com> wrote in message
> I have designed an A5 size flyer in publisher. I now want to rotate the
> design so that I may fit 2 flyers side by side on an A4 landscape page?
...HOW: Click Formula Hyperlink To Trigger Macro
I have a column (Column 6) where every row contains an IF() formula
that results in a HYPERLINK() formula if the previous cells in that
row each contain data. In other words, a hyperlink shows up if the
row is filled out. If the hyperlink shows up, and the user clicks it,
I want a macro to be triggered. I want to trigger a macro that draws
upon the data from the other cells in that row.
My first discovery was the Worksheet_FollowHyperlink event. It seemed
perfect. It triggers when a Hyperlink Object is click and captures
that location of the cell where the hyperlink was clicked....Change Pivot Table Data-Source Connection
I have a fairly huge Pivot Table which source's its data from a SQL Server
I need to change this connection but keep the pivot table - I can't seem to
do this. When I click on Pivot table, then the back button to show the list
of tables, it won't allow me to go back another time to re-choose the actual
Is this possible?
My last resport is to re-create the whole Pivot table again, but I'm trying
to avoid this......
...get and put value
How do I get the value some colomn before (and after) ActiveCell.Value and
put in a cell
A1 = "UK"
B1 = "US"
C1 = "AU"
D1 = "ID"
E1 = "DE"
The activecell is C1, I want to get the value of colomn A,B,D,E and put in
(let say) AA,BB,DD,EE
Range("AA1").Value = Cells(Activecell.Row,"A").Value
"!..:: Enang ::..!" <firstname.lastname@example.org> wrote in message
> How do I get the value some colomn before (and after) ActiveCel...Macro Help needed #2
I'm trying to record a macro but I'm having difficulty with a particular
I'm trying to copy text from a particular cell, Lets say Cell A1, and then
go to the "Sheet Tabs", currently labeled Sheet 1, and paste the text to
rename the sheet.
Can Someone tell me what I'm missing from the following macro to make this
' Macro Macro
' Macro recorded 8/18/2005 by Anthony Amato
Sheets("Sheet 1").Name = " &qu...Window Messages Not Getting Processed in Vista With UAC ON in Win32
I have to close "OnScreen Key Board" Which can be accesed through All
Programs->Accesesories->Ease of Access (in Vista)
when i find the class name using Spy++ i Get information as Cass Name
As "OSKMainClass" and caption as "On-Screen Keyboard" If I try to
close this window through Win32 applcication i am getting valid
handle but when i send WM_QUIT its's not getting closed. Even if i try
to hide using ShowWindow(hwnd, SW_HIDE) method it's not hiding (i.e
Any Messages are Not Getting Processed ) and i get Error code As 5
(i.e. Access Denied). this...macro with wildcards
Operating System: Mac OS X 10.4 (Tiger)
I'm trying to create a macro that will fatnd all characters,words, lines or paragraphs the are grouped between two brackets. I've tried [*], but get no results.
In article <59bb65ef.-1@webcrossing.JaKIaxP2ac0>,
>Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel
>I'm trying to
>create a macro that will fatnd all characters,words, lines or paragraphs
>the are grouped between two brackets. I've tried [*], but get no resu...macros run twice
Hi - I have been working on some Macros. I am compiling a macro that runs
other macros. I have two noticeable problems.
1 - My SaveAs macro runs fine by itself. But when called or ran by another
macro, (which calls more than one macro) the SaveAs macro it stops.
2- Many of my macros, when ran by another macro (which runs more than one
macro) cycles through twice.
My specific question is about no. 2 and the following are the individual
macros and the macro that runs them.
'''''This macro copies values from sheets 1, 2, 3, 4...Delete Macros Macro
I have some xl files that have many macros in them. For
example 20 xl files with 10 macros in each file.
I have the following macro in it's own xl file that I use
to delete the macros in the other files before I save the
xl files in another directory.
Dim vStop As Double
vStop = 0
Do Until vStop = 50
Application.SendKeys Keys:="%tmm", Wait:=False
Application.SendKeys Keys:="%D", Wait:=False
Application.SendKeys Keys:="Y", Wait:=False
vStop = vStop + 1
This works fine exce...Macro's
If I delete/remove a macro after the formula's have used the macro to
tabulate calculations, the next time a go into the file will the amounts
still be there? Or does the macro need to be in place at all times?
If it's a macro that places values (or builtin formulas) into cells, then you
don't need the macros.
But if it's a UserDefinedFunction macro (and there are cells that use that
formula), then you'd need that code. (Or convert those formulas to values.)
And when you're cleaning up the macros...
Debra Dalgleish has some instructions:
http://www.contexture...Transfer Macro in Excel
I am trying to transfer informtion in one sheet to another sheet in the
same workbook. I have a macro to process this information from the
first sheet to the second. I keep getting an error in this Process
macro at the line.
The first sheet is called ProblemSheet and the second sheet is called
Processed. The line above is taken from the process macro on the
ProblemSheet page. Do I have to name a certain cell as "END" on either
sheet? Any help with this would be really appreciated.
Message posted from http://www.ExcelForum.com...unable to get Inbox in OWA #2
Recently I installed a new exchange 2k in an existing
site of exchnage 5.5 in the same domain. When I moved
few mailboxes from exchange 5.5 to 2k server, they worked
fine with ms-outlook but those users could not access
their mailbox from OWA (exchange 5.5 interface). Both of
the exchange servers are working fine for inbound and
outbound emails and other users having their mailbox in
ex5.5 can still access their mailbox through OWA 5.5.
I know that OWA 5.5 should be able to access ex2k
I will highly appriciate your help.
Please see the following arti...workbook macro help
Hello there, I would like some help with a macro that I need to run in
a workbook. this is the macro.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
what or how do I get it to work for every worksheet in the workbook, I
currently place the macro in each worksheet which is very time
consuming. Is there a way to place the macro in the workbook so all
worksheets have the autofit macro? and can I single out a worksheet so
as not to have the macro.
Probably better to use the Change event than the Sel...Pivot Table data output on multiple sheets
I would like to know if there is a way to automatically get Excel to
create the same pivot table on several sheets with each sheet showing
a selection of the data.
On one sheet the pivot table which relates to the male
Another sheet the pivot table relating to the females
AFAIK this is not possible
"Sean" <email@example.com> schrieb im Newsbeitrag
> I would like to know if there is a way to automatically get Excel to
> create the same pivot table on ...Macros #12
How do I get a mcro to run at a certain time during the day?
Take a look at Chip Pearson's notes:
> How do I get a mcro to run at a certain time during the day?
See replies to your other similar post in Excel.Misc news group.
Gord Dibben MS Excel MVP
On Thu, 20 Aug 2009 13:08:01 -0700, Davo1 <Davo1@discussions.microsoft.com>
>How do I get a mcro to run at a certain time during the day?
...How do I change macro text with another macro?
I have a set of workbooks that all have a similar macro in them. Each of
these macros contains a string I need to change, but to change it manually
in each file is time prohibitive - 60+ files.
Given I already have one of these files open with a seperate macro, from the
seperate macro, how do I access the module - say Module1, search for the
line that contains the text needing to be changed, change it and then close
I already have the list of files and the loop to go through all of them. I
am just unclear on how to change the Module1/Macro text from another macro.
Any ide...Relocating a macro
I accidentally created a macro in the worksheet I was working on at the
time instead of in PERSONAL.XLS. I have tried to move or delete macros
before and gotten annoying messages afterward when I opened the
original file saying "VBA Error!" etc, etc. In some cases, XL couldn't
find the macro after I moved it. What is the correct protocol for
moving a macro from a regular spreadsheet to the PERSONAL.XLS
spreadsheet without causing complications?
Perhaps you could indicate a bit better what you actually did.
If you are running a macro from Alt+F8, even though yo...Run multiple Macros or macros from within other macros ?
I would like to run multiple macros at startup. What code should be used in
the Private Sub Application_Startup command in the ThisOutlookSession area ?
If the names of my macros were below what would the code to look like ?
I have looked at the samples from previous posts and cannot determine how to
make them apply specifically to my needs.
In Excel you can use the Run "Macro1" line and it would run that macro. Run
does not work in Outlook I suppose because I kept getting an error.
Also - What code is needed to execute a macro from w...Converting Word macro for the Mac
Operating System: Mac OS X 10.5 (Leopard)
Hi everyone, <br><br>I'm looking for a way to combine multiple Word documents into a single document without copying and pasting or using the "Insert File" command. I work as an editorial assistant at a publisher, and this kind of macro would make creating files for the Library of Congress CIP program much faster! <br><br>I found a macro online (here: <a href="http://www.gaebler.com/How-to-Combine-Multiple-Word-Documents-Into-One-Document.htm)">http://www....how to get file id in C#
how to get file id in C#
is there any kind of unique id that can be obtained for any file in a file
You can you use hash algorithm, it creates representation of file's content.
It would be unique to all the files. But yuo'll get the same result for the
same file with different name.
HashAlgorithm hashAlgorithm = HashAlgorithm.Create( "SHA1" );
FileStream fileStream = new FileStream( fullFileName, FileMode.Open,
byte hashCode = hashAlgorithm.ComputeHash( fileStream );
"Daniel" <firstname.lastname@example.org> wro...How to get the locale setting?
I want to get the locale setting user sets from Control
Panel->Regional Options. Based on that I would setlocale()
to show the date and time value appropriate for the region.
Any idea help would be appreciated...
>> I want to get the locale setting user sets from Control
>> Panel->Regional Options. Based on that I would setlocale
>> to show the date and time value appropriate for the
>How about GetLocaleInfo() ?
>http://msdn.microsoft.com/library/en-us/in...Getting revenue sum into report
We are new to CRM, and I have been tasked with working on reporting. We would
like to create a report that shows estimated revenue totals by Status Reason.
So we would see the sum of the estimated revenue for all opportunities that
are in the “Business to be Closed” stage, the sum for all in the “Business
Closed” stage, etc. I am guessing that I can take an Excel version of the
report and manipulate it, but there must be a cleaner way to do it, since one
week there may be 15 items in a particular stage, and next week only 3 items,
so where would we put the cell that sums the data?
As ...Getting rid of matching records?
Instead of trying to do this in VBA I have a large excel file with 50'000 +
duplicate postal codes. What I'd like to do is when ever a postal code is in
the file more than once I'd like to delete all of instances of that postal
RESULT (remove N0N1J0)
Use Data>Filter>Advanced Filter
See this page
Regards Ron de Bruin
"HotRod" <NOSPAM@youremail.com> wrote in message news:u5sNpGS$GHA.1172@TK2MSFTNGP03.phx...Undo using macros
Can you undo using macros?
Yes. You can.
"nc" <email@example.com> wrote in message
> Can you undo using macros?
My mistake I did not specify I would like to undo VB
>Yes. You can.
>"nc" <firstname.lastname@example.org> wrote in