Return Control to Access after Excel manipulation

[Gene]

In order to make it easier for the end-user of an Access
program I wrote, I need to open an Excel Spreadsheet, allow
them to manipulate it, and then allow them to actively
return to the Access program when they are done. I can open
and close the Excel sheet (thanks to help from this
newsgroup), but I can't find a one click solution to the
end user returning to the Access program after they have
manipulated the spreadsheet.
Example: One aspect of the Access program is importing
data. Because multiple sources are used to retrieve the
original data, and each of them has their own format, it is
easiest to paste that data into Excel, and then delete the
unnecessary data and move the rest of the data into the
appropriate columns. It is not easy to do that in an Access
table. Because that spread sheet is linked to a table in
Access, I must rigorously maintain the file name and
location. After the editing in excel, it is easy to work
with the formatted data in the linked Access Table.
So in Access, the end user clicks a command button that
opens the specific excel spread sheet (using
Application.Visible), and manipulate the data. When they
are done, I want to give them a "click here to return"
button so they can get back to the Access Program, but I
can't figure it out. I have tried a timing loop and
interrupting the excel work asking if they are done. That
is cute, but if it occurs at the wrong time, Excel hangs,
so it is not perfect, much less making you dizzy. Any
Access solutions before I resort to learning Excel VBA?
Thanks.
Gene

 

[John Nurick]

Hi Gene,

It sounds like you will need to study Excel VBA so that after launching
Excel but before you make it visible, you can remove commands you don't
want the user using (e.g. Save As) and add a Save & Return command.

 

[Gene]

John,
Thank you, not a task I look forward to. Is there anyway
for an excel spread sheet to be visible and active within
the Access environment, like a subform, which still allows
Access VBA buttons to be available to the end user? The
way I do it, once Excel is open, Access goes to the
background, and is no longer visible or useable until Excel
is closed.
Thanks again.
Gene

-----Original Message-----
Hi Gene,

It sounds like you will need to study Excel VBA so that after launching
Excel but before you make it visible, you can remove commands you don't
want the user using (e.g. Save As) and add a Save & Return command.

In order to make it easier for the end-user of an Access
program I wrote, I need to open an Excel Spreadsheet, allow
them to manipulate it, and then allow them to actively
return to the Access program when they are done. I can open
and close the Excel sheet (thanks to help from this
newsgroup), but I can't find a one click solution to the
end user returning to the Access program after they have
manipulated the spreadsheet.
Example: One aspect of the Access program is importing
data. Because multiple sources are used to retrieve the
original data, and each of them has their own format, it is
easiest to paste that data into Excel, and then delete the
unnecessary data and move the rest of the data into the
appropriate columns. It is not easy to do that in an Access
table. Because that spread sheet is linked to a table in
Access, I must rigorously maintain the file name and
location. After the editing in excel, it is easy to work
with the formatted data in the linked Access Table.
So in Access, the end user clicks a command button that
opens the specific excel spread sheet (using
Application.Visible), and manipulate the data. When they
are done, I want to give them a "click here to return"
button so they can get back to the Access Program, but I
can't figure it out. I have tried a timing loop and
interrupting the excel work asking if they are done. That
is cute, but if it occurs at the wrong time, Excel hangs,
so it is not perfect, much less making you dizzy. Any
Access solutions before I resort to learning Excel VBA?
Thanks.
Gene

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Experiment with an unbound ObjectFrame control on a form.

John,
Thank you, not a task I look forward to. Is there anyway
for an excel spread sheet to be visible and active within
the Access environment, like a subform, which still allows
Access VBA buttons to be available to the end user? The
way I do it, once Excel is open, Access goes to the
background, and is no longer visible or useable until Excel
is closed.
Thanks again.
Gene

-----Original Message-----
Hi Gene,

It sounds like you will need to study Excel VBA so that after launching
Excel but before you make it visible, you can remove commands you don't
want the user using (e.g. Save As) and add a Save & Return command.

In order to make it easier for the end-user of an Access
program I wrote, I need to open an Excel Spreadsheet, allow
them to manipulate it, and then allow them to actively
return to the Access program when they are done. I can open
and close the Excel sheet (thanks to help from this
newsgroup), but I can't find a one click solution to the
end user returning to the Access program after they have
manipulated the spreadsheet.
Example: One aspect of the Access program is importing
data. Because multiple sources are used to retrieve the
original data, and each of them has their own format, it is
easiest to paste that data into Excel, and then delete the
unnecessary data and move the rest of the data into the
appropriate columns. It is not easy to do that in an Access
table. Because that spread sheet is linked to a table in
Access, I must rigorously maintain the file name and
location. After the editing in excel, it is easy to work
with the formatted data in the linked Access Table.
So in Access, the end user clicks a command button that
opens the specific excel spread sheet (using
Application.Visible), and manipulate the data. When they
are done, I want to give them a "click here to return"
button so they can get back to the Access Program, but I
can't figure it out. I have tried a timing loop and
interrupting the excel work asking if they are done. That
is cute, but if it occurs at the wrong time, Excel hangs,
so it is not perfect, much less making you dizzy. Any
Access solutions before I resort to learning Excel VBA?
Thanks.
Gene

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.