VBA Macro helpHi Friends,
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 OptionsHello all,
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.
Shhhh
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 workI 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.
--
dm
...
Macro compatibility in xls2003I'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
happens.
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
frustrating process.
Does anyone have experience with macros incompatability in excel 2003 /
suggestions that may narrow down this issue?
--
____________________
Peter Andersen
account_name@hotmail.com
_______...
Call in?Do new owners of Office X have to call up Microsoft to register their
copy? If yes, what's the number? thanks.
Ming <asdf@asdf.com> 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.
Corentin
--
- 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 reportingAnyone 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?
thanks
...
Save Macro with date in nameHi,
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", _
FileFormat:=xlText, CreateBackup:=False
How can I get the file name for April to be;
Monthly Accrual Upload - APRIL - 20101604
Thanks
Rick
Use Format() as below
Msgbox "Monthly Accrual Upl...
Macro to insert blank linesI 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
1974...etc.
--
Terry, West Sussex, UK
try
Sub InsertRow()
For i = cells(rows.count,"a").End(xlUp).Row To 2 Step -1
If Cells(i, 1).Value <> Cells(i - 1, 1).Value Then
Rows(i).Insert
End If
Next
End Sub
--
Don Gui...
Recording and Deleting a MacroI 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 macroHi,
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.
Help Please!
Khalil
...
Using VBA to assign a macro to buttonI'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 callswhen 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
...
Calling MacroHi All,
I have macro like this
sub unique()
''''''''
''''''''
Counter_item = 0
For Each Item In nodups
counter_item = counter_item + 1
bic_var = Item
Call Ps_Match
Next Item
end sub
I have another macro
Sub Ps_Match()
'''''
'''''
If counter_item <= 1 Then
call another_macro()
end if
end sub
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 CallHow 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
functionality.
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.
=======================
John O'Donnell
Microsoft CRM MVP
http://codegallery.gotdotnet.com/crm
"SAM" <SAM@discussions.microsoft.com> wrote in message
news:DE...
Creating macro for find and replaceI 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
hidaya,
It would help if you would post your code.
HTH,
Bernie
MS Excel MVP
"hidaya" <anonymous@discussions.microsoft.com> wrote in message
news:225d001c45cca$f74af350$a001280a@phx.gbl...
> 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 MFCHey guys,
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
--
sgods
-----------------------------------------------------------------------
sgodse's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1457
View this thread: http://www.excelforum.com/showthread.php?threadid=27253
Hi
if you set the security level to 'Low' you won't get these warning
message. BUT I wouldn'...
macros turned off helpI 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
anymore
looked up help but can't find simple "to turn macros on"
any help appreciated
thanks
---
Message posted from http://www.ExcelForum.com/
Have you tried closing and reopening the file?
Richardjs60 wrote:
> 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?Hello All
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)
Else
....
Most of the time this works fine, but for some...
Macro needed, Two saves in OneHi,
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.ActiveDocument.Save
then this
Application.ActiveWindow.Page.Export "C:\Documents and Settings\Visio
Stuff\PNG\SameFileNameAsVisioFileName.png"
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 ?)
Jojo
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
Eric
Public Sub UpdatingLists2()
Dim WkbkName As...
Unable to get DxgkDdiRecommendFunctionalVidPn call in windows 7I 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 SetWindowPosIn 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
installer
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.
joe
On Sat, 11 Aug 2007 17:04:00 -0400, "SteveR" <srussell@removethisinnernet.net> wrote:
>...
Call out to detect attaching filesHi All,
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...
Thanks,
Charith
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 cellIs there a way to find out the all formats of a cell? or all cells have a
particular format.
Thanks in advance
Ashish
This'll use the activecell's format and search for cells with that format:
Option Explicit
Sub testme()
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...