Convert PNG file to Bitmap without a DC?
I'd like to store images resources as PNGs due to the compression over
bitmps. To load such a resource and get it converted to a bitmap for the
eventual Blit to my screen DC, I basically want the equivalent of
LoadBitmap. Better yet, I was thinking I would create a CBitmap derived
class "CPNGImage" that would have a "LoadPNGResource" method much like
CBitmap's LoadBitmap method. So far so good.
The stumbling block for me at this point is that the process of converting
the PNG to a bitmap seems to require a DC compatible with my device. This
is neatly enc...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...access file to exe file
May i know the procedures on how to make access file to an
executable file. I read a lot of Access books from 97 to
XP versions but i was not able to find any.
thank you very much and anticipating your response.
> May i know the procedures on how to make access file to an
> executable file. I read a lot of Access books from 97 to
> XP versions but i was not able to find any.
I tried a number of converters to translate Access into Visual Basic, all
with limited success. Even when I was able to get a form working it required
as much time to tweek it a...Saving files when closing Excel
Excel does not prompt for saving changes when closing a file after changes to
the file have been done.
have you checked that there's no event macro in your file?
Jonathan Gold wrote:
> Excel does not prompt for saving changes when closing a file after
> changes to the file have been done.
...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...Inserting new rows into sheet
I am using the following code to insert a new row onto
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
This code will insert a new row above the current row number 5, which
is okay. My problem is that the new row has the same height and possibly
dimensions and formatting of row 4.
Can I basically tell Excel to insert a row of cells that are a default size
a size of my specification?? I dont want Excel to insert a row of cells
are the same dimensions of the above or below row. I realize that I co...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...Excel Icon for files
I am running Windows 2000 professional on my PC and connected to a LAN. I
am running the MS office 2000 Professional suite. When, I save a worksheet
from Exel 2000 it does not save the file with the common Excel file
Icon(green X). The file is displayed with the default Windows Flag Icon.
When I double click on this default Windows Flag Icon the system tries to
open the file with Word not Excel.
Word and PowerPoint both save with their common Icons. The Excel program
saved fine a couple of weeks ago. I have not installed any new software and
our server takes care of Virus protection thro...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Vlookups to Excel Version 3 files.
I use a system that on a daily basis creates an Excel
version 3 file containing cost centers and their budgets.
When I do vlookups from other Excel 97 files to this file
it takes a long time for the sheet to calculate. If I save
the Excel V3 file as Excel 97 its OK, and if the Excel V3
file is open before the 97 file its OK. I don't want to
have to constantly save the V3 file as 97 (I may not be
around to do that always)
Does anyone know how to resolve this.
...How do i change my file from a 2003 office doument to a 2000 docu.
i have done this before with a word document but i dont seem to be able to
figure out how to do it with a publisher document.... can anybody help??
File, save as, files of type, expand the menu to Publisher 2000.
Mary Sauer MS MVP
"me" <email@example.com> wrote in message
>i have done this before with a word document but i dont seem to be able to
> figure out how to do it with a publisher document.... can anybody he...I need a macro to find cut and paste data to new cell
I have data that I have exported to excel that I need to reformat to be able
to create a pivot table to check for duplicate entries.
On importing the data which is in the form of journal entries the memo line
is stting above the journal numbers in column D. I need to find all of the
comments and cut and paste them to column C. The comments are not all the
same but do contain the same word "To" in the comment. The journals are not
all the same size and so the comment line does not appear at regular
intervals. Any help appreciated as I am very new to VBA
...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...Register a file extension
I would like to allow my users to register my apps file extension from within
the app. I have managed to register the extension but the description isn't
being shown in explorer on xp or 7, I can not also get the icon to display.
Below is the code I found on the internet:
Private Declare Function RegCreateKey Lib "advapi32.dll" Alias
"RegCreateKeyA" (ByVal hKey As Long, ByVal lpSubKey As String, phkResult As
Long) As Long
Private Declare Function RegSetValue Lib "advapi32.dll" Alias "RegSetValueA"
(ByVal hKey As Long, ByVal lpSubKey ...How to create a .XLS file instead of a .CSV file
I have a COBOL program that generates a .CSV file regularly but I have
a problem in the .csv file my users want the file to be in .XLS
instead of .CSV is there a simple way I can turn my .csv file into a
..XLS file please advise.
Can my COBOL program put some structure to turn the .CSV file into a
Also, can somebody share a VB Script to turn a .CSV file into a .XLS
An easy way is to open it in Excel and then save it as a workbook.
You might just write a CSV file and name it with an XLS extension if the
main gripe is having to change the fileopen dialog to lo...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...Transfer files from money 99 to money 2003
We have a new computer with money 2003, old computer has
our records in money 99. We tried to import export but
the records to not come across correctly. What should we
You shouldn't have to export or import. Just move across your .MNY data file
and open it with the newer version. See http://umpmfaq.info/faqdb.php?q=68.
"Michelle" <firstname.lastname@example.org> wrote in message
> We have a new computer with money 2003, old computer has
> our records in money 99. We tried to import export but
> the...How do I set up another pst file with password ie Have a general .
I am running Outlook 2000, I wish to have a general folder for all to access,
and then my own personal folder, passworded....Is it possible???
What I would do is the following:
Go to Tools > Services > Add > Personal Folders. Then select location for
the PST on your hard disk and set a password for it. This procedure should
be followed, if the other users are using the same Windows logon to access
Alternatively you can choose to Delegate access to only one folder to the
users you need. To do this go to Tools > Options > Delegates to give...re re re ????
...WHY CAN I RECEIVE BUT NOT SEND IN OUTLOOK 2003 FROM A NEW DELL COMPUTER? pLEASE HELP
i USE AN OPTIPLEX 210, WITH VERIZON DSL AND MICROSOFT SMALL BUSINESS
EDITION 2003, WITH OUTLOOK 2003. Norton Internet Security SUite, with
DSL is not the problem I don't think. I can send out via an alternate
gmail pop account and in Outlook Express.
This doesn't happen every day, and usually when it does after 3-5 hours
of use of my computer.
I can still receive, but the SENT email gets stuck in my outbox.
I have to shut down my computer and start it up again and then I can
I had some memory problems indicated at shutdown, but no code that is
...Re: Where should be the best place to stored Applcation Data Files?
"Giovanni Dicanio" <gdicanio@_NOSPAM_email_DOT_it> ha scritto nel messaggio
> BTW: this post by John Robbins is very interesting reading:
copy-and-pasto - the correct link is this:
And then there's this Vista security discussion from last Friday (cool
On Fri, 8 Aug 2008 18:50:23 +0200, ...delete log files
have a filled up drive- no need for logfiles in this instance circumstance
would allow circular logging for next few months, before setting though, need
to reclaim space on hdd. how to tell which logfiles I can delete and not hose
> have a filled up drive- no need for logfiles in this instance
> circumstance would allow circular logging for next few months, before
> setting though, need to reclaim space on hdd. how ...