VBA Macro help
I have taken a project using Excel.
Now wt i need is that if i click a command button in excel the macro
coding must open a excel file from one location and do a some
formating (bold the header, sorting by client / stcd / TOS etc in
ascending / decending delete columns last action, pat type etc change
PN Assign column to Currency insert SIF cloumn before TYPE SRVS .and
page formating as landscap, header (XXXXXXXX), page number at the
center bottom and save the file name with password (12345) with the
filename continuing the current date for example
"N0123(curren...Covered Call Options
I do I go about dealing with a covered call transaction in Microsoft
Money 2007 Premium? Currently what I am doing is inputing the option
symbol, and choosing the transaction "Sell to Open" then when I go to
expire the option I try to do a Sell to Close. However it does not
seem to work? Also what happens if instead of expired I has the
position assigned? how would I account for that? Thank you.
In microsoft.public.money, Shhhh wrote:
>I do I go about dealing with a covered call transaction in Microsoft
>Money 2007 Premium? Currently what I am doing is...macros shortcut keys don't work
I have several macros they will run from tools, macro, run but not from the
short cut keys. I look in the macro editor and the keyboard short cut is
listed. when I do the shortcut I just get the exclamation sound.
...Macro compatibility in xls2003
I'm having trouble exporting data from a source program (SAP) to excel. It
worked fine with the '97 version, but since we upgraded to '03, nothing
I'm not too experienced with scripts, but I'm told that the macro in the SAP
program just might not work properly with xls2003.
I can, however, export the data to word2003 and then to excel, but it's a
Does anyone have experience with macros incompatability in excel 2003 /
suggestions that may narrow down this issue?
Do new owners of Office X have to call up Microsoft to register their
copy? If yes, what's the number? thanks.
Ming <firstname.lastname@example.org> wrote:
> Do new owners of Office X have to call up Microsoft to register their
> copy? If yes, what's the number? thanks.
Nope. We're not using Windoze :->>>
This version does not require activation.
- Mac:MS MVP (Francophone) -
(MS) MVP: http://support.microsoft.com/default.aspx?ln=FR&scid=fh;FR;mvp
Newsgroups produits MS: http://support.microsoft.com/newsgroups/?ln=FR
...Call center tracking and reporting
Anyone use CRM 4.0 for call tracking? Our Sales/Marketing is set up. Now I
need to decide how to most efficiently customize CRM 4.0 for our company's
call tracking portion. Can someone send me a link to information?
...Save Macro with date in name
I have a macro that I want to complete by saveing the file with the current
date ate the end of the file name.
I have this code but I get an error with the "DateAdd".
ActiveWorkbook.SaveAs Filename:="Monthly Accrual Upload" & DateAdd ("MMMM")
& " - " & DateAdd ("yyyymmdd") & ".xls", _
How can I get the file name for April to be;
Monthly Accrual Upload - APRIL - 20101604
Use Format() as below
Msgbox "Monthly Accrual Upl...Macro to insert blank lines
I wonder if anyone already has a macro for the following operation I
perform quite often please? I insert blank lines in a long table
whenever a particular column changes. A typical example is in a list
containing a Year column, sorted by Year. It improves readability to
add a blank line between the 1972 and 1973 sections, 1973 and
Terry, West Sussex, UK
For i = cells(rows.count,"a").End(xlUp).Row To 2 Step -1
If Cells(i, 1).Value <> Cells(i - 1, 1).Value Then
Don Gui...Recording and Deleting a Macro
I am new excel 2003 and I'm learning at my own pace. I have recorded several
macros. As a new excel user I am having not having much success opening up
and deleting some of the macros that I have created and in need of some step
by step instruction. Might anybody have any instruction in this situation in
deleting and opening up macros.
Check out http://www.nwarwick.co.uk/Excel.html,
There's is a short 3 step tutorial on Excel macros that will show you how to
open and delete, and even do simple edits to your macros, if you have any
more questions then post back or contact m...Excel to Word macro
I have a bitmap picture in a sheet.
I need a MACRO so as when I click on the bitmap picture a range (selection
of cells say A167:E207 will be exported to MicroSoft Word.
...Using VBA to assign a macro to button
I've searched through several posts but can't find a solution that helps me.
Here is what I am trying to do:
I have a button with an attached macro that imports a data table from a sheet
for the user to edit. When the user is done he must select a save button,
which is attached to a macro that copies the data table back to its original
place with the new data. All works well to this point.
However, There are many data tables that need to be brought in by means of
macro attached buttons. Once the user is done, each needs to be saved back to
its original location when the use...telephone calls
when placing a telephone call using outlook, everything
works fine except I can't hear the person i am talking
to. They can hear me find. When I use a telephone
program not associated with outlook every thing works
great. can someone help
I have macro like this
Counter_item = 0
For Each Item In nodups
counter_item = counter_item + 1
bic_var = Item
I have another macro
If counter_item <= 1 Then
In the first macro i am declaring counter_item equals to 1.
In my second macro i need to call that number.
At the to of the module put:
Public Counter_I...Workflow -Assembly Call
How does add subtract in the Workflow>> assembly call works.
I do understand that ypu can write your own custom workflows, register it
and then call them from here, but I am pretty confused with the existing
workflows can call other workflows
workflows can also call a method in a .net assembly. ie you could write a
piece of code in c# or vb.net and then have the workflow call your code.
Microsoft CRM MVP
"SAM" <SAM@discussions.microsoft.com> wrote in message
news:DE...Creating macro for find and replace
I recorded a macro for find value 0 and replace with
nothing. However after I run it on another excel
worksheet, there is an error.
Run-time error 91:
Object variable or with block variable not set.
Is there any way to rectify this?
Thank you for your help
It would help if you would post your code.
MS Excel MVP
"hidaya" <email@example.com> wrote in message
> I recorded a macro for find value 0 and replace with
> nothing. However after I run it on another excel
> worksheet, there...Async calls to WebService in MFC
I use a webservice over the net which is scripted in VB.Net. This web
service receives a username and a password and returns a string
structure with multiples infos. If the string is empty, I had the wrong
username and/or password. Pretty simple isn't?
Ok now the problem is a bit more complex. I'm using an MFC client to
connect to these web services, and since they're on the internet,
there's a delay between sending the data and receiving an answer. I
don't know really how I can tell me client to "wait for the string".
The wrapper MFC created for the w...Macro security message pop up
Is there any way I can have the security message not pop up that asks t
disable macros? This usually comes up if the security level is high.
also have the excel cells password protected, but not sure if tha
impacts the warning or not. Thanks
sgodse's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1457
View this thread: http://www.excelforum.com/showthread.php?threadid=27253
if you set the security level to 'Low' you won't get these warning
message. BUT I wouldn'...macros turned off help
I had a problem with refreshing a pivot table automatically. I sorted
this with a Page code Excell 2000
trouble now is I seem to have turned off macros and it won't refresh
looked up help but can't find simple "to turn macros on"
any help appreciated
Message posted from http://www.ExcelForum.com/
Have you tried closing and reopening the file?
> I had a problem with refreshing a pivot table automatically. I sorted
> this with a Page code Excell 2000
> trouble now is I seem to have turned off macros and it won't refresh
&g...Invalid procedure call or argument?
This is a re-post of a problem I posted a while ago, but to which I got no
suggestions: hopefully I'll be more lucky this time!?
I have the following code in a Private Sub:
If InStr([ResponseXML], "element") > 0 Then
errorfield = "Invalid " & Mid([ResponseXML], InStr([ResponseXML],
"element"), InStr(InStr(InStr([ResponseXML], "element"), [ResponseXML], "'")
+ 1, [ResponseXML], "'") - InStr([ResponseXML], "element") + 1)
Most of the time this works fine, but for some...Macro needed, Two saves in One
I need some help.
I have a Visio page open and I have saved it once already as a VSD file. So
it already has a filename with a aVSD extension.
So I'd like to be able to click a macro button that does this
Application.ActiveWindow.Page.Export "C:\Documents and Settings\Visio
i.e. Export the file (keeping the same filename as the VSD name) but as a
PNG in my PNG subfolder .
Any help appreciated.
(Should I move this to a VBA newsgroup ?)
On Mon, 26 Mar 2007 13:46:58 +...Why macro cannot refreshall?
Does anyone have any suggestions on why macro cannot refresh all link?
On file.xls, there are import external links on many worksheets, which will
automatically update all links once it is opened, but when I use a macro to
open this worksheets, the worksheet does not update the import external links
at all. Even though, the code .RefreshAll is included, this macro will close
this file, but the links do not update, does anyone have any suggestions why
RefreshAll coding does not perform?
Thanks in advance for any suggestions
Public Sub UpdatingLists2()
Dim WkbkName As...Unable to get DxgkDdiRecommendFunctionalVidPn call in windows 7
I am trying to add an initial vidpn topology by implementing the
DxgkDdiRecommendFunctionalVidPn call in the WDDM miniport driver.
But starting from windows 7 i am unable to get the
DxgkDdiRecommendFunctionalVidPn function call from dxgkrnl.After
searching through the MSDN documentation i found out that the function
is deprecated starting from windows 7.
msdn link: http://msdn.microsoft.com/en-us/library/ee220395.aspx
According to msdn
"On a computer running Windows 7, the display mode manager (DMM)
determines an appropriate VidPN topology to apply using VidPN history
d...Where to call SetWindowPos
In my SDI, can I place the following in CMainFrame::OnCreate( )? Or is there
a better place?
// ensure window opens on top when called by other applications, esp. the
SetWindowPos(&wndTopMost, 0, 0, 0, 0, SWP_NOMOVE | SWP_NOSIZE);
Note that wndTopMost really means it is always on top and can never have another app come
on top of it. So wndTopMost is often a poor choice. SetWindowPos would not be the best
choice here; SetForegroundWindow would be better.
On Sat, 11 Aug 2007 17:04:00 -0400, "SteveR" <firstname.lastname@example.org> wrote:
>...Call out to detect attaching files
Is there a method to write a callout to detect file uploads. i knoe that
when i file is uploading it's going to annotation entity. i have written
preupdate and postupdate methods to track this. but when i add a file the
event doesn't get fired and doesn't indicate the changes. later if i do a
change to the note then i'm able to see the changes.
can anyone tell me the reason...
On Aug 7, 2:34 am, Charith <Char...@discussions.microsoft.com> wrote:
> Hi All,
> Is there a method to write a callout to detect file uploads. i knoe tha...Macro to list all the format of a cell
Is there a way to find out the all formats of a cell? or all cells have a
Thanks in advance
This'll use the activecell's format and search for cells with that format:
Dim myCell As Range
Dim myKeyCellFormat As String
Dim rptWks As Worksheet
Dim curWks As Worksheet
Dim oRow As Long
Set curWks = ActiveSheet
myKeyCellFormat = ActiveCell.NumberFormat
Set rptWks = Worksheets.Add
rptWks.Range("a1").Value = "'" & myKeyCellFormat
oRow = 1
For Each my...