Import data from Notepad to Excel
Can anyone tell me how to import data on a notepad sheet
into an excel spreadsheet? I have been told this can be
done but cannot locate the instructions.
File>open enter filename and select .txt from the filetype dropdown list.
johnf202 at hotmail dot com
"Cindi Schneider" <firstname.lastname@example.org> wrote in message
> Can anyone tell me how to import data on a notepad sheet
> into an excel spreadsheet? I have been told this can be
> done but cannot locate the instructions.
...VBA code to insert pictures in a column of cells
I have a folder of 99 pictures with filenames: image01.jpg, image02.jpg up
to image99.jpg. All of these images are small, and the same size.
I want to insert them (in order) in a column of cells (A1, A2, to A99) using
VBA. The images should be embedded, not linked. Resizing cells to the right
size would be a nice extra, but not necessary - it's easy in this case to
resize manually. Thanks for looking at my question - and I hope to hear some
...DPM 2010 refuses to back-up virtual machine on CSV.
I keep getting the below error:
Affected area: \Backup Using Child Partition Snapshot\WH-WDS03
Occurred since: 12-11-2009 11:02:55
Description: The replica of Microsoft Hyper-V \Backup Using Child Partition
Snapshot\WH-WDS03 on SCVMM WH-WDS03 Resources.wh-hv.internal-wortell.com is
inconsistent with the protected data source. All protection activities for
data source will fail until the replica is synchronized with consistency
check. You can recover data from existing recovery points, but new recovery
points cannot be cre...How do I print a footer on the last page only of an excel doc?
How do I print a footer on the last page only of an excel doc? Is this
Only with code
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
.RightFooter = ""
ActiveSheet.PrintOut From:=1, To:=TotPages - 1
.RightFooter = "Your Header info"
ActiveSheet.PrintOut From:=TotPages, To:=TotPages
Regards Ron de Bruin
"CLDelafield" <CLDelafield@discussions.microsoft.com> wrote i...Updating External Links Excel 2000 vs 2002/2003
I have a situation where I'm using Excel 2000 with a
workbook containing references to another workbook. When
opening the first workbook & the second workbook is not
available, you can say "no" to the update external links,
and still see all values as they were when the first
workbook was last closed.
However, when the same workbook is opened in Excel 2002 or
2003, the external links specified only as a cell reference
show the proper data (e.g, =wbkname!E1), but when they are
Excel formulae (specifically a SUMIF), I'm getting a #VALUE!
error in the pertinent cells
Is th...Help! Creating an HTML 'signature card' to insert in Outlook
john inzer has saved by butt before hoping he or someone else can save me
I need to create a signature for email that looks like a business card
complete with picture with one exception.
It needs to have tab tops and appear layered and on the top of those tabs
there needs to be hyperlinks to various pages on a website. I can create
the look but dont know if I make it in webpage design on pub or ?. I dont
know html (i've used ebays turbo lister to create stuff then copy and pasted
the html view - ez cheat)
I had a wells fargo guy send me an email that had one in his with ...Input form in excel
Is there a way to create a permanent input form in excel to enter data and
have the data recap to a master data sheet.
I need to create an input form so that the users can input in fields without
any issues of which line they are inputting on.
What I need this one to do is if it is a Sale it populates questions that
need to be answered if it is a referral a different set of questions will
The users do not like access so that is why I need to create this in excel.
See if John W's data form does the job:
HTH. Best ...VBA Passwords
I passwod protected by VBA modules so that no one could see them. But
have just come back from holidays forgetten my passwords and now
can't see them!
Any ideas how I can recover the
Message posted from http://www.ExcelForum.com
If you are using a newer version of excel that excel 97, then you will
either have to remember it or use a commercial password cracking program. If
you are using Excel 97 there is a free program called vbakey.exe that will
tell you your vba password.
Outgoing mail is certified Virus Free.
Checked ...Insert Column 2007
I have recently installed Access 2007. When I'm in the Design View of any
query the icon to Insert Column is greyed out and unavailable. I have closed
the query, the datebase and restarted the PC, Access and checked different
queries, different databases and the problem persists.
Try to mark a column & Hit Insert
"JudithJubilee" <JudithJubilee@discussions.microsoft.com> wrote in message
> I have recently installed Access 2007. When I'm in the Desi...Does Print Purchasing Documents work for multiple POs?
One of our Purchasing people used the Print Purchasing Documents window today
to print a range of POs. This is the first time we've ever used this screen -
normally, POs are printed one at a time as they are created.
Well, the POs that were output were all jumbled - it seems like the last
pages of POs were getting scrambled between each other.
Has anyone else successfully used this window to print multiple POs? Our PO
forms have been heavily customized, so I'm wondering if that might be what is
causing the problem.
Bud Cool, Accounting System Manager
HDA, Inc. Hazelwood, M...ExportAsFixedFormat : differences between Excel and Word
I am trying to use the VBA method ExportAsFixedFormat to print a workbook to
Problem: Excel will not use certain fonts on my machine - they are converted
to Adobe Sans MM.
Problem2: Word and Publisher also have the ExportAsFixedFormat method, but
these two object models contain a parameter "BitmapMissingFonts". Excel does
not offer this.
Can someone suggest a workaround that uses ExportAsFixedFormat?
Move the data from excel to word and then convert to PDF from word. You
can use a macro from excel to open a word applcation and move the d...array in VBA
A few days ago I saw an answer to a post that showed the VBA equivalent of
using an array worksheet formula with ctrl+shift+enter. I forgot to copy
that answer for later use, now I can't find it anymore. Anybody who knows
what I mean? If so, please tell me where to find the post.
"Jack Sons" <email@example.com> wrote in message
> Hi all,
> A few days ago I saw an answer to a post that showed the VBA equiva...automating the insertion of HTML tables (or tab delimited files)
I am completely new to Word programming, so I am not even sure if this
is the way to solve my problem, but here goes:
I have approximately 400-500 HTML tables in various HTML files (the
data making up these tables also exists in tab delimited ASCII files).
My goal is to insert the tables into a Word document.
The problems I am facing are:
1.) How do I "loop" over each HTML file & "grab" the table & insert
it into the appropriate place within the Word document? I can do this
manually by going to "Insert" then "file" t...Excel
I'm trying to create a "drop down list" but don't know how to validate,
define and/or create a source box. Trying to follow the instructions using
the "help" featur, but I'm still confused. Thanks!
Go to Debra Dalgleish's site:
And scroll down to the D's, and there is an entire collection of pages on
Data Validation which will show you how to create and manage drop-down boxes
using that function.
Please keep all corre...excel vba
I have set up my sheet to protect using a password name login which the
runs the macros. It is set up so that the sheet's cells cannot b
edited, but the person can copy/paste the info onto another sheet.
This is a problem because there are hidden cells which contai
sensitive data. Any ideas
Message posted from http://www.ExcelForum.com
Hi, just a comment that i just found out, check out this
link that I was refered too. That password that you
setup doesn't do squat when you have access to this...
I was mad when I saw this, when mean...Error Message: Page needed to close down, ....
After opening 'Home Page,' error message popping up in the middle of the
screen saying, ... 'Page needed to close down, ... and whether I want to
send this message to Microsoft, either 'send it' or 'not send it.' After
closing it down, I need to start all over again to open 'Home Page.' After
that, everything running normal without seeing 'error messsage.'
This erratic behavior occurs mostly during nights, ... rarely happens during
morning-hours before going to work.
Just wondering what's wrong with it?
Any help on this ...Copying email addresses from excel
I'm copying multiple email addresses from excel into an email (bcc field) and
it is automatically creating "characters" which then return an error when i
try to click send.
I have tripple checked my email addresses and know they are all fine. I know
that the number of contacts & size of the email are within my limits.
The charcters it usually inserts is either a "t" on its own or "ope".
Is there a way to stop it from doing it or just overiding it to ignore the
I've never seen or heard of that behavior. But instead of copying...Any method available to insert pic into comment box??
Any method available to insert picture into comment box?
or just wishful hoping?
There are instructions here:
> Any method available to insert picture into comment box?
> or just wishful hoping?
Excel FAQ, Tips & Book List
...Multiple Record Insertion
Iam able to create a one lead at a time using APIs as written below.
strLeadXml = "<lead>";
strLeadXml += "<lastname>"+lastname+"</lastname>";
strLeadXml += "<firstname>"+firstname+"</firstname>";
strLeadXml += "<companyname>"+companyName+"</companyname>";
strLeadXml += "<ownerid type=\"" +
strLeadXml += objectId + "</ownerid>";
strLeadXml += ...HELP WITH VBA
I am trying to finish writing some simple program.
My problem is that when I try and change the arguement from SELECTION
CHANGE to CHANGE, it doesn't work. Can someone help?
Private Sub Worksheet_Change(ByVal Target As Range)
If Worksheets("Sheet3").Range("B3").Value = 2 Then
My second problem is that I would like my data rather than appearing in
a cell, appear in a TEXT BOX. What do I do?
Copying your exact same post from 3 days ago word...excel not opening up files
Excel - won't open with double click, must open Excel then browse for
as well when i recive excel documents in outlook i try to double click
on them but i get the same result
excel opens but i just get a blank screen no work sheet but the menu
is up on the screen
this is excel 2002 sp3 .. this just starting happening to one user
about 3 days ago and now i have 2 more users that have the same
the excel files are assioated with excel . no issues there . when i
double click them no issues .. or if they come in via e-mail .. if i
forward the e-mail to myself i can open t...Insert Object when condition met
I would like to insert drawing objects depending on what
value is in a cell.
if A3 = 1000 then paste a gold star in B3
if A3 = 2000 then paste a red dot in B3
You can do this with a formula and conditional formatting:
Format cell B3 with Font Wingdings
In cell B3, enter the formula:
With cell B3 selected, choose Format>Conditional Formatting
From the first dropdown, choose 'Cell Value Is'
From the next dropdown, choose 'equal to'
Click in the text box
Hold the Alt key, and on the number keypa...VBA
Ok, all you expert Excel users may think this is dumb.....but what is VBA?
And what do you use it for? I looked around and can't figure a thing out.
Visual Basic for applications. Used to write macros/programs. As a
"Kim" <Kim@discussions.microsoft.com> schrieb im Newsbeitrag
> Ok, all you expert Excel users may think this is dumb.....but what is
> And what do you use it for? ...Working hours
Every month we make a list of our employees working hours.
monday 10.00 - 16.00 = 6h
tuesday 16.00 - 20.00 = 4h
how can i calculate the hours together, some employ can have only 30 hours
per week, now calculate by my fingers....sorry for my bad english
Day in Column A,
Start time in Column B,
End time in Column C,
Start in Row 2.
Make sure time entries are TRUE XL recognized times.
Daily total in Column D, using this formula:
Say weekly total is in D9.
Format D9 to Custom
And use this formula:...Auto Page Numbering Question
I have a 12 page pricelist. Recently we made changes to the last 4
pages of this sheet. I am not getting ready to have the last 4 pages
printed and sent to my customers so that they can simply replace the
last 4 pages, leaving the first 8 in tact.
I copied the last 4 pages into a new book, and need the page numbers
to read 9 of 12, 10 of 12 ect. However, because the pages are in a new
book I can only figure out how to have it say 1 of 4, 2 of 4 and so
Basically, I need to change the footer to read 9 of 12, 10 of 12, 11
of 12 and 12 of 12, but this is only a 4 page sheet.