Simple problem importing a file using a macro
I am very new to Excel programming, but I have written a few simple macros
before. However, I have never really worked with loading information out of a
file and then saving it back.
I have a series of text files which contain data that I want to import. I ran
the macro recorder to import one file that I wanted where I wanted it, but I am
now trying to automate the process. All the files end in .PRN. I write the
name of the file that I want in the "A" row of an Excel spreadsheet, minus the
".PRN". The files are always on a floppy disk in the &...PLEASE HELP- How do I convert from Publisher to JPeg file?
I need to figure out how to convert the publisher file to Jpeg and also I
need to make it a 300 dpi resolution... Anyone know how to do this? Thanks!!!
You can thank Joanne Paules for finding the solution to this goal of yours.
SnagIt will do what you want. It is ~$40
It is a great program and I use it often.
"VibrateLovedotcom" <VibrateLovedotcom@discussions.microsoft.com> wrote in
>I need to fig...Issue importing pick list values using Import Wizard
VAR Sales - North America
...Using PS to export/import users,groups, and group membership
I'm relatively new in PowerShell. My objective is to export users, groups,
and groups membership from selected OU(s) in "domainA.com" and import into
"domainB.com" using *.csv file.
The requirements of this task as following;
1. Export all user in selected OU(s) with mandatory LDAP attributes and
import (mirror) it in domainB;
,Division,employeeType,L,Manager,Mobile,otherTelephone,telephoneNumber,facsimileTelephoneNumber,physicalDeliveryOfficeName,pos...Looking for training materials...
I have spent many a lonlet night reading the RMS User's Guide.... but I need
a "training manual" of such. I have seen all the online courses and classes
you can take, but is there a good book that anyone can recommend?
"...is there a good book that anyone can recommend?"
I recommend reading 'The Da Vinci Code'.
There isn't any other training material besides the User's Guide, Quick
Start Guide and the online eCourse. Your best bet is to have your Certified
RMS Partner to help you get up to speed. Some of them provide training
classes as well.
Ro...Importing multiple OE accounts into Outlook
My Outlook Express has stopped working, it just freezes, so I figured it was
time to switch to Outlook 2003. I've got it installed and I know how to set
up multiple profiles. I would like to import my existing emails and address
book from each of the accounts I had set up in OE, but whenever I do Import
Internet Mail and Addresses, it just pulls the data from my mail OE account.
I can't seem to get the data from the other accounts.
How can I get at the data?
After playing with it for a while more I figured out the trick, although it's
not at all obvious....Importing Excel2007 into Project2003
In the process of developing a task map for excel  import to project
. When selecting 'finish' after setting up the task map the following
message is generated -"The source worksheet name is required. One or more of
the source worksheet name fields are blank. A worksheet name is required for
importing data." Could someone interpret what this message is trying to
Usually that message will appear in the middle of creating the
import map, not at the end.
When working through the import wizard on the task mapping page, you
Is there a way to import, import specifications from another database?
Yes, when you import click 'Options' and click the 'Import/Export Specs'
This is for 2003, I don't know about 2007.
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
> Is there a way to import, import specifications from another database?
...Importing email address list into General Mailbox Exch 2003
I have a list of + - 200 smtp addresses in PST format (Contact Folder) and
want to import it into the General address group so that everyone can see
them, I do not want to do each one manually, time consuming, pls help any
ideas would be welcome, thanks
SPG <SPG@discussions.microsoft.com> wrote:
>I have a list of + - 200 smtp addresses in PST format (Contact Folder) and
>want to import it into the General address group so that everyone can see
>them, I do not want to do each one manually, time consuming, pls help any
>ideas would be welcome, thanks
You can export the...Import Form
I would like an opinion on this... I have system that allows data to be saved
each day in a MS Access Database called Test with one Table that contains the
data. I would like to create a form in a MS Access Database called IMPORT
that would allow a user to browse to the Test Database and each day
automatically import the data from the Test database table to the IMPORT
Database. I am trying to avoid users having access to the tables and
importing data from the tables of a database to the IMPORT Database table.
I would appreciate any suggestions!
Message posted via AccessMonster.com
http:...Custom POS Buttons: Change the look and size
I would like to change the look of my custom POS buttons. I just want a
100x50 pixel image - no caption. I would also like the button bar to have
two columns. Can someone point me in the right direction? Is there a
template file or config file that controls this?
Please don't tell me to contact my reseller or try to sell me an add-on.
I have been looking to change the button configuration as well, and I think
they are located here
C:\Program Files\Microsoft Dynamics - Point of
they are just XML files.
> I wo...Any important drawbacks to Dynamic Disks?
I'm formatting a 2 TB RAID-0 volume right now as a dynamic disk. It's a
2-drive RAID-0 set and it's my L: disk. My C: drive is also RAID-0 but it's a
Basic disk. Two questions:
1) Any drawbacks to Dynamic disks? Couldn't find any in the doc except for
the same kind as with NTFS, you can't do certain things w/ older OS's that I
don't need to do anyway.
2) Any significant risks or problems if I convert my C: drive from Basic to
> I'm formatting a 2 TB RAID-0 volume right now as a dynam...Import and QS Import
Hey any of you QS IMPORT GURUS- Let me ask you some questions
1) What are the full capabilities of QS Import? Can it append? Can it
Update? Can it modify?
2) And what needs to be set to Append, Update and Modify?
3) Does anyone have is SQL queries written for Importing data, updating
Tried it once, didn't work very well, gave up.
Use SQL Import instead $39 www.ems-hitech.com/mssqlutils/
"Brent Hauver" <firstname.lastname@example.org> wrote in message
> Hey any of you QS IMPORT GURUS- L...Import and Export
This is a multi-part message in MIME format.
Hi I would like to populate some of the mailbox property ex phone #
How can I export my GAL and Then modify and Import it back.
Any special tool besides writing a script?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"...PDF imports don't retain changes upon saves
I'm importing PDF files of AutoCAD drawings because AutoCAD .DWG files don't
scale correctly when opened in Visio2003. When I change the properties on the
PDF objects, scale them to the desired dimensions, and save changes, the PDF
object reverts to a different size after the save.
Also, I've found that the PDF object loses resolution when scaled larger -
meaning that lines pixellate and alphanumeric characters become fuzzy. Does
anyone know of a work-around for this? Thank you.
National Project Manager
i can help you with my own dwg converter. email me you a...Import
Can you import from quicken 2004 to money 2004
not so much 'import' as 'convert' although some classifications will be
Try it with a Trial copy of Money first.
<email@example.com> wrote in message
> Can you import from quicken 2004 to money 2004
M04 cannot upgrade a Q04 file since it came out first and is not clairvoyant
about unreleased Quicken file formats. It can upgrade Q03 and earlier. M05
will likely upgrade Q04 and earlier, if the past is any predictor of the
future. There is always QIF export/import but ...import excell cells for distribution list
import excell cells for distribution list for outlook
"Bob Black" <Bob Black@discussions.microsoft.com> wrote in message
> import excell cells for distribution list for outlook
So your QUESTION is?
Why? An Excel spreadsheet is a good data source for mail merge, which works
better than a DL in most applications.
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
&...Specifying Row / Column in Import File
Hello, first time poster here...
I've a question regarding the import of Excel data. I'm going to b
creating a flat file on a mainframe, copying it down to a PC and usin
Excel to import it. I have a template that has cells and calculation
associated with it. Now, what I would like to do is to have th
mainframe prefix a record with a row / column coordinate, for example:
A1,Data for Cell A1
B1,Data for Cell B1
A2,Data for Cell A2
This is a simple example, but the program on the mainframe will outpu
the cell address based upon some rules as it rolls through the data.
How ...Create a schema library and use import/include with XSD.exe
I have a "library" schema with the simple and complex types I commonly use
in other schemas and then several other schemas, maybe created by other
developers, that import/include the library schema. And then other schemas
can extend it.....
The classes created by XSD really help to make the development faster and
easier. I really would like to use XSD.exe tool as much as possible and to
avoid editing the classes defined by the tool.
If I create two different schemas (that use the library schema) XSD will
duplicate the classes defined in the library schema so I will have to manage
t...import from .mdb database
I want to import in Microsoft Money 2004 my data form my .mdb database. And
I don't no how to do that.
I can transform my .mdb database to other format: .xls .dbf .txt .wks
but I can't transfer my personal data into Microsoft Money 2004 file.
Can you help me?
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
or for UK wishes email to firstname.lastname@example.org.
I am importing a list of names in column form and would like to tranfer them
I would like it show Name, Address, City, Ph., Fax, Email
Is there a way to make an macro so it may be automatically done when
I am just getting started at learning how to work with Macros. Any help
would be much appreciated
Thank - You
If your data is consistently 6 rows enter this in B1
Copy across to G1.
Select B1:G1 and copy down until you get zeros showing up.
Convert these formulas to values by co...Important Information #2
Check out: www.Brandon-Lands.com
...FW: Check this important pack
Content-Type: multipart/related; boundary="eozfpftmhyrtbmr";
Content-Type: multipart/alternative; boundary="tctklmngfm"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to protect your computer
from these vulnerabiliti...Unable to Import MS Outlook Contacts
I am attempting to import 1548 MS Outlook contacts. When I go to MS CRM
Contacts and select Tools => Import, then select to Import MS Outlook
Contacts on 1 contact shows as available to import.
Any help is very much appreciated.
Correction. "Only 1 contact shows up as available to import." Could this
have some thing to do with forms"?
> I am attempting to import 1548 MS Outlook contacts. When I go to MS CRM
> Contacts and select Tools => Import, then select to Import MS Outlook
> Contacts on 1 contact ...importing/exporting from access to excel
I need a CVS file with some data I have in an access query. To do that I'm
trying to import (in excel) and Export (in access), and everything goes right
except the fields where I have up to 255 characters. These (in excel) only
shows the first 255 characters.
How to resolve this problem? or better, How to create a CSV file from my
Thank you all. Tom.
In Access, rtclick the Query Icon, choose Export from the shortcut menu, &
change the File Type at bottom of the dialog box to whatever you need. If
"Text File", the next dialog box provides option...