I have a bunch of documents with a template-path to a server
"\\Server1\Office\Section_2\Templates\Template.dot" <-- one of them.
How can I replace the path to "blank" or another path?
I want something that doesn´t have to open the documents, just replace the
I search google, and found a bunch of VB-scripts that doesen´t work at all!
How can I fix this? I have 1000+ documents and its making me nuts.
It takes 5 min to open a document.
If your documents were in Word 2007 (docx, docm) format, you could edit the
xml out...Count the number of characters created by string text
Is there a formula that will count the number of characters, and spaces
between characters, in a short paragraph created by a string text? It
is acceptible if spaces cannot be counted. Thanks.
Answered in another group you posted to.
In article <firstname.lastname@example.org>,
> Is there a formula that will count the number of characters, and spaces
> between characters, in a short paragraph created by a string text? It
> is acceptible if spaces cannot be counted. Thanks.
...Getting the path of Temporary Internet Files
How can I get the path of the Temporary Internet Files folder in MFC?
Take a look at the following APIs.
Check Abdoul [VC++ MVP]
"Mystique" <email@example.com> wrote in message
> How can I get the path of the Temporary Internet Files folder in MFC?
here is what i came up with...Filename and path or a handle on mouse click
Is there a way to obtain a filename and path (or just a handle of a
file, but without knowing its name nor path) of a file(s) selected on
the desktop (with LEFT click). As far as I know there's no such api
function. "Shell extensions on right click" are NOT what I'm looking
for... When I click a file in any window, Explorer runs a few functions
like ReadFile, CreateFile and in some magical way gets it's name and
path. I searched the web but with no luck. I could make a filesystem
hook and intercept calls on functions like ReadFile or CreateFile, but
I would need only...SHBrowseForFolder
I want to set the pidlRoot member of the BROWSEINFO structure to
a default location. How do I get a PIDL from a path represented
by a text string like this: _T("C:\Program Files")?
I'm not certain about the pidl for an arbitrarily named folder, but if your
real interest is the "Program Files" folder, then you shouldn't use a text
string anyway, since the text is user-selectable and in fact changes based
on language locales.
For "Program Files" and other special folders, you can get the pidl using
the SHGetFolderLocation function, passing in a CS...Fastest way to insert 6MB of strings into 64MB List of strings?
It seems to take about 30 seconds to insert only 6MB of strings into
random locations in an array of about 64MB of strings. This is way too
slow, I need to be able to insert objects into a large list much much
faster. Any tips?
static void Main(string args)
Random rnd = new Random();
List<string> db = new List<string>(6710886);
for (int i = 0; i < 6710886; i++)
db.Add(rnd.Next().ToString() + "," +
int ...Get the file path from Textbox
i want to get the path of file from textbox and then attach it to already
opened window(it would be a Plugin)i am unable to get is it possible i give
file path in Textbox and on clicking a button on form say "Attach it",it
attacch file on mail window?
Message posted via http://www.officekb.com
...full UNC path in footer
How do I display the full UNC path (i.e. \\server\home\user\filename.xls)
instead of the mapped drive path (x:\filename.xls) in the footer of an excel
(or word) document?
All of our user's home folders are mapped to Drive X and when they put the
path on the footer of the document they are looking on, it shows
x:\filename.xls. It is not a problem if you know who printed the document,
but if you don't, then it is a pain to search for that particular document in
all the users' home folders
There is an article at MS to get a UNC Path
http://support.microsoft.com/kb/q151027/...why put a string be put in the string table and not a header file?
I have found it is easier to work with string defintitions that are placed
in a separate header file (i.e. files with extensions '.h') than placing
them in the string table. For example, all error messages can be placed in
a file named 'ErrorMessages.h'. If different languages are to be
supported, one could create a separate header file for each language (e.g.
EnglishErrorMessages.h, FrenchErrorMessages.h, etc). It is easier to work
with a simple header file than the string table. Furthermore, using the
resource editor to edit a string table is a slow and tedious work,
p...Can i convert numbers into string format?
Is there a way in Execl (2002) to convert numbers into string format? For
Example 1234 to "One thousand two hundred thirty four".
This is one of the features included in the free ASAP Untilities' add-in.
There are loads of other useful functions included as well. Their address is
"talia_k" <firstname.lastname@example.org> wrote in message
> Is there a way in Execl (2002) to convert numbers into string format? For
> Example 1234 to "One thousand two...new string started on PF contact folder issue
Thanks so much for taking the time to look at my
I wanted to clear the air on my original message, I
think it had some confusing/incorrect syntax.
As I re-read my post, it doesn't make sense, so I'll
Forget all the references to the GAL as in my 1st
When the SBS server user creates a PF containg contact
items, by default the properties/OAB tab/'show this
folder as an email address list' ISN'T ticked.
When he does tick it on the server-side, the Outlook
2003 clients open a new email clicks on To: and in the
address lists available, the newly c...SHBrowseForFolder Subclassing.
I would like to change the name of the "cancel" button. Is that
possible with Subclassing, Superclassing, etc.?
Maybe this article can help you:
"Bruce Arnold" <b_a_r_n_o_l_d@b_l_a_s_t.n_e_t> ha scritto nel messaggio
> I would like to change the name of the "cancel" button. Is that
> possible with Subclassing, Superclassing, etc.?
And this too:
http://www.codeproject.com/dialog/browse...get the running path
i know there was an possibility to get the application exe path from the
main args. But I do not remember how to extract the information. Could
somebody give me the example?
hi holger, try this
GetModuleFileName(GetModuleHandle(GetExeName()), szPath, MAX_PATH);
kind regards, muechel
Dont remember which one will give the path.
Holger Krei�l wrote:
> i know there was an possibility to get the application exe path from t...string value
I am using a loop to iterate through a list and sometimes need one vbTab in
the code, other times need (2): vbTab & vbTab :
For each Tcolumn in rs.Fields
strMy=strMy & vbTab & column.Name & vbCrLf
How can I do this? If I use a variable, it is not recognized by Access as
the vbTab code.
strMy=strMy & vbTab & iif(Needs2, vbTab, "") & column.Name & vbCrLf
Replaces Needs2 with an expression that is true when you need two tabs.
Don't Print - Save trees
> I ...Converting A String to a Column of Data
I have some strings like this (some are as long as 4000 separated values):
I am looking for a way to convert these strings into column data like this:
Thank you in advance.
Data - Text to Columns, delimited by semicolon.
Select Data, copy, paste special - transpose.
"carl" <email@example.com> wrote in message
>I have some strings like this (some are as long as 4000 separated values):
> A;AA;AAI;AAP;AAP...CRM 4.0 Outlook installation error "The network Path was not found
I'm trying to install crm 4.0 on outlook 2007.
I keep getting an error at Databaseinsaller.progressmessage
"Action Microsoft.Crm.Config.Common.InstallDatabaseAction failed.
The network path was not found."
I read that if I add the user to Server Surface Area Configuration utility
it would work, but it did not for me.
I'm running vista ultimate and windows 2008 64 bit.
Any help is appreciate it. I can't believe that this install is so
difficult. What gives!!!
I created an executable file that opens a .pdf file. The path I use
is "MyFolder\\MyFile.pdf". However, when I installed the .exe and
MyFolder in the same location it did not open the .pdf file. However,
when I put the FULL path to the .pdf file it worked fine. Do I need
somthing like the following? "..\\MyFolder\\MyFile.pdf".
Thanks in advance,
Are you running the exe through a shortcut? Make sure the startup path is
the same as the executable path.
A better solution would be to get the path of the Exe and use that.
"...break a text string and export to cell range
I am creating a pricing list and from a few hundred possible optio
select only a small percentage. Those options are CONCATENATED into
cell and seperated by a delimiter (#).
Simply cell A1= option a#option c#option q#option r#
I need to break this list up so I can see clearly the selecte
How can I break this apart at the delimiter and place output in cells
c1= option a
c2= option c
c3= option q
c4= option r
If there is a better way to go about this Im open to suggestions.
Message posted from http://www.ExcelForum.com
I'd use the text to ...SHBrowseForFolder question
Ok, I managed to get SHBrowseForFolder to work and it pops up its dialog
box, but I would like to be able to use the info in a drop down combobox
integrated into my dialog form. Is there a way to do this. What I have is
a combobox that I want to show and select the path in, then a list box to
display the files, and another combobox to select which drive. I have a
specific reason to do it this way and I was wondering if I can use some of
the info from the SHBrowseForFolder to do this. It seems like I should be
able to, but I have not been able to find any helpful information on just
how...Extracting numbers of a string
I have many strings like 10+33+98+3+10 and 3+45+33+21+1, each one in a
diferent field of a sheet.
I want pass the values to individual fields, like A1 (10); B1 (33); C1
(98); D1 (3); E1 (10);
I try with MID, LEFT and RIGHT combinate, but the length of the string
is different in each string. I need something that remove the "+"
between the numbers.
Use Text to Columns and the "+" as the delimiter.
Using your sample data in A1 and A2. Select A1 & A2. Go to Data, Text
to Columns. Select "Delimited" as your option and click nex...Pulling out string below certain cells using if statement
Alright i have a huge list of names, cities, emails, numbers an
directory listing #'s. I want to somehow pull out all the names in th
excel sheet but the names arent' the same number of rows apart an
don't have a field identifier with them. The only consistency I coul
find is that the name is always directly below the directory numbe
which is always listed like abcd*********. So my question is, is ther
a way to do an if statement or something similar to this to say if yo
hit a directory number pull the cell above it to the right or somethin
along those lines. thanks for any sugg...Expanding string
my scripts are loading configuration settings from external XML files. My
problem is that I would like to support also variables in it, however it's
automatically saved as string.
Therefore $PWD is NOT folder, but '$PWD'.
As a workaround, I am using [string]$Var = Invoke-Expression, however it's
very easy to inject some code in it, therefore I would like to have just
something to expand string.
For regular environment variables (%var%), I can of course use
[System.Environment]::ExpandEnvironmentVariables, however I am curious if
someone knows a...Getting document name or path not valid msg
Operating System: Mac OS X 10.5 (Leopard)
I get a document name or path is not valid. Try one or more of the following: check the path to make sure it was typed correctly; on the file menu click open, search for the file using this dialog box. <br><br>I have tried the disk utility to no avail. This began happening with OS X updates (2 updates ago). If I follow from earlier postings, I should re-install office. Is this correct? I use Entourage and do not want to loose the emails as well as the word documents. Can I safely remove with the Rem...Relative path to linked graphic
Hi! Is there a way to specify that a linked graphic is on a relative path
(e.g., ...\images) instead of the absolute path that Publisher 2002 defaults
to? I want to move a document to another folder but the 100+ images in this
document will be a pain to update, although they are all in the relative
oooohhhh ouch 100+ images - not at all fun.
"���MS�Publisher���" <firstname.lastname@example.org> wrote in message
> oooohhhh ouch 100+ images - not at all fun.
I would like to extract numeric values from a alphanumeric field. I can't
find an example of what I am trying to do.
1. Cell contains "bpnth500unwumm". Looking for a result in a different cell
2. Cell contains "Natp350rummunw". Looking for a result in a different cell
3.Cell contains "napt450rummunw56". Looking for a result in a different cell
4. Cell contains "a2000ronNa". Looking for a result in a different cell of
5. Cell contains c40bronmAA16. Looking for a result in a different cell of
I have sever...