Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm wondering if you can interact with a form while a macro is running?
Also, if a macro is inputting data into a sheet is that considered edit mode? I'm trying to figure out a way around this if @ all possible. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can you explain a little more about what you're trying to do or test? Since,
by definition when you're in break/edit mode the code has stopped executing the answer is very close to no. But by judicious use of breakpoints or the Stop command you can set places in the code to examine/alter data, then continue on to the next point using [F5] or step through your code line by line using [F8] " wrote: I'm wondering if you can interact with a form while a macro is running? Also, if a macro is inputting data into a sheet is that considered edit mode? I'm trying to figure out a way around this if @ all possible. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've been brainstorming on how I want to work a webservice. What I was
thinking is maybe I could link some labels and buttons in a form to cells or maybe just send the data straight to the form. However if there is a request/response being processed I would like to have the ability to use the buttons on the form. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I don't think you want to be running a web service out of Excel. It will
probably need a database tied to something like FrontPage to develop the web based interface for forms. " wrote: I've been brainstorming on how I want to work a webservice. What I was thinking is maybe I could link some labels and buttons in a form to cells or maybe just send the data straight to the form. However if there is a request/response being processed I would like to have the ability to use the buttons on the form. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry I meant user end. I'm not sure what to do. I'd rather not mess
with .net as I really don't like dealing with datagrids and DT's and stuff. Excel is easier. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm afraid I'm going to have to bow out on this one. I don't have enough
experience trying to put interactive Excel application up in a network environment to do you any good at all. For that kind of thing I either: #1 - let one my webmasters do it. #2 - create a web form on a page to display/accept information from the end user and pull inputs into a database, then back at my end, use Excel to grab what it needs from the database and do what needs to be done with it in Excel. I probably shouldn't say this here too loudly, but I usually use PHP and connect with an Access db on my personal site, then manage the db data transfer via other primitive methods (as FTP). But my needs in that area is very meager. Sorry I can't be of more assistance to you. " wrote: Sorry I meant user end. I'm not sure what to do. I'd rather not mess with .net as I really don't like dealing with datagrids and DT's and stuff. Excel is easier. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to stop Tools, Options, Edit | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
How do I edit this macro? | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Running Excel events even in edit mode.... | Excel Discussion (Misc queries) |