Vlookup in vba
I have the following snippet of code:
ActiveCell.FormulaR1C1 = "RVU"
Selection.AutoFill Destination:=Range("E2:E" & LastRow),
This fills about 5,000 rows with look up data from the rvu ws, and puts in 0
if #N/A is obtained. HOWEVER, if I was ...Does anyone use ArcServe 11.5 for Restoring
We have a problem when restoring a the exchange database with Arcserve 11.5.
This works the first time 26 hours after the backup.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Restoring exchange database"
<Restoringexchangedatabase@discussions.microsoft.com> wrote in message
> We have a problem when restoring a the exchange database with Arcserve
> This works the first time 26 hours after the backup.
...importing data using a macro
i wish to import 300 fields of data into a spreadsheet
from a text file, but since spreadsheets are only 250
fields wide. i was wondering if there was anyway of
writing a macro that could import the data vertically, so
its all in one column or transpose it during
importation. the cut and paste method is possible but i
have 200 of these text files to import into this
spreasheet and don't think this method would be best.
thank you time and any effort that you spend on this
matter its been much appreciated
I suggest you use Access to do this kind of job. With Access, you ca...Using Service
We’ve been using CRM 1.2 Sales Professional. We want to use the CRM Customer
Service product (actually Suite Professional) now but our service mgr is hung
up on one requirement. Currently, when a customer sends a request or
question to firstname.lastname@example.org, they get a standard template email BUT it
has a ticket number in the subject line.
I’ve been told that we must have this functionality with CRM. I’ve also
been told that this is a complex customization that would not be easy.
This seems like very basic, common functionality. Is this really a complex
Ple...how to get the row and col count of a TMGrid using sendmessage?
I have a 3rd party application which uses TMGrid, I want to get the
row and col count of this TMGrid using SendMessage. The Parent Control
is a TTabSheet. Anyone know how to do it?
I tried the LVM_ message, but failed.
try to find out what messages this control can
handle, e.g. with Spy++. Just give it a try,...
Beste Gr�sse / Best regards / Votre bien devoue
Microsoft Live Space: http://kerem-g.spaces.live.com/
Latest Open-Source Projects: http://entwicklung.junetz.de
"This reply is provided as ...using outlook,how can i check my message has been sent?
after you send a message check in sent items folder
"learner" <email@example.com> wrote in message
...Using Split Window with CDHtmlDialog
Hello, I'm just curious if anyone has tackled this issue in the past.
I have a split window application that is working fine with regular
form dialogs. But there are a couple views that I 'would have' liked
(although I'm about to give up) to have been HTML based, so I add an
IDD_FORMVIEW dialog, then used the MFC Wizard to add a class with base
class CDHtmlDialog, instead of CFormView class like my other dialogs.
I'm still trying to become familiar with basic C++ concepts here, so
excuse my ignorance, but what happens at this point is that the Window
does't get filled...Defined range using more than one column
Can anyone tell me if it is possible to have two or more columns in a
defined range. I want to have a dropdown validation list where two or more
columns of data is displayed on the dropdown list. When an item is selected
in the dropdown list only one of the columns data is displayed in the cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down please let me know.
You can have a defined range with two or more columns, but that won't show
up in Data=>Validation using the list option. You might want to look at the
We are currently running a Win2k3 server running our DNS, AD, DHCP and
Fileservices. Our CTO does not like the way our file system is setup
and is looking for new solutions. SOme of his issues are Security,
Difficulty finding documents - including those of employees that have
left where you can't ask the person where they put something, along with
some structural issues as in seeing folders staff doesn't have access
Some solutions that came to mind were using an encryption software such
as PGP for certain folders such as the Management etc.
For search pr...Paste chart to word-lose bold type
When I paste my chart into msword, the bold type on the x and y axis is lost,
though the title remains in bold.
After copying, open Paint and paste it there. From Paint copy it again and
paste it in Word. The format will remain.
> When I paste my chart into msword, the bold type on the x and y axis is lost,
> though the title remains in bold.
...Using modal window??
I have several dialogs that interact with each other through buttons.
When a certain dialog appears I want it to be the focus until it is
destroyed. The user should not be able to click anywhere in the
application apart from this dialog.
I currently have this working but the user can still click on the
originating dialog, any ideas?
Thanks in advance
Seems like you are using Modeless dialogs, why don't you use modal dialogs
"wallacej" <firstname.lastname@example.org> wrote in message
> Hi...E-mail merge using Word
Simply stated, I have completed the e-mail merge using Word's merge task wizzard. All looks good. The final window asks me to map the To field, Subject line, etc and I hit OK. Then.....no e-mails are sent. I used my own e-mail as a test and recieved nothing. I am using Outlook 2003. Does anyone know why the e-mails are not being sent??
What do you mean "map the To: field?" What do you select? What happens?
Hw is your Outlook Address Book configured?
What is your default mail program?
"Fred" <email@example.com...using old Gift certificates on our new RMS
Ok, I have just transfered to RMS from another POS system. We couldn't
export our old gift certificates to the new RMS, but they are still out there
and being redeemed. The problem is they have already been sold and we need
them in our system. We have tried a discount on a sale, but that only takes
money off the sub total and shorts the taxes owed on the total. How do we get
our old gift certificates in our new system without taking in money and
effecting our bookkeeping, and having allowing our customers to use them. We
also tried to enter them as vouchers and in a payment optio...Problem having VC++ reading from Internet Using session.OpenURL
I have a program that use to work but now doesn't. It's a simple c++ program
which reads a website if you supply an URL. When it worked I was using a DSL
interconnection, however now that I'm trying to use a dial up connection I no
longer is working.
It's a simple program which uses the following to open the connection to the
pFile1 = session.OpenURL(url, 0, INTERNET_FLAG_TRANSFER_BINARY |
INTERNET_FLAG_KEEP_CONNECTION| INTERNET_FLAG_RELOAD |INTERNET_FLAG_DONT_CACHE);
Now everytime I check pFile1 it is a zero. What am I doing wrong, or is there
something which got...save a document where fields be used but not altered
I have careated a documents that need to be saved but not as read only. The
feilds are needed, such as a form. How can I save this material so the
format remains but text box alterations and movement areno longer on the page.
There isn't a surefire way of locking the form, but you might want to try
this as a workaround. Once the form is complete, group all elements
together. Then reduce the viewing size down so the entire pasteboard area is
visible on your monitor. Draw a single line from the top of the pasteboard
area to the bottom and then a second line from side to side. Move t...What kind of function should I use?
I was wondering what type of function should I use in the xml reports for
the receipts. I need a rounding function but I can't find info on which
language or standard they use.
DO NOT DELETE THIS QUESTION PLEASE!
Good morning Julien,
Thank you for posting your rounding question.
Can you please let me know what you are trying to round?
Or is this related to your question about discounts?
Microsoft Online Support Engineer
Get Secure!...How can I set a cookbook using publisher?
I need help setting up a cookbook for my church can anyone help
> I need help setting up a cookbook for my church can
> anyone help
File / Page Setup / Booklet / Landscape / OK.
Automatically insert Pages? Yes.
For additional pages...go to...Insert / Page....
Specifically what kind of help do you need? Have you decided on what you
wanted the end product to look like? The size, how it's going to be
MVP Microsoft [Publisher]
"churchlady" &l...Select which file to use in Integration Manager
I would like to be able to select the file that is to be imported with
Integration Manager at the time the integration is run. Is that
possible? Or can it only be set up for one file. Thanks for any help.
You can use vbscript to prompt you for the file name.
You could use IM to use the standard Graphical UI to open file etc but that
can get complicated...
"Bob Harrison" <firstname.lastname@example.org> wrote in message
>I would like to be able to select the file that is to be imported with
> Integration Manager at th...Business Portal and SSL using Sharepoint.
Ok, I am having a difficult time getting SSL to work on my Intranet Business
Portal website. I am using my own CA authority, and I created the
certificate but I cannot get SSL to work with BP. Has anyone done this
before. I would love to talk to someone who has actually implemented this
after installation of BP.
Thanks in advance.
Can you provide more information about the difficulties you are having?
"Lucia" <email@example.com> wrote in message
> Ok, I am having a difficult time getting SSL to work on my Intranet
...Passing a value in VBA using an offset
I have code that executes when I double click on a cell. The code
inserts the data validation source into a combobox to ease the input
choice. It refers to the cell I double clicked as "target"
I want to add a new feature. Before anything else happens, I want to
filter the data validation source (many of the entries are for dates
that don't apply. the cell above "target" has a date. I want to copy
the month of that date into a fixed cell ("A1") and then use that date
in an advanced filter on the data validation source. Hope you're with
me so far.
T...CMOS Battery Type
Could anyone assist, I wish to make sure I get correct replacement CMOS
battery before I remove old one. My board is ECS Sis 735KS5A Is there a
reference chart available please, unless you know type.
Thank You Roger in UK.
"Roger" <Monkey@Zoo.fsnet.co.uk> wrote in message
> Could anyone assist, I wish to make sure I get correct replacement CMOS
> battery before I remove old one. My board is ECS Sis 735KS5A Is there a
> reference chart available please, unless you know type.
> Thank You ...Outlook Web Attachments of specific type gone, only paper clip pre
Our voicemail system integrates with exchange via Native POP3 Connector. All
voicemails are attached to emails as voice.lvp. In the beginning the
attachments were there, now they have disappeared. OWA is configured to allow
all attachments and the ext. is not in either level 1 or 2 types. The email
displays a paper clip showing an attachment but once you open the email, the
attachment field is comepletely blank. I have tried everything.
We are having a similar issue that has started since we installed SP3 on our
exchange server. But it is with random attachments. I have searched and
...How to get the type code for a custom entity ? MSCRM v3
I created a new entity Called PRITem.
When using theSiteMap.XML I need to specifity the EntityType to show it.
Ity appears (Automatically) in the workspace.
But i can't use it in the SiteMap.XML because i can't find the number.
<SubArea Id="nav_activities" EntityType="4200"
Icon="/_imgs/ico_16_4212.gif" Url="/Workplace/home_activities.aspx" />
<SubArea Id="nav_calendar" Icon="/_imgs/area/18_calendar.gif"
Clie...Spreadsheet (use for test)
I need help (direction) in creating a 50 question test in excel. I would
like for the tester to select the answer for each question (multiple
choice). At the end of the test, a button that will grade the test (Pass,
Fail, Miss est..). The person taking the test can not go back and change
answers. The test result to be cumulated (placed) on a hidden spreadsheet
by name and score.
I would need to change (rearrange) the test once and awhile. Is Excel the
right program or would word be better? I would have (run) the file on a
floppy, jump drive or shared drive. Please help if you ca...Changing username using the registry.
I'm trying to figure out how to change a users -username- for Exce
using the registry. I'm needing to change username's of people withou
disturbing them -like anyone wants to know this-
Any help will be greatly appreciated
Message posted from http://www.ExcelForum.com