I am trying to create a macro using VB. Here is what I want my macro to do :
I have file1 and file 2 saved in each monthly folder like
I have a spreadsheet like this
A B C D E
Date Unit No. Sale Amt Source1 Source2
9/4/2005 UN01 $2.00
6/8/2004 UN02 $3.00
10/5/2004 UN03 $5.00
My file1 like this
colum A colum B
Unit No Source1
Now I need go to file1 to find data for Colum D(Source1) by using vlookup
based on the unit number then extrive the data to colum D and times 50%.
So after I run the ma...convert Times New Roman Special G1 into arial
hello. I need to convert a text written with font Times New Roman Special G1,
which I downloaded from the internet, into a font availanble in most
computers, such as arial. Can you help me please? Thanks a lot. Fabian
This newsgroup is for questions about Access, the database product that's
part of Office Professional. I suspect you're asking about how to do this
with some other product.
I'd recommend reposting to a newsgroup related to whatever product it is
you're trying to use. If you are talking about Access, please explain what
exactly it is that you downloaded fro...Convert nvarchar to varchar
Is there a way to do this with DTS or another tool? I have an Access 97 app
and I'm converting the BE to SQL2K. The upsize tools all want to convert my
Access Text fields to nvarchar, but when I link them back to A97 this causes
problems. I manually changed a field to varchar and the problem disappeared.
But I have several hundred tables so I need a way to do this automatically.
We use the Access 97 upsize wizard, which doesn't do nVarChar.
We just modified it so th...Tim Sneed: How do I restore/repair a partially converted database?
If you don't put your question in the Message area, many of us can't answer
it. There's a little bug where hitting Reply with an empty Message causes an
Also the Subject often get truncated.
Please put a very brief description Subject and further explain in the
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
...VC++ .NET 2002: How To Use the Class View's Properties window to add a message handler for the WN_KEYDOWN message
I used "The EX05c Example: Scrolling" of the book "Programming With Microsoft Visual C++ .NET Core Reference" (6th Edition) as my 3rd example of MFC exercises to catch up my VC++ .NET 2002 (VC++ 7.0) programming. I started my 'Eg05c' project in the MFC Application Wizard and followed the 1 thru 7 steps instructed in the book (pages 82-85)
I believed I did the steps 1, 2 and 3 correctly: 1 - In MFC Application Wizard -Eg05c, I setthe CEg05cView to "CScrollView"
2 - I added the m_rectEllipse and m_nColor data members in Eg05cView.h by typing in "...Project...
I am working on a project to develop a live form on the network.
Basically it's for comunications between the depts. What I'm trying to do is
have a form to enter what the depts. are producing now and a sub form that
would display the info. after it's been entered. it did work fine when I go
from the main form to the sub form, but then when I go back the the main form
to update info, it crashes.
I used stream reader in the sub form to display the info and stream writer
for the main form to enter info.
so the problem or question is can I have a file ...Can i Convert a .pub file to a JPG file so printer can make progra
Need to know steps to convert .pub file to jpg file can it be done?
back doc wrote:
> Need to know steps to convert .pub file to jpg file can
> it be done?
What version of Publisher are you running?
Pub 2002 and later can Save As .jpg.
Maybe you could use a .pdf file?
Download and install the following free PDF Creator.
With your new program installed...open your project
in Publisher and go to...File / Print.
On your Print screen...open the drop window and
select PrimoPDF as your printer.
Click...OK...n....NET Classes: Visio Pro without VS
I own Visio 2007 Professional, but I do not own Visual Studio -- I
only have the Express editions. Because of that, I cannot reverse
engineer from Visual Studio to get .NET classes into Visio.
How can I get .NET classes into Visio Pro 2007 without the
functionality of an entirely separate product?
Unfortunately, you have no way to do it in Visio 2007.
You will need to have visio 2003 for enterprise architect, reverse and use
it in Visio 2007
Enjoy with Visio.
<email@example.com> a �crit dans le message de
I created a calendar @ work with a higher version of Publisher. I am trying
to access the file @ home, but I have 2000 and it says it can't open it.
What can I do?
You will have to save the calendar at work as a Publisher 2000 document.
"jabrjawz" <firstname.lastname@example.org> wrote in message
>I created a calendar @ work with a higher version of Publisher. I am trying
> to access the file @ home, but I have 2000 and it says it can't open it.
> What...Function for convertion of leters doesn't work.
I'm using function LOWER to convert string i my table on
small size but Access gives me a message that the function
is not defined.Please, do you know another function?
MS Access does not have a LOWER function. Try LCase() instead.
"Stenli" <email@example.com> wrote in message
> I'm using function LOWER to convert string i my table on
> small size but Access gives me a message that the function
> is not defined.Please, do you know another function?
...HTML Project 4 School
I'm working on an HTML Project at school for my Computer
Applications 1 Class, and one of the assignments is to
join a newsgroup. So I'm completing my assignment.The
computer won't let me view the other messages posted;
therefore I can't respond to any of them. So basically I
have nothing to say except that I'm trying to complete my
...VB Script on RM Sales Entry window
I added some VB scripting to the RM Sales Entry window. Now every time I try
to close after working in the window, it prompts to save or delete an
auto-filled document number. This does not happen with the unmodified
window. Does anyone know how to suppress this message? I can provide the VB
try setting SetChangeFlag property to false for the field it's complaining
> I added some VB scripting to the RM Sales Entry window. Now every time I try
> to close after working in the window, it prompts to save or delete an
> auto-...Project Manager 2007 queries
I am considering purchasing Proect Manager for my my Planner, we are a small
office who a familiar with the basics but have a few queries which are a
little more detailed, I hope someone may able to advise on:-
1. Reporting - What are the options for importing and exporting documents
and the number of format types, are they clear and easy to learn and use ?
2. Graphs - Is graphical data readily available, are there differing options
of graphs and are the tools for producing them clear and easy to use ?
3. Sand pits - Are there areas where 'offline' working is availabl...BSTR convert to unicode CString ? How ?
It seems that I SEE UNICODE ONLY when I browse the BSTR in the memory window
Once this code executes it IS NO LONGER unicode.
Any ideas ? THANKS !!!
hr = pIElement->get_outerHTML(&bstrHTML)
OK I am going in circles. I know BSTR is unicode. BUT I must work ( append data ) with the unicode string and eventuallly save it to file. What I have done so far is simply coerce the BSTR to an CString t hat seems NON UNICODE
Is there a way to make the unicode work with the CString class or do I lose the extra bytes ?? or I...Control the day & time in project accounting ( timesheet & equip.
We need to control the time sheet in project accounting as follows:
No same time should be allowed to be entered on the timesheet & equipment
log for the same project & cost category. In addition, the times should be
controlled in way not to allow an employee to work on 2 or 3 projects at the
same date & time. In addition, no equipment should be to work in 2 or more
projects at the same date & time
Joseph Abou Nader
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes....Beta MS Project 2010
When will be MS Project 2010 Full version Available? When can this
version expected to release?. Now MS project Beta is avail for download. Is
there any DVD or CD avail for order this beta version MS Project 2010.
This is a multi-part message in MIME format.
The beta download site is here: =
Retail versions should be available in June...converting numbers to time
I have a list of numbers:
I need these in the format:
I have tried text to columns but without the 0 before 830 the fixed width
line doesnt fall right.
Very stuck on this so any help would be gratefully recieved (otherwise I
have alot of work on my hands!!)
Assumes C5 has 900 and Time format set to 00:00:00
"FishandChips" <FishandChips@discussions.microsoft.com> wrote in message
>I have a lis...Convert column # to the letter of the alphabet
In the following code the uCol value is a number, I need the actual column
letter. Is there an easy way to convert the # to the correct column letter.
I could us an array or a function with a select case but I have at least 180
columns that have to be done. The code is used to determine the location of
a particular Agent's sales data for poping up a chart using that data.
uAdd = ActiveWindow.RangeSelection.Address
uCol = Range(uAdd).Column
uAdd = ActiveWindow.RangeSelection.Address(1, 0)
uCol = Split(uAdd, "$")(0)
Rick (MVP - E...Chip Pearson's VB Object references
I recently distributed a 2007 workbook that contained pop up calendars
courtesy of the Microsoft Office Calendar Control 2007. I foolishly assumed
that when a user opened the workbook, Excel would “realise” that there was a
Calendar control embedded and automatically enable the VB reference.
I was looking at ways to automate the enablement of the Calendar reference
object – I found this code on Chip Pearson’s site and wondered if a similar
thing could be run to automatically select the Calendar control? This code
enables the Microsoft Visual Basic Application Ex...Option to convert from text to mdb is missing
I just downloaded and installed Access 2003 from the MSDN site. I created
and opened a dummy database. Then selected File, Get External Data, Import
to bring a csv file into a table. But the Files of Type dropdown does not
have any text or xls options. Are the drivers missing? The help system says
they should be installed by default, but I'm stuck.
Also, I should mention that every time I start up Access, it says it is
"Preparing to install" then askes me to wait while it configures Microsoft
Office Professional Edition 2003. Install came to a successful conclusion
...Converting 16bit nand to 8bits???How???
I am having the omapL138EVM board and my board supports the 16bits nand
driver. but i want to create a 8bit nand driver . can anybody tell where the
nand driver file located and how to change into 8 bits.
Message posted via PocketPCJunkies.com
...Convert to Case
On one of our client's CRM systems, when we use "Convert to Case" from an
activity, the customer field is blank, even if the email/phone call was
already regarding to a client.
On our development system, this field is already filled with the previous
regarding account/contact, when we convert it, which saves some time.
Did someone has this issue? I have System Administrator role on both
systems, so privileges are not the problem.
Thank you a lot for any help.
...convert leads -> where are activities ?
whenever I convert a lead, that already has some activities stored to it
into a customer (company plus contact) all the old activities, stored to the
lead are not there anymore ...
what can I do ?
THX a lot
There is nothing simple that you can do - the activities do not come across
The simple option is to look at the details tab and follow the link to the
The hard way is to write a Post Callout COM object to check for creation of
a Contact/Account and copy any activities from originating leads.
"Ralf Ostholt...can you convert the 2007 menu format to the old 2003 format?
Is it possible to make this change within office. My mother s old and set in
her ways and is used to the 2003 format from her previous job but i have 2007
and it is hard for her to figure out.
"David" <David@discussions.microsoft.com> wrote in message
> Is it possible to make this change within office. My mother s old and set
> her ways and is used to the 2003 format from her previous job but i have
> and it is hard for her to figure out.
No, unless you purchase or find...MFC/VC/ATL/STL Goldmine has been updated: http://preciseinfo.org/Convert/index_Convert_mfc.html
Site search has been fully implemented. You can search the entire
site or collection or a single chapter related to specific context
to find what you are looking for.
We are currently out of sync with google.
So, if you do a google search you might see a different article
than what google shows. So, it is suggested to search the site
instead. First of all it is a much more powerful search than
what you can do with Google. Plus you are going to see the
MFC Goldmine collection contains the extensive collection of
articles going back several y...