macro: save w/ new name and print
I assigned a macro to a button in my worksheet on the basis of som
advice that I got in this forum (see macro below).
The macro saves the current workbook on c:\ and gives it a new filenam
with a date/time stamp.
However, I want the macro to do the following additional things now:
-Save the file in the current directory, without me specifying tha
path in the macro
-Also include first and lastname of user (contained in cell A1 and B1
in the filename.
Also, I want a second version of that macro which
-prints a specified sheet (called "output") while/after closing.
Any help ...Looking for a method to print only those worksheets that the user has entered data into
I have a workbook that has 7 worksheets un-hidden. Of those, each has a limited number of cells that are un-protected. Each sheet prints to a single page. The user can enter data on one, some or all of the sheets. Is there a short-cut method that would allow the user to (at a single click) print all of the sheets that have user-input data and not any of those that are left 'blank'
not possible without VBA
"rpw" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:732719CD-1559-4CD1-B0...HOW TO GET DATA FORM FORMS FIELDS
How can i get a hold of all the fields in Access form...basicly all the
controls. I'm developing in Visaul Basic .Net framework 2.0.
So far i only know how to find the right form
(appAccess.CurrentProject.AllForms(x)) but i cant get information from its
.... but the beer is still good!
On Mon, 1 Oct 2007 09:09:04 -0700, Antinsh <Antinsh@discussions.microsoft.com>
>How can i get a hold of all the fields in Access form...basicly all the
>controls. I'm developing in Visaul Basic .Net framework 2.0.
>So far i only know how to find...data range referrences
I have a chart which relies on the data in a table with 29 rows.
Occaisionally, I want to only use 28 rows as my data set for the chart.
I can manually enter a named range into the dialog, and upon entry, it
automatically ,morphs it into the string that describes the data range
(worksheetname, data set). When I manually type in the other named
range, it flips to the shorter named range in the table.
How can I inject that into the chart's data dialog on the fly?
I have tried to reference cell locations that have the named range name
in them. No worky.
I know it is pos...Sum of data with two criteria
Hi there, i have a (simple!?) problem with the following..
In my sheet, i have 3 columns:
column A, containing a order-number
column B, containing a quota
column C, containing a week-number
Now what needs to bee counted, is the SUM of the quota (column B)
occurences from a specific order, AND a specific week!
Problem is, the rows can contain multiple occurences of an
I'm feeling quitte stupid, can anyone help me please? :confused:
Message posted from http://www.ExcelForum.com/
Fr...Broken links don't show old data. Help!
I have a spreadsheet in an email attachment that no longer shows old
data from broken links after upgrading to Office XP. The data is there, and
displays while the "Update links" dialog box is up, but no matter what I
choose the data then disappears into a sea of #REF when I dismiss the dialog
box. How can I get the old data to show again?
...Up/down arrows don't work with data validation list/in-cell dropdown
I have a number of worksheets where I use the in-cell dropdown (from
list) function of data validation. When I open the list by either
clicking on the drop down button or by pressing Alt-Down arrow, the
only way I can move through the list is to grab the scroll bar itself
and move it down. The up and down buttons do not function nor does
clicking in the open space just above or below the scroll bar.
Any ideas as to what is causing this?
I just set up an entire column with Data Validation with List. I used 39
entries in the list. The up/down buttons are working as they ...In Outlook 2k w/Word as editor, e-mail style fails
I use Word as the editor under Outlook. When Word is
open, the style box shows my name as a defined style for
the text of a note. I have modified this style and
applied it repeatly, but it will not "take." In my case,
I'm stuck in 10-point type with a wide line length that
make it very hard for me to read. Advice? Thanks.
...Problem displaying data in a Editbox
I am trying to display serial data in Edit box. The serial handler
code is obtained from http://www.codeproject.com/KB/system/serial.aspx.
In the serial handler, I use the SetwindowText to display the string
but instead I get an occasional first character being displayed in the
edit box instead of the full string.
I have set the edit box properties with multiline, auto vertical
scroll, want return, read only. I have also debug the code and place
the string in the watch window and it seem to receive the full
Any help please.
<email@example.com...Formatting data table
I have a data table shown under a diagram. However it won't display all the
decimals. I.e. in the input to the diagram for january 2006 is 1.123, but
only 1.1 is shown in the data table. The only solution seems to be to enlarge
the diagram but this is not an option in this particular case!
As a last resort I could embed a table under a traditional diagram without
the data table, but that is second best.
Looking forward to any help
If you right click on the data table you can change the font size by clicking
on 'format data table' and the font tab. You can type in the size ...EXCEL tabular data extract
Hi have a excel file with the next kind of data:
I want to extract all the faxes from that table, bu the problem is that all...how do i create an office data connection file
i want to call a parameterized data connection. i want to eventually put
this in office sharepoint server 2007's data connection library. every time
i open the connection file i have successfully created that connects to the
db, it want me to pick a table. i can cancel out of that and change it to
sql and say to use a procedure, but i can't save this file, and the "Edit
Query..." and "Parameters..." buttons are disabled so i can't set
why is it so hard to work with this thing?
...Copying data but keeping original
I have two spreadsheets with several rows of data on each of them, they
both have header rows, with the same heading names. I want to copy the
data from spreadsheet 1 ( without the header row) to the spreadsheet 2
but keeping spreadsheet 2 original data ( i.e NOT REPLACE ) i just want
the data on spreadsheet 1 to be pasted on after the last line of data
on spreadsheet 2; as i need to keep the existing data in spreadsheet 2.
Any ideas on how I can do this with a macro or VB code?
Help appreciated thanks!
See Ron de Bruin's site for various copying macros.
I can print word and excel documents, but when I go to print a full page of
labels I can't. My printer shows a meesage to add paper when I all ready have
have you tried to remove
the paper from the printer
before printing labels?
then simply feed the
printer with the label
paper when it asks.
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Veteran of the Armed Forces
- Microsoft Partner
~~~~~~~~~~"share the nirvana" - dbZen
...Edit specific range in protected worksheet
I have a workbook with multiple worksheets. I protected a sheet but some
menu does not work when it is protectd. e.g. i want to go edit > fill >
How it can be possible.
Thanks in advance
Rao Ratan Singh
If it's protected, you simply can't. You'd have to unprotect it first. Or
write a VBA procedure to unprotect, do the fill series, reprotect.
"Rao Ratan Singh" <RaoRatanSingh@discussions.microsoft.com> wrote in message
> Dear Sir/Mam,
> I have a w...Outlook Journal Exporting Data
Please help if you can.
I recently set up a journal with various entries. I can export my data
into an excel file.
However, I can see journals from others that have chosen to share the
journal with me and would like to export their data into excell as
well. The brute force method is to copy their journals into a folder.
But I was hoping there would be a more elegant solution where I can
dump all journals at once to an excel file. This may be adumb question,
hopefully it is and there is an easy way to do it???
Thanks in advance,
...Data extraction #2
I have a data base as below giving datewise requirement of parts
Part 01.07.06 02.07.06 03.07.06
A 50 50
B 70 10
D 50 70
F 10 5
I would like to have the data in the following format
Date Part Requirement
01.07.06 A 50
02.07.06 B 70
02.07.06 D 50
02.07.06 E 5
02.07.06 F 10
How do I do it using formulas?
Jimmy Joseph wrote:
> I have a data base as below giving datewise requirement of parts
> Part 01.07.06 02.07.06 03.07.06
> A 50 ...Charting Web based data
With the data of say a stock price always changing, how
can you chart it on a line graph to show historical plots?
You can either find a site that posts historical data (often downloadable as a text
or worksheet file), or write a macro that gets the price and puts it next in a column.
Another approach is Stephen Bullen's trick that remembers the last X values. I don't
know how it would work for daily values; I think it's for incoming data that changes
rather frequently. But if you want to try, his site is at http://bmsltd.ie.
Jon Peltier, Microsoft Excel MVP
Pe...Anyone know how to Automatically transfer CSV data to Web page forms?
How can you populate a form fields on a html web page (client side)
with data from an Excel file (CSV). The web page has several text
fields for input that I manually populate. I would like to transfer
the data into the web form automatically from the CSV file. How can
this be done?
--------------------------------- --- -- -
Posted with NewsLeecher v3.7 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -
I had some success using the SendKeys method in VBA. It wasn't a web form -- it was a
terminal emulator -- but I think I did...Multiple columns of data saved in a CSV file appears in a single c
The problem is that when I export data from an application to a CSV file and
open it, it is appearing differently on the different PCs which are having
the same versions of Excel (Microsoft Excel 2000 9.0.7924 SP-3).
On one PC, when the saved .csv file is opened, the data in it is spreading a
record record containing some 4 fields across 4 different cells/columns. This
is fine and is what is required for me.
While on the other PC, when the saved .csv file is opened, the entire record
is inserted into a SINGLE CELL/COLUMN containing those 4 values separated by...Labels leaving a blank line where addr2 is missing
Some of my addresses have 1 address line and some have 2. In order to include
all of them in the same label, I'm getting a blank line when address 2 is
missing. Why won't it float if there is a blank line?
First, check that the Section that contains your Address fields is set to
Grow and Shrink. To do this, click inside that section or on the grey bar
just above it but ensure that you are not selecting any controls. In the
Properties box next to Can Grow and Can Shrink (like Alice In Wonderland)
2. Click in the left margin so that you are selecting all your tex...MSPOS: Unable to print the Serial Number on a Price Label
Feature in RMS but not in MSPOS
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
...Retaining Data Point Colors while Deleting a previously plotted Column?
I cannot determine how to keep the data point color associated with a
particular cell in a series from moving. The problem has only occured
as I began going past 12 months of data, under a 12 month rolling data
format. This is the first month that we have more than 12 months, so I
delete the Sept 02 column and add a Sept 03 column.
For some reason, Excel shifts all the previously defined data point
colors to the right by one data point (actually, the data point values
seem to move to the left one position (desired), while the colors stay
in place (undesired). If I could use absolute referen...Creating data in one from from another
I have a DB that has two seperate data forms i want to be able to open one
form from the other and insert some detaisl from the first form into it.
eg. Form one has asset field there is a button to open second form i want it
to link with the form record and input the asset number.
Thanks for you help
One way of doing this is by 'pushing' the value like this:
DoCmd.OpenForm "Firstformname", acNormal
Forms!Secondformname.Fieldname = Forms!firstformname.Form.fieldname
Replace the firstformname with your mainform and the fieldname you want to
push (e.g. assetnumber...Finding a row with the heigest/lowest value under specific conditions.
Goal: Find the row with the highest of lowest value (can be with extra
Example 1 find the row with the highest value.
Example 2 find the row with the highest value not exceeding 3.5.
What is the most elegant (???) way to do this ?
The examples are simple enough, but if they become part of a larger query,
the solutions become less elegant.
(In example 2 the condition is repeated which I consider less elegant.
In the second solution for example 2, the with is used this only works in
recent versions of SQL-server and not in other SQL implementations)