newbie , how can I use gdi+ lib
hi , I have downloaded and placed the gdiplus.dll in system32 directory of
and use loadlibrary("gdiplus.dll") to bring this up
however, the ide post me a complie error.
what going wrong for this,
Why don't you just statically link it into you project, put gdiplus.lib in
the objects bit of the linker settings, or use #pragma comment( lib,
"gdipluss" ) in your stdafx.h?
"Eric" <firstname.lastname@example.org> wrote in message
> hi , I have downloaded and placed the gdiplus.dll in system32...Macro to Fomat Excel to .csv File
I have an Excel spreadsheet with contact information I want to import
to a CRM lead system. Current Excel sheet format is all in one column
going down as follows: Company Name, Address, City State Zip (all one
field), Phone number, then empy cell then repeat of 4 cells listed
above. Want to convert to a new .csv file with listing going left to
right on on line as follows (ending up with 6 column fields - 1.
Company Name 2. Address 3. City 4. State 5. Zip 6. Phone
Any suggestions on how to accomplish this? Thanks.
...import data from Oracle database into Excel using vba
Has anyone an example of importing data from an Oracle database into
Excel using VBA?
...can't figure out the formula to use
I have a SS with 3 columns that look something like this:
A:(NAME) B:(Agency[Vlookup Result]) C:(Formula Result)
Jones, Joe Agency1 Agency1 A-M
Smith, Bob Agency2 Agency2 N-Z
Kid, Gregg Agency3 Agency3
Rohl, Jim Agency4 Agency4
**column B is a result of another sheet in the workbook...
I am trying to find a formula that would follow this
if the 1st letter in A1 is between A-M, and B1
is "Agency1" or "Agency2", then C1 will be 'B1&"A-M"'. i...what template should i use for collecting monthly payments from m.
...i get error 404 not found when trying to download
I'm trying to download nokia pc suite to windows xp to upload gallery onto
the computer but get error message404 not found - how can i download this pc
Krysy Albutt wrote:
> I'm trying to download nokia pc suite to windows xp to upload gallery
> onto the computer but get error message404 not found - how can i
> download this pc suite please
Care to enlighten us how this pertains to: -
If you're having problems downloading from the *NOKIA* site where do you
think you should be directing your ...Does any one ever use function capFileSaveDIB?
I use VS .NET 2003. I had connected to a USB camera. I tried to
capture the image. The function capFileSaveDIB is used. MSDN said this
function would return true if successful. I call the function like
int cameraCapture(HWND hWndofCap, CString pathCStr)
char* pathStr = "";
if (capFileSaveDIB(hWndofCap, pathStr))
I get the return value: 1. However, I don't get the picture where
pathCStr pointed. I don't understand.
Have you met this problem? I can't find out wh...How can I make a dinner seating arrangement using Excel?
I would like to make a seating arrangement for three round tables and 22
people using Excel. Is this possible?
...programs for shelter use
I am opening a animal shelter located in my county
and I want to find a program that may help me run my
shelter computerized. Any suggestions on any programs I
can use and where I may purchase those programs?
MACROS AND THEIR FUNCTIONS INTENDED
code written in visual basic to automate certain repetitive procedures
or certain other tasks that cannot be performed through the regula
functionality provided by excel/word, or some new customised functio
that needs to be created for a specific need, or to simplify
cumbersome task that would otherwise take a substantial amount o
effort... etc... etc... etc...
try to keep your questions outside the realms of juvenility. help is
privilege and not a prerogative
Message posted from http://www.ExcelForum.com
...Need help opening an Access DB using CDaoDatabase
When trying to open an existing Access DB (.mdb) I get the following
"Unrecognized database format 'C:\path...\database.mdb'
I am trying to use CDaoDatabase as follows:
Invoking the Open member function throws the DAO exception.
Thanks in advance,
"Jim Fleming" <email@example.com> wrote in message
> When trying to open an existing Access DB (.mdb) I get the following
> "Unrecognized d...Using two Network Adaptors
I have a new Windows 2003 R2 Standard server running Exchange 2003 Standard.
The server has two Broadcom 1Gbps network cards in it. I used the Broadcom
software to Team these cards for Load balancing and Failover. Unfortunately,
after running for a month or so I started getting errors where the Exchange
server couldn't reach the DC's. I removed the Team and am using just one of
the Network adaptors and everything is back to normal. It may be the other
adaptor is faulty and I will check that out next weekend.
What I would like to know is what is the best way to use this two ...Using my own letterhead on Pub. 2003
I am trying to create flyers using my own letterhead (saved in Word) on
Publisher 2003- how do I insert it into a Publisher template or document?
Copy/paste? Have you tried to recreate the letterhead in Publisher? You can save
as a template.
"WKaye" <WKaye@discussions.microsoft.com> wrote in message
>I am trying to create flyers using my own letterhead (saved in Word) on
> Publisher 2003- how do I insert it into a Publisher template or docu...Looking for POS for Grocery/Deli using GP. Anysuggestions?
...Can you perform ctrl+shift+; in a macro to display time?
I would like to add current but static time to a cell within a larger macro,
but the only way I can find to enter just the time and not date as well is to
use ctrl+shift+; but it doesn't appear that macro allow the use of hardkeys,
although my knowledge of macros is basic i'm sure there must be a work around.
Public Sub TesterC()
.Value = Time
.NumberFormat = "h:mm AM/PM"
"Darran Parsons" <Darran...Getting "Enter network password" when trying to administrating PF
We are now, suddenly getting "enter network passord" on the whole Public
Folder tree. If we change folder or trying to access the properties on a
We didnt get this until recently (last days)
Anyone that knows why we migt recieve this? It is exchange 2003 Ent.
...Blocking fields to avoid use in formulas
Is there any possibility to block the particular field in order to
avoid users to use invalid fields in formulas ?
You can lock and unlock cells (then protect the worksheet) so that users can't
change certain cells.
But if you allow them to type a formula into a cell, then I can't think of
anyway of stopping them from pointing at A1 when A1 shouldn't be used.
Is that what you meant?
If it is, maybe someone else has a way...
If it's not, maybe you should rephrase your question.
> Is there any possibility to block the particular field i...User-inserted external file path used to pull cell values
I have an organization that wants each vendor to fill out and submit a
net present value worksheet as part of the RFP process. Call it the
NPV workbook. The organization wants to then pull data from each of
those worksheets into a summary worksheet.
I would like for the organization to be able to input the file path for
each NPV workbook. Then the summary cells would use the file path to
pull the data.
What I have been trying so far isn't working:
1) Organization creates a hyperlink to each NPV workbook; example: Cell
B8 contains the hyperlinked string: F:\Emergent\Projects\03109 GSA
...How to Get OperatingSystem User using Macro
I would like to display the Operating System User
using VB Macro in Excel.
I am using Ms Office 2000
You can use Application.OperatingSystem to return a string describing the
operating system. E.g.,
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Mili" <firstname.lastname@example.org> wrote in message
> I would like to display the Operating System User
> using VB Macro in...Post disappeared -- "paid using the address information"
I posted this last week and I don't see my post or any replies.
What exactly does Money mean when it says "this payee is paid using the
address information"? Does it mean that MSN Bill Pay prints and mails a
check to the payee?
When I e-pay my Comcast bill, Money 2003 gives it a date that's two days
from now. My other e-pays initially get today's date in the register
(until the check clears, when it changes to the check cleared date). I
wonder why Comcast gets a different date than other e-pay'ees.
The Comcast bill has sometimes cleared two days after I e-...Can the IFS kit be used freely?
I know the IFS kit is distributed as part of the WDK.
Does it means the IFS kit can be used freely?
Or, shoud it be purchased? If it should be purchased, where can I buy
> I know the IFS kit is distributed as part of the WDK.
> Does it means the IFS kit can be used freely?
Maxim S. Shatskih
Windows DDK MVP
...How to convert numbers using dots into numbers using commas
I have an Excel sheet with a specific range of cells that contain numbers.
The format of these cells is "General" (so not "Number").
The numbers in these cells use dots (e.g. 4.2) while I work with commas
(e.g. 4,2). Does anyone know how can I convert the numbers into numbers that
If your system is set to use commas as decimal point you should be able to
select the range of cells with dots and Edit>Replace
Gord Dibben MS Excel MVP
On Tue, 5 Dec 2006 14:49:01 -0800, Martin <Martin@discussions.microsoft.c...Are Pivot Charts only useful with limited number of categories(x-axis)?
I'm brand new to Pivot Charts and trying to figure out what I thought
would be simple: I have a Column Chart with $Sales for the Y axis and
Salesperson on the X(category) axis. There are hundreds of
salespeople, which results in the chart displaying extremely thin lines
with totally unreadable category labels( salesperson initials). Is
there not a way to specifiy a gap between categories on the X axis? Or
some way to space them apart and be able to scroll the chart
horizontally? I have a feeling you are all going to tell me scrolling
is just a dream :)
...Macro to count inline images
I have to format about 10000 word docs that are generated from another source
for a test report. I have built a a macro to do the formating for me but I
would rather make it more automated. I have two differnt reports, the only
difference between them is the number of inline objects.
1. How do I count the number of inline objects?
2. How do I automate word to run the module on a directory (including
3. How to Save-as in order to maintain the originals?
For a given document, you can use a macro like:
Dim i As In...how can i produce regional maps with demographic data using excel.
I was wondering how can I use excel to produce regional/city visualization
maps with demographic data
This post might help:
> I was wondering how can I use excel to produce regional/city visualization
> maps with demographic data
You may be confusing XML data maps with the MS Map addin program that
use to be included in XL2000.
John Mansfield wrote:
> This post might help: