QUESTION ABOUT EXCEL FUNCTIONS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have 3 questions to ask
1. I'm opening 2 workbooks (first.xls & second.xls). How to create macro that save and exit the second.xls but the first.xls still remaining

2. Any idea how to insert a counter in exel

3. How to make the dropdown button using list function all the time appear in the screen. Not like now when you click then the button appear

TQ.
 
Hi
1. If both workbooks are openend try something like:
sub foo()
dim wbk 1 as workbook
dim wbk2 as workbook
set wbk1 = workbooks("first.xls")
set wbk2=workbooks("second.xls")
wbk2.save
wbk2.close
wbk1.activate
end sub

2. Do you mean a stop clock. If yes see:
http://www.mvps.org/dmcritchie/excel/datetime.htm
(at the bottom of this page)

3. AFAIK this is not possible
 
On question no.2, what I mean is: how to know number of users access / open that file
TQ

----- Frank Kabel wrote: ----

H
1. If both workbooks are openend try something like
sub foo(
dim wbk 1 as workboo
dim wbk2 as workboo
set wbk1 = workbooks("first.xls"
set wbk2=workbooks("second.xls"
wbk2.sav
wbk2.clos
wbk1.activat
end su

2. Do you mean a stop clock. If yes see
http://www.mvps.org/dmcritchie/excel/datetime.ht
(at the bottom of this page

3. AFAIK this is not possibl

--
Regard
Frank Kabe
Frankfurt, German


Param wrote
 
Hi, Thanks for your guide
For question no.1, I link few files together (around 5). When user click macro button inside one of the files, what I want is MS.Excel - save the data & exit for the active file only

----- Frank Kabel wrote: ----

H
1. If both workbooks are openend try something like
sub foo(
dim wbk 1 as workboo
dim wbk2 as workboo
set wbk1 = workbooks("first.xls"
set wbk2=workbooks("second.xls"
wbk2.sav
wbk2.clos
wbk1.activat
end su

2. Do you mean a stop clock. If yes see
http://www.mvps.org/dmcritchie/excel/datetime.ht
(at the bottom of this page

3. AFAIK this is not possibl

--
Regard
Frank Kabe
Frankfurt, German


Param wrote
 
Back
Top