Hi all,
I'm basically doing an html page with a list of hyperlinks to some
excel files, which are forms. These forms need to be used many times,
so its skeleton version is made read only. However, to speed up the
process of filling in these forms, I have written macros whereby a
userform pops up when you open one of those excel files, and directs
the user to choose or enter in a name for the form (which is a part
number of our products), and the macro saves it with this name.
The problem is this: because the file is read-only, if the user clicks
on the hyperlink, the excel file opens in the internet browser, and
after running the macro, the file is indeed saved in the file that I
have specified, but the browser still shows the read-only file. This
makes it more work for the user, since they then have to click 'back'
on the browser to get back to the main page as well as find the saved
file in the specified file.
There should be 2 ways of doing it:
- let the browser open the file, and let user enter info, and make a
button with a macro so that if they click on it, the macro saves it
with the part number entered -->error 400
- or open the file in an excel application so that when the macro
saves it, the user can continue
using it.
# problem is, the file opens in the internet browser first so
then
excel opens it,
its opened as a read-only (since the same doc is opened twice)
-can
I write code in html to run the excel's macro without opening the
excel file?
Does anyone have any ideas? Right now, I might just leave it.... I'm a
real beginner at this whole thing...
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
