Converting grid data to side-by-side lists
Hello everyone, this has been driving me crazy so want to see if any of you
I have a grid in an Excel worksheet formatted like this:
Company A Company B Company C
Service 1 X X
Service 2 X X
Service 3 X X
I need to convert this data to a list that maps the Services to the
Companies like this:
Service 1 Company A
Service 1 Company C
Service 2 Company A
Service 2 ...Bought Pub 2003 now it won't open my Pub 2003 file
I just bought Publisher 2003 yesterday. I spent 3 hours creating a project. I tried to laod the saved project and got the message "Publisher can not open file. I tried open pun 97 files with the same result. I've used Publisher 2.0, 97 for years. What am I missing?
Most likely you are running Norton Anti-Virus. Norton AV can actually break
a Publisher file rendering it unusable. You need to disable script-blocking
and possibly the Office plug-in components of Norton AV. Refer to
David Bartosik - MS MVP
for Publisher help...How to convert Quicken QFX files?
I am unable to convert a Quicken QFX file to be used in
Microsoft Money 2003. Any ideas?
In microsoft.public.money, Greg wrote:
>I am unable to convert a Quicken QFX file to be used in
>Microsoft Money 2003. Any ideas?
Have you tried File->Import?
...Can't open .pub files either
I have installed / unistalled / installed / uninstalled Publisher 2003
several times and have the same problems others seem to have. I can create
and save a .pub file but cannot open them. Get the "cannot find file"
message followed by the "cannot open" message.
I have loaded the same Publisher program on another computer in our office
and it works fine.
To save time I should said ahead of time that we:
DO NOT use Norton Antivirus
DO use Norton Internet Securities which have been set to "allow scripts"
Please help! If I cannot re-open and re-edit .pub fi...enumerating file on a directory
hi, How can i enumerate files on a directory based on a filter like "*.h"
and store the result on an array on VC++. tnx, hope you guys can help.
I choose Polesoft Lockspam to fight spam, and you?
Look For CFileFind Class if working in MFC or FindFirstFile FindNextFile or
FindClose if you project based on Win32
Visit me at http://alok.bizhat.com
"lawrence" <email@example.com> wrote in message
> hi, How can i enumerate files on a directory based on a filter...How do I print a text file ?
I am new to the group and wonder if any of you could offer any advice. I am
trying to print a text file directly from my visual c++ application to the
default printer without displaying the print dialog
What is the best way of doing this ?
If it is not possible to print directly from a text file, what commands to I
use in between
To print the following
Hello, my name is Joe Bloggs
How are you
I hope you can help with this problem etc.....
Thanks in advance
More info on printing than you can comfortably shake a stick at:
http://www....Outlook pst file
My original pst file was about 30 mb in size. Somehow it
is corrupted and showing only 30 kb in size. I am not able
to recover my previous info. Is there any way to retrieve
info from this pst.
You could try the inbox repair tool, scanpst.exe
"Ajay" <firstname.lastname@example.org> wrote in message
> My original pst file was about 30 mb in size. Somehow it
> is corrupted and showing only 30 kb in size. I am not able
> to recover my previous info. Is there any way to retrieve
> info from this pst.
...Published 2000 pictures make file sizes too big
I have scanned pictures using Microsoft Photo/Draw. The
pictures are around 250 KB but when I put them in my
Published document, the file grows to 14,000KB. I can't
email them or save them on a floppy. How can I get this
file size down
You may have to convert the file to a pdf format. Publisher just make
You have several choices when it comes to a pdf converter program from
freebees to Adobe Acrobat. The later is on the spendy side and the freebees
may disappoint you. My choice after comparing 5 pdf converter programs was
PDF-XChange, a very nice commercial produc...Log files in Great Plains 8.0
We use a web based program to import orders from our website into Great
Plains. We have recently come across some errors where invoices show
up with no associated order or customer information. The only thing
that shows on these invoices is item information. I believe these
invoices are generated somehow by a glitch in the import we do for our
web orders. Is there a log file somewhere in GP where I can see what
information was entered based on date? Or if anyone else has
experienced this problem before, am I correct in my assumption that the
"ghost" invoices are being caused by ...Open File Dialog Help
I am trying to set the m_ofn.lpstrInitialDir to "My Music" on an open file dialog, but can't seem to get it to work right. I would like it to default to the c:\documents and settings\user\My Documents\My Music, regardless of the machine the application is running on.
The project is being built using Visual C++ 6.0 Professional, on a Windows 2K machine, but may be running in any Windows environment.
gets you to My Documents
...Importing large tab-delimited text files?
I deal with very large data sets that are in tab-delimited .txt format.
Many times, there are more than 256 columns of data.
The Microsoft Knowledge Base had an article titled "Sample Macro to Import
Data with More Than 256 Fields or Columns". This could do the trick for me
if I could modify the macro to accomodate tab-delimited formats.
Q1: Could anyone tell me how to modify the macro described above for
tab-delimited .txt files?
Q2: Does anyone know of a bulk file conversion utility that would change a
tab-delimited text file to a CSV format?
Thanks a bunch,
Ma...Copy a file with only values no formulas
Is there an easy way to copy a workbook so that it only has the values and
not the formulas?
Right click on a sheet tab and select all sheets. Then select all cells on
the active sheet. Do a copy, then Edit, paste special, values. Right click
on a sheet tab and select ungroup sheets. Save the workbook under a
Productivity add-ins and downloadable books on VB macros for Excel
"Lee Coleman" <email@example.com> wrote in message
news:OIOx4$FeHHA.4020@TK2MSFTN...No files selected in openfiledialog
How can I test for openfiledialog OK clicked without any files being
selected? (I'm using it with multiple select as true.)
if openfiledialog1.filenames = nothing then ...
if ubound(openfiledialog1.filenames) = -1 then ...
but both these give compile errors.
Grateful for advice.
Am 11.05.2010 15:46, schrieb simonc:
> How can I test for openfiledialog OK clicked without any files being
> selected? (I'm using it with multiple select as true.)
> I've tried
> if openfiledialog1.filenames = nothing then ...
&g...selecting Access 2000 or "Access 2002" with the Convert Database command
I'm getting ready to convert a number of Access 97 mdb files to Access 2002.
I'm looking over the instructions for doing this in the "Using MS Access
2002 - Special Edition" written by Roger Jennings. In that book, it says to
select Tools - Database Utilities - Convert Database - To Access 2000 file
Since this book is for Access 2002, I was surprised that it would suggest
selecting the 2000 file format instead of 2002. I'm thinking this just a
typo - but I thought I'd also check with this newsgroup to see if anyone
knows of a reason why someone working in 2...Relative File locations
I have a program that opens file #1 in folder XYZ. In this file is a
reference to another file #2 in another folder. Is there a way to
reference file #2 so if I put file #2 and file #1 in the same folder, the
reference will always be made to the folder that contains the file #1, no
matter where I may relocate it?
...Answer file local admin password
I am trying to apply a local admin password to all PC's during my ghost roll
out. Everthing works from my answer file with the only exception the local
admin password is not applied. Here is the current part of my answer file
...Schedueled Auto Send .xls File to Receipients
I have an MS2007...I have a progress tracking excel spreadsheet that I must
send to certain associates on a biweekly basis.
What functionality exists or coding is reqiuried for my document to be
automatically sent to selected receipients on a scheduled basis until the
project is complete?
...New pst file
When I split off my pst file into a new one for a different email
account, will it point to my existing Rules file and auto-corrects or
will I need to create new ones?
...1st I read mail from my Inbox, then I can jot a note & a rule file
This is a suggestion, this feature may already exist in newer versions, I am
using Office 2003. I like creating rules for Outlook e-mail so they go into
folders but I tend not to read many of the ones for which I have created
rules, they just go into the folders and then get old before I get around to
reading them. What I'd like better is have all the emails initially come into
my Inbox, read them from there, and then I can be given an option for Outlook
to file the e-mail in an e-mail folder using a previously created or newly
created rule. It should also give me an option t...Removing notes tab
we would like to remove the notes-tabs from almost every entity.
The problem is, that these tabs are fixed for some reason.
I do not want to delete the notes, I just want to hide them except for
Is that possible, without writing customcode for every form?
none I know. But it is jaust one line in the Onload-event to hide the tab.
"Uwe Braunholz" wrote:
> we would like to remove the notes-tabs from almost every entity.
> The problem is, that these tabs are fixed for some reason.
> I do not want to del...New DC not showing in Directory access tab
We have just added a 3rd DC in our Domain, however it doesn't show under the
Directory Access tab in Exchange system manager, why is this and how can I
On Mon, 17 Oct 2005 11:57:06 -0700, "SW"
>We have just added a 3rd DC in our Domain, however it doesn't show under the
>Directory Access tab in Exchange system manager, why is this and how can I
...Put file date is a cell
I want to put the date the file was saved into the footer
of my spreadsheet. I wrote a small user defined function
that incorporates FileDateTime(). I can get the date to
appear in a msgbox, but when I try to use the same
function to write to a cell, I get an error. It
says "That name is not valid". What am I doing wrong and
how do I fix it?
Here is my code:
Public Function MyDate() As Variant
' Get the file date and export it to a cell.
MyDate = FileDateTime("thisfile.xls")
MsgBox MyDate, vbOKOnly, "Current"
Jay, thi...Can't delete files
I have files on my desktop and in word that I cannot delete. The message
says that the files are open in system, but nothing else is running. I am
the only user on this computer. Please help!
See http://www.gmayor.com/what_to_do_when_word_crashes.htm and you may have
to reboot to release the most stubborn files.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><&...LARGE function file reference
Can the LARGE function compare arrays that are in different files? I get the
#VALUE! error when I try. If it can do so, what is wrong with my formula? I
=LARGE(('L:\05.056 C SD PF Study\G H S\[05.056 GHS conectiv A PF corr
03.xls]Sheet1'!$I$21:$I$32,'L:\05.056 C SD PF Study\G H S\[05.056 GHS
conectiv A PF corr 04.xls]Sheet1'!$I$22:$I$32),24)&" / "&LARGE(('L:\05.056 C
SD PF Study\G H S\[05.056 GHS conectiv A PF corr
03.xls]Sheet1'!$I$22:$I$32,'L:\05.056 C SD PF Study\G H S\[05.056 GHS
conectiv A PF corr 04.xls]Sheet1'!$I$22:...search text files for a certain word
How do I search text files for a certain word using a macro. I need to
look for the word "SerialNo" and return the following 10 characters. I
will be repeating this for hundreds of files. For now, how do I do it
for a single file. Excel 97
f = "c:\test.txt"
filenumber = FreeFile
Open f For Input As filenumber
a = Input(FileLen(f), filenumber)
LookFor = LCase("SerialNo")
b = InStr(LCase(a), LookFor)
If b > 0 Then
MsgBox Mid(a, b + Len(LookFor), 10)
"Fan924" <firstname.lastname@example.org> a �crit dans ...