Explorer Dir Path
I need to get the full path of the currently opened directory in the windows
explorer. i.e. I've handle of the currently open windows explorer and want to
get the full path of the directory that has been navigated and also the list
of files that has been selected in that directory. Please anybody help me how
I can get the solution that can be used in Windows XP/Vista/7.
> I need to get the full path of the currently opened directory in the windows
> explorer. i.e. I've handle of the currently open windows explorer and want to
> get the full path ...how do I import a Quottro Pro 10 notebook file (.qpw) into Excel
I would like to import my worksheets and notebooks (.qpw) that I developed in
Corel Quottro Pro 10 into excel 2003.
Thank you in advance for your help and information.
...Reflect file path (show drive letters) in Excel 2000
If i am on a network environment and using excel 2000, i wish to reflect the
file location e.g. D:\project good\chart\book 2000.xls
How do i get excel 200 to generate the file location, other than having the
file name and sheet only?
Enter this formula, exactly as shown in a workbook that has been saved...
San Francisco, USA
"Alicia" <Alicia@discussions.microsoft.com> wrote in message news:64EB8582-FDFA-42E7-96B1-A762FC928676@microsoft.com...
> If i am on a network environment and using excel 2000, i w...Indirect function
I struggle to create a macro with INDIRECT function that would jump to
different cells. What cell I want to jump to depends on a currently selected
cell. This means I need to put a relative reference into the function.
Here is my function - I need to replace R1C1 expression with a realtive one
(currently selected cell address with the same behavior as R1C1 expression).
How can I do that?
Application.Goto Reference:= _
Whatever I do I get follo...Sending mail from a Public folder
My customer wants to send email from a public folder. Theyt want the mail to
look like it came from Surveys@company.com. They would like it so multiple
people can send from this public folder.
Any ideas how to do this in Exch 2003
Grant Send as Permissions to the PF.
On Mon, 4 Apr 2005 13:43:05 -0700, "jwilmer"
>My customer wants to send email from a public folder. Theyt want the mail to
>look like it came from Surveys@company.com. They would like it so multiple
>people can send from this publi...Online Cliparts can not be imported.....
Operating System: Mac OS X 10.5 (Leopard)
Did anyone tried using the great online clipart feature of MAC OFFICE 2008?
it took me 5 mins to find out, this is a DEAD Feature...how come MS is not able to find this?
try downloading the cliparts from MS site...
Is there anyway this can WORK?
Microsoft MAC BU
Please change the default download file extension to .cil for clipart download site....so atleast it can be manually imported....im not sure how long it will take for you to resolve automatic import...
it is probably few lines of code change...why do you ex...Retrieving XML from SQL Server with Mapping Schemas
Anyone has any advice how to create XML file from SQL 2000 using mapping
...Import 2 profiles Question
I had to reinstall a new harddrive. I backed up my outlook.pst file to an
external harddrive prior to the installation. My outlook was set up with 2
profiles (Jane and John) so I get the prompt when I click on outlook to
determine what profile to logon as. How do I import the correct files to the
correct profile. Each time I try it I only get one. For example if I enter
as Jane I get Jane and if I enter as john I get Jane's stuff. I hope this
Change the Personal Folders file that John's profile uses. Check here:
Control Panel > Mail applet > Data files
&q...How do I import e-mail files into Microsoft Publisher 2003?
I receive files thru the internet that I need to get into publisher and
change the size, or add data. How do I save them to get them into Publisher?
How do I get Word files into Publisher for editing?
"Publisher Fan" <Publisher Fan@discussions.microsoft.com> wrote in message
>I receive files thru the internet that I need to get into publisher and
> change the size, or add data. How do I save them to get them into
> How do I get Word files...ExchangeIS Schema Changing?
I'm temporarily in an environment that is using Trip Wire Mangager 4.5 to
monitor some of it's servers. Most alerts are false positives that can be
cleared. One, however, is appearing daily and cannot be cleared it indicates
has changed. I've checked the KB and Googled to see what may be causing this,
or how it works, but can find nothing. Is this a schema that would change as
part of its everyday operations?
Also, when comparing two day's errors, the changes are DACL changes,...combining related data into one row of data
If I have a table like this with fields and data like this:
Acct - Name ------ value1 - value2 - value3
How can I get a query result like this?
Acct - Name ------ value1 - value2 - value3
123--- Bob, Sue------20------------20--------20
Any assistance greatly appreciated!
On Aug 2, 4:54 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com>
> There is a generic concatenate function with sample usage athttp://www.rogersaccesslibrary.com/OtherLibraries.asp...relative path...
Using VC++6, I have created an MFC application. My .exe utilizes an
outside folder named 'MyFolder'. Presently, I have used the following
code in my .exe to access 'MyFolder':
CString InitialPath="C:\\Documents and Settings\\Main\\Desktop\
'MyFolder' is located in the same folder as my '.exe' What relative
path could I use so '.exe' can access 'MyFolder'?
Thanks in advance,
"RAB" <firstname.lastname@example.org> ha scritto nel messaggio
news:email@example.com...importing multiple text files into excel???
I am experiencing a big problem. As a part of my analysis for PhD I have to
analyze more then 1000 files. The data that I have is in text files. To be
more precise, I have 5 different data sets, from different meteo centres,
each centre has a data set of 365 files for each day during the year. The
format of text files is something as following:
Camborne Met. Office
WINDS rev 4.1
50.20 -5.30 88
02 01 01 00 00 23 0
29 3 35
07:09 (3.0) 07:09 (3.0) 06:08 (3.0)
284 284 65 65 400 400 23 23
12.5 12.5 1 1500 1500 35 35 400 400
43 90.0 43 74.5 313 74.5
HT SPD DIR Radials...
0.101 9.8 113 0.0 ...How to add column(s) that show Yes or No indicating whether that record came from a related table
I had to merge three tables together, and now a request has been made
to show (in the merged flat file) in which report the data exists. So
I will be adding three columns, and there needs to be a streaming Yes
or No in each column, indicating whether the Person's name matches to
Is there a way to do this? I am stumped, but mainly b/c I am new to
Access and am learning how to connect some of these queries to result
in the desired output.
Any suggestions would be appreciated.
> I had to merge three tables together
Why? As in why would you want/need to do that? That is comp...Public folder attachments
We have recently migrated to Exchage 2003 and upgraded our clients to Office
2003. We have having an issue where when clients access (using Outlook) an
attachment such as an excel spreadsheet that has been posted in a public
folder it is opening as read only - no matter what the clients permissions
are set to. Even when I create a new test folder and create a post with an
attachment, afterward when I try to open the attached document - the first
time it opens okay - but all subsequent times it opens as read only. It
seems that it may have something to do with the way office is opening (or
n...I want chart source data to be relative references, not absolute.
Everytime I try to enter the chart source data as a relative reference, Excel
automatically adds the dollar signs to make the references absolute. I have
12 groups of columns repeating data above the graphs. (The rows and the
columns are identical, except for the data entered in the variable cells.)
If the cell source data were relative, I could copy the original chart over
11 times and be done. Since it is not, I have to go in each chart and
manually edit the source data to adjust the column references. This is a
pain. Also, if we delete or add any groups of column data, which we...Sending email as HTML
I would like to send email from my application by loading HTML file as a
Everything worked fine until i added <IMG> tag with SRC option .... so if I
<IMG > it's ok... but if I put <IMG SRC='http://<some address here' > then
I get : The given path's format is not supported.
Example which failes:
Would any one know why I can't send email containing absolute link to the
Is this some securit...Named Range that uses "relative" range
BTW - Excel 2003.
I have some data in a table with a column for Jan (column A), Feb (column
B), etc. for Sales in Jan, Feb, etc. In the past, I had array formulas that
added up each month as needed, using an Array Sum, starting with Jan formula
were refer to A$1:A$99. As I copied this formula for Feb, the range I added
up was relative, so changed to B$1:B$99, etc.
Now I am trying to switch to some cleaner Named Ranges, such as Sales_Jan,
Sales_Feb, etc.). My add Array Sum formulas have been changed to use the
Named Ranges. Unformtunately, my formula for Jan uses Sales_Jan, wh...Prove important update
Content-Type: multipart/related; boundary="unbeaeaqtdp";
Content-Type: multipart/alternative; boundary="oaejnupqc"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to help protect your compute...Importing Netscape Mail folders
I'm unable to import my Netscape mail folders into
Outlook 2000. I know how to locate my Netscape profile on
my PC and using the "import wizard", once I select that
folder, it tells me that 0 messages were imported...
Use Outlook Express as an intermediate step. Export to OE, Import into
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer,...Importing from Access issue
When I import a table from Access (either through a TransferSpreadsheet of a
table or a manual export) for some strange reason, the fields do not stay in
the same place as they are in the Access table. It appears to be an Excel
issue but I cannot figure it out. For example, I have an Access table that
has, say, 5 fields....Field1, Field2, Field3, Field4, and Field 5. It is
possible for a field to be blank for a given record. Everything is fine in
the Access table. When I use the macro or manually export, Field 5 data shows
up in Field4 IF Field 4 is blank. Otherwise, Field4 contains Fie...import from money deluxe 2002 to money standard 2004
I have some money files to import into money standard 2004. they were
created in money deluxe 2002, the import does not import the file into
standard. I cannot find any information about imports or I may be looking in
the wrong place. any suggestions.
In microsoft.public.money, hello wrote:
>I have some money files to import into money standard 2004. they were
>created in money deluxe 2002, the import does not import the file into
>standard. I cannot find any information about imports or I may be looking in
>the wrong place. any suggestions.
Do not use...Duplicate a chart with relative formulas
If I have several sheets, each with data for a particular year, how can I
copy a chart from 1 year to all the others, making sure the data references
are to the respective year?
Duplicate the sheet that has the chart, then replace the data on the
Peltier Technical Services, Inc.
On 3/23/2010 9:29 PM, Bobhoe wrote:
> If I have several sheets, each with data for a particular year, how can I
> copy a chart from 1 year to all the others, making sure the data references
> are to the respective year?
...Accessing Public Folders internally
We are using SBS 2003 with Exchange.
When our users in the office want to access a Public Folder through a web
browser http://server/public/ it asks for their login details.
I thought that the user would already be authenitcated as it is an internal
It depends on whether you have Integrated authentication enabled or not on
the Public virtual folder.
"David Dixon" <firstname.lastname@example.org> wrote in message
> We are using SBS 2003 with Exchange.
&...Importing from Maximizer to MSCRM
Has anyone experience importing data from Maximizer into MSCRM? If so, is it
easier to use something like Scribe (you still have to import to a .csv file
first), or stay with the Data migration Framework? Is this more complicated
than importing from other databases?
I have no experience with Maximiser but assuming you can get the data out
into a usable format that you have multiple options
write your own code to import
look at scribesoft to see if their products can handle the import
Use the DMF.
How easy is the maximizer database to user? for example which ...