Exporting file names to an excel spreadsheet.
I have a folder containing many many many .pdf files.
Is there a way to export the filenames of these .pdf files into an
If this is a dumb question, I apologize. I didnt have any luck
searching for the answer here.
Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611
View this thread: http://www.excelforum.com/showthread.php?threadid=547520
I use Jim Cone's fine Add-in called "ListFiles"for this sort of thing. It's
available free (a...How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from
the following XML file:
<?xml version="1.0" encoding="utf-8" ?>
There will be more data than just a name for each Parameters node. Here is
Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...Multiple PST Files #2
I am running Outlook 2003 and would like to have Outlook use two
different .pst files (one for my work stuff and one for home) on the
same computer. Is it possible to do this?
If so, can I can I configure one of the pst files to get e-mail from
one account, while the other pst file is configured to get mail from
the other account?
Yes, you can create multiple PSTs. I keep mine stored in
the same file location but with different names.
Depending on which version of Outlook you run, you can
creat a new pst from file/new/Outlook Data File (I run
Outlook 2003 but had multiple P...Money 2006 file repair application error
I cannot delete an old account because I get a "file may be courrupt" error
so I am trying to repair my 2006 file.
Following the deirections, when the progress bar almost completes, I get an
application exception and send an error report to MS. My event log has 2
Event Type: Error
Event Source: Application Error
Event Category: None
Event ID: 1001
Time: 10:47:26 PM
Fault bucket 02266399.
For more information, see Help and Support Center at
0000: 42 75 63 6b 65 ...preview text disappears when email is opened
When someone responds to an my email, I can see what they have typed - until
I open the message - then only my original message is viewable. The preview
pane shows new message text when email arrives, hoever when the email is
opened the preview text disappears - and I just see the earlier part of the
message which I had sent.
If I mark it as unread it does not return to the previous state.
This seems to happen on email responses that people have received and
answered from a webmail service not that they downloaded and opened in
outlook on their PC
OL'03 XP pro sp2
Respectfully,...unable to access mail after re-enable account
After enable an disable account and change its password,
it can login to its mail account. What's happening. Is it
Thanks a lot
What is the error message when user tries to access mailbox? Does the user
still show in ADUC has having Exchange attributes? Have you looked at the MB
using ESM to see if it is disconnected?
"Raymond" <email@example.com> wrote in message
> After enable an disable account and change its password,
> it can login to its mail account. What's hap...Application hanging on file load...
Okay, I'm having the strangest problem, and I'm hoping somebody here
will be able to give me an idea of how to attack it... I have an MFC
application that does some networked communication, multi-threading,
fun stuff... I also load and save xml configuration files. Now, on
most of the computers I've run my software on, I have absolutely no
problems. On SOME boxes, however, whenever I use my menu to try to
load or save a file... before the File Dialog box even comes up... the
application hangs. All the boxes I've tried this on have been Windows
2000 boxes with Service Pack 4....can't open files
I have Microsoft Office 2003 ~ all of a sudden when I go to my documents
and try to open a file, I get this message "problem sending command to the
program". Error 0646 and dt000
See the article "How to re-register Word when problems crop up opening
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Lost in Vegas" <Lo...Opening for Great Plains Developer in SF Bay Area
We have a current position open for a Great Plains developer to perform
dB maintenance for Great Plains installation. Open to Contract or
Contract to Perm.
Full job description on request.
Please email if you are interested.
...toggling between open work books
Re EXCEL97 under WinXP-Pro w/SR-2
Microsoft Windows allows you to easily toggle between applications using
Alt-Tab. Is there a similar key board to toggle between two open
workbooks in Excel? One can use Alt-W to display list of open
workbooks, but you can�t just blinding hit the up or down arrow, because
the most recently accessed workbook is not always at the top or bottom.
I realize that I could get around the problem of opening two copies of
Excel and then toggling using the Alt-Tab keys, but typically I�ve got
two workbooks open in one copy of Excel before I realize I need the
f...Error saving a Shared Workbook
I have a user using a shared workbook and gets an error
everytime she does this ONE specific change. She deletes
a line and then saves and gets a message that
says, "EXCEL.exe has generated errors and will be shutdown
by Windows... blah blah blah". If she makes anyother
type of changes it saves just fine. I also had another
user do the SAME change and that person also got that
error message. When the file is changed to "Not Shared"
then the line is deleted it saves fine also. The problem
is obviously with the file itself and that is shared out.
can anybody ...How can I wrap text across merged cells?
I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?
Instead of merging cells, have you tried the "Center Across Selection"
The appearence is just about identical to what you would get using merged
cells, although I d...Open Workbook
I have a query that pulls 2 fields from a table. One field (ReportName) is
selected from a form combo box. The second field (ReportLocation) in the
query is the full path of the ReportName selected. I want to open the
workbook using the ReportLocation, when the ReportName in the form changes.
So I need to the code to enter in "On Change" for my form, so whatever report
is selected, it opens up.
Please help. Thank you in advance.
Message posted via AccessMonster.com
here is my current code that doesn'...I can no longer convert my files to pdf
I have Publisher 2003 and yesterday, my pdf menu on the top left disappeared
and I can no longer convert my Publisher files to pdf. I've even
uninstalled/reinstalled the Adobe Acrobat 7 and have also updated to 7.8 but
still no luck.
The next step was to uninstall and reinstall Publisher and still no luck.
Any one know what may be the problem? Thanks.
How are you trying to convert your files? When happens when you try?
MVP Microsoft [Publisher]
"darrellm" <firstname.lastname@example.org> wrote in message
news:A78B7B52-981D-4FB7-8625-EAD9...Outlook Data Files #4
I've done some reading but I'm still confused about the use of Office
Outlook Personal Folders File (.pst) versus Outlook 97-2002 Personal Folders
File (.pst). I understand the basic "Office Outlook Personal Folders File
(.pst) to create a new Outlook 2003 .pst file. Click Outlook 97-2002
Personal Folders File (.pst) to create a new Outlook .pst file that is
compatible with earlier versions of Outlook."
When we have upgraded to Outlook 2003 or set up a new PC with Outlook 2003,
when adding PST's you can chosse either of the two file type options and
browse to chos...Backup Excel file
I want to take backup of a file every time. I am using - save as - tools -
general option - always create back up. The backup file is in the same
location but I want to put it in a different folder. What should I do, kindly
Jan Karel Pieterse's has an addin called AutoSafe (note spelling).
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them...Utility (pref. script) to catalog .EDB files
I have a client that is using an Enterprise backup tool which, whilst
able to back-up and restore, does not provide in-depth information
like traditional Exchange-aware backup products.
I have been asked to write a script to list the users in a flat .EDB
file (which has been snapped and copied and flushed using SAN
I have taken a look at the ESE API, which can only be accessed using C
+ (I only use VB). Other than EXMERGE, does anyone know of any tools
that allow you to list the basic mailbox details on a EDB file?
...List folders to file
Does anyone have a macro that would list all the folders (with path) and
subfolders to an excel sheet but not the files?
There's a function called CELL() that should return your filename (or
any of a number of parameters) but I can't get it to work properly on
my machine, so I can't make it work for you. The syntax is
=CELL("filename") which ought to return the path and filename of the
current file, and which you could then trim down to show just the path.
Can anyone provide some guidance here?
If it isn't working for you, it pro...Hyperlink File Help
I am needing some major help. I have a file with hyperlinks in column F that
link to a file on our server. I am needing to test to see if the file exists
and if it does, copy the file to a folder in my documents called
(CapturedFiles) and if it doesn't format the cell color to red. Can VBA do
this and if so how? Any help would be greatly appreciated.
Thanks in advance.
Fileserver or webserver ?
On Nov 23, 7:20=A0am, Aaron <Aa...@discussions.microsoft.com> wrote:
> I am needing some major help. =A0I have a file with hyperlinks in column =
> l...IMPORTING MONEY FILES DUP ENTRIES
I have been unable to run money98 files in money2003.Tried
importing files but all tranfers between accounts are
duplicated. Don't understand how to import all the
accounts at once. I created new accounts in 2003 and
imported one by one, but any transactions between accounts
Follow the prompts on the import file dialog that tell you to select
multiple files to import at the same time. There are other guidelines if
investment accounts are involved. You might want to review postings on this
subject in the group archives at http://groups.google.com.
"JAYNE" &l...Lost .pst files
I am using Office XP with Outlook 2002 (SP2). I recently
had a boot track failure on my old computer which had 2
hard drives, using the second drive as back-up storage.
I bought a new computer and installed the old main drive
(the one with the failed boot track) in my new computer
as a second drive and copied all the data onto the new
main drive. All data and software works except Outlook.
I cannot find any .pst files on my old drive. Where
could they be. BTW I use Matadore as a spam blocker.
In article <email@example.com>, daddyray01
@sport.rr.com say...Read file info using SMO locks database!
I'm using SMO from C# to restore a database from a backup file. Since I want
to re-use the same datafiles I try to read the datafiles in my destination
database and call RelocateFile to use these filenames during the restore.
Everyting works fine except when I try to read the current datafilenames
(see code below). If I skip this code and just hardcode the paths in
relocatefile everything works fine.
Database db = svr.Databases[destinationDBName];
foreach (FileGroup group in db.FileGroups)
foreach (DataFile file in group.Files)
Console.WriteLine...Provide space in text
Where text and numbers are at different locations in different cells what
formula could be used to suit this type of information. I want to be able to
put a space between the main body of text on the left and give a space
between the text and the start of any numbers are in the cell.
A1 = Abelia Edward Goucher2 litre
Abelia Edward Goucher 2 litre
A2 = Acer campestre Nanum180stem 6-8
Acer campestre Nanum 180stem 6-8
Thankyou if can be of help.
If you double clcik in the cell with the data then you can move th
blink line to were you wan...Halfway through my publisher document the text starts scrambling
I am in the middle of a Publisher document that I have to get out ASAP and
the words are scrmbling all of a sudden; for instance instead of the it
Might try an updated printer driver.
What version Publisher are you using? What printer? What version Windows?
Canon has issues with Publisher 98 and Windows 98
How to troubleshoot text printing (inkjet printers) in Publisher 2000
PUB2000: Troubleshooting Text Printing (Laser Printers)