Free Microsoft Excel 2013 Quick Reference

how to setup an excel inventory that is a deduction

I wish to setup a excel sheet as a inventory of tickets sold


I’m trying to create an Excel form that has a cell which increases by one number (to create a self generating invoice number) each time it is opened.

Does anyone have any idea how I would start to setup an excel spreadsheet for allocating carparks to employees.

At my work we have 3 car parks that are shared between 40 people. Evey 2 weeks - the car park is allocated to another person to use for the next 2 weeks. I have tried to set one up but failed totally.

I need to have the ability to add new staff names and remove staff names of people that have left. New employees go to the end of the list.

And the abiltiy to set the date eg: Week commencing 02 April 2007.

Any assistance/advise would be appreciated.

I have an excel workbook that is opened in IE. In this workbook there is a button that will manipulate some data and then it is to close the workbook. i use ActiveWindow.Close this works fine when i open the workbook in excel. But it does not work when i open the workbook in IE. How do i fix this?

Hi All,

I have a tool called "TestPartner" which uses VBA to test the
applications.
My application opens an Excel file after submitting the data. Now,
using the VBA in TestPartner I have to save that file.

Following is the code written by me.
Dim myExc As Object
Dim myWb As Workbook

Set myExc = CreateObject("Excel.Application")
Set myWb = Excel.ActiveWorkbook

myWb.SaveAs ("Path")

but this is not working.
Please let me know how to save the Excel file which is already opened
using VBA.

Thanks,
Suraj

Can you create an administrator for an excel file that is not subject to the
protection?

I have an excel spreadsheet that is too large to fit in one worksheet. I
was wondering if it possible to open the spreadsheet such that the contents
are automatically divided into different worksheets so I can have all the
data I need open at one time. I would like to divide the data into
worksheets so that there is a separate worksheet for each unique value in
column A. For example if I had a spreadsheet that looked like this:

A B
Monday 6
Monday 1
Monday 2
Tuesday 1
Tuesday 3
Wednesday 4
Wednesday 5
Wednesday 4

I want it to automatically open in excel so that there is a Monday
worksheet, a Tuesday worksheet, and a Wednesday worksheet. Any ideas?

Thanks,
Joe

--
Message posted via http://www.officekb.com

Is it possible to add a button to an excel sheet that exports a table to word when its pressed?

Hi,

I'm a newbie to Excel and VB. My question is:

I have three online files that I can get their output as text files:
-http://DOMAIN.COM/members?list1=sub&export=true&sorted=&query=
-http://DOMAIN.COM/members?list2=sub&export=true&sorted=&query=
-http://DOMAIN.COM/members?list3=sub&export=true&sorted=&query=

With an Excel file that has a macro I can get these files saved automatically to my computer. What I want is to RUN this macro from ASP.

I want to click on a link that will call this macro from ASP...receive the text files and save either in Excel or text format to my computer. What should the ASP code be?

Here is the macro:

Sub Auto_Open()

Workbooks.OpenText Filename:= _
"http://DOMAIN.COM/members?list1=sub&export=true&sorted=&query=" _
, Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier _
:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:= _
False, Comma:=True, Space:=False, Other:=False, FieldInfo:=Array(Array( _
1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, _
1), Array(9, 1)), TrailingMinusNumbers:=True
ActiveWorkbook.SaveAs Filename:="C:File1-" & Day(Date) & "-" & Month(Date) & "-" & Year(Date) & ".xls", FileFormat:= _
xlNormal

End Sub

Sub Auto_Open()

Workbooks.OpenText Filename:= _
"http://DOMAIN.COM/members?list2=sub&export=true&sorted=&query=" _
, Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier _
:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:= _
False, Comma:=True, Space:=False, Other:=False, FieldInfo:=Array(Array( _
1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, _
1), Array(9, 1)), TrailingMinusNumbers:=True
ActiveWorkbook.SaveAs Filename:="C:File2-" & Day(Date) & "-" & Month(Date) & "-" & Year(Date) & ".xls", FileFormat:= _
xlNormal

End Sub

Sub Auto_Open()

Workbooks.OpenText Filename:= _
"http://DOMAIN.COM/members?list3=sub&export=true&sorted=&query=" _
, Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier _
:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:= _
False, Comma:=True, Space:=False, Other:=False, FieldInfo:=Array(Array( _
1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, _
1), Array(9, 1)), TrailingMinusNumbers:=True
ActiveWorkbook.SaveAs Filename:="C:File3-" & Day(Date) & "-" & Month(Date) & "-" & Year(Date) & ".xls", FileFormat:= _
xlNormal

End Sub

How to find the excel file that i just deleted?thanks a lot

I have created a specification form consisting of three columns. The first column provides the question ( e.g. What is the product Name) the other two columns provides the answers.

Everything works well but I am concerned the page looks pretty " plain Jane" goes anyone have report or other Excel document they can share that uses highlighting, shading, 3D etc? Alternatively do you have link to a post or Wiki?

I would like to see how to build an Excel Form that is a real eye catcher and that helps the end user to complete their sections.

Thanks

Is it possible to call an excel spreadsheet that contains a macro that runs
on the server against another spreadsheet to create vbscript include file
and store that file on the user's desktop.

According to my client it is possible, but I have not gotten it to work and
was wondering if anyone else has or any ideas on this?

--
J. D.

I have an Excel worksheet that is sent out to a Distrubution list every
evening. How can I set up a "button" on the spreadsheet to automatically
forward the worksheet as an attachment to an e-mail with a "constant" group
of recipients?

Hi guys and gals,

I am on a forum that uses vbulletin and would like to know if it is possible to post an excel worksheet from excel 98 to a forum post? I would like to post a chart in there for discussion.

If it is possible, how do I do that so the worksheet is transferred?

Hugs,

Mary

Hi All

I need some help. I have created an excel workbook which is linked to a DB database that is refreshed regularly. I am looking for a way to add comments to specific info but that moves with the info when refreshed. I hope this makes sense, any help would be much appreciated.

Not sure if there is somekind of formula?

Thanks

Rachel

I need to manipulate an already open excel spreadsheet using VBScript. My
problem is that I can't seem to be able to get an object reference to excel
if it's open already. I was able to open an excel workbook and add a sheet,
but I wasn't able to connect to a spreadsheet it if it was already open.
Anybody knows how to do it in VBScript?
E.g: manually open MS Excel and type something in Sheet1. Then when you'd
run this VBScript that I need, it would connect to Sheet1 and would display
the content of it in a message box.

Thanks a lot!
JP

I have an Excel worksheet that is sent out to a Distrubution list every
evening. How can I set up a "button" on the spreadsheet to automatically
forward the worksheet as an attachment to an e-mail with a "constant" group
of recipients?

I have an excel workbook that I need to put some conditioning on.

for example:

column e - if the value of the cell is between 100 and 200 then it is green, anything else would be red. The values should be bold too, in this column.

column j - if the value is greater than 200 green, under is red. bolded again.

I did some of this years ago but have been out of the loop and did not realize how much I have forgotten. I have been looking for an answer but nothing is looking right to me.

I was out of work for a while and had to do something. i got in a little over my head. I don't need to lose this gig cause I have a kid on the way.

Any help is appreciated.

I am currently producing reports for hundreds of individuals using mail merge to modify fields such as name, ID#, and locations for each report. I then go in to each document to paste an excel range as a bitmap that is specific to each individual/report.

The excel range comes from a unique excel file for each individual that is saved by the same ID# that I use in my mail merge data source. The range that I select is identical in each file, eg: "A1:U68".

Is there a macro or another method I can use to automatically select, copy, and import the excel range as a bitmap into my mail merge documents by matching the ID# in my source data to the filename and filepath (all the excel files are in the same folder).

Thanks very much!!

I have problems when I rename an excel file, witch is linked to another
excel sheet.
How do I disable the links or can't I do this?

Di
Thank You

I'm trying to save an excell spreadsheet as a (tab delimited) text file.
Everytime I try to save it excel decides to add quotes to some of my cells.
How do I get it to stop doing this?
The cells it adds quotes to are cells that already have quotes in them, it
adds extra quotes around the whole cell. I really don't want that
Also cells that have numbers with commas (ie a cell with 64,4) it decides
needs quotes.
So my text file has "64,4" in it instead of 64,4 and "date "4-8-05""
instead of date "4-8-05"

I opened an excel document sent as email attachment. I did not save it to
disk. I worked on the document while open as an attachment and saved it.
When I went back to the e-mail and opened the atttachment my changes were not
there. I have found several excel document in a temporary file but cannot
open them. The text import wizard says its delimited and it looks like it is
encrypted. Were is my saved Excel attachment and how do I open it. I'm
new to Exel and I promise I will always save to disk in the future.

I want to program an Excel macro to set a columnar range, then perform the
keystroke series "F2, Home, =, Enter" repeatedly until the end of the range
is reached. How do I teach the macro to automatically repeat the keystoke
series? I am using XP, and Excel 2002 10.4. Thanks for your help!!!

I would like to learn how to make an excel spreadsheet that I could enter
codes and have the corresponding payouts sum up. I work as an installer for a
cable company and each job I do consists of codes for work done ( i.e. code
250 -Ran 1 outlet= $8.25, code 251- ran 2 outlets= 16.5 etc..). I would like
to be able to enter these codes at the end of the day and see how much I made
that day. Is this possible? I know very little about Excel, but do have alot
of computer savy. Please help

I opened an excel document sent as email attachment. I did not save it to
disk. I worked on the document while open as an attachment and saved it.
When I went back to the e-mail and opened the atttachment my changes were not
there. I have found several excel document in a temporary file but cannot
open them. The text import wizard says its delimited and it looks like it is
encrypted. Were is my saved Excel attachment and how do I open it. I'm
new to Exel and I promise I will always save to disk in the future.