Is there a way of adding say excel to a form - which would have the same
functions availabilty as the normal excel application.

I wanted to avoid the user changing from one application to another i.e.
access to excel and back to access.

I have searched all the web sites, but cannot find anything apart from this
, but do not know hoe implement it.
http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp

Thanks
Danny

Danny,

The site you posted shows how to create an Excel Spreadsheet in VB. That is
different from what you are trying to do. It would be helpful if you would
describe the functionality you need so we can help with a good approach.

"Danny" wrote:

> Is there a way of adding say excel to a form - which would have the same
> functions availabilty as the normal excel application.
>
> I wanted to avoid the user changing from one application to another i.e.
> access to excel and back to access.
>
> I have searched all the web sites, but cannot find anything apart from this
> , but do not know hoe implement it.
> http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
>
> Thanks
> Danny
>
>

I use excel to facilitate preparing financial statements ,the data comes from
Access 2002. Excel is well suited for the need to add/or change minor
formatting and to add sub totals in the right place. The reporting function
of access is too restrictive. I have searched for other interactive drill
down reporting programs that could be used to place on top of forms within
access but have not found anything to date.

Any way I wanted the spreadsheet function to be able to pull in data from
Access and prepare the financial statements by using other worksheets on the
same file or by pulling the amounts on a predefined template on the worksheet
.. I would also like to have any work done the the spreadsheet to be saved on
the closure of the active form.

I hope the above helps.
Thanks for your help.
Regards
Danny.

"Klatuu" wrote:

> Danny,
>
> The site you posted shows how to create an Excel Spreadsheet in VB. That is
> different from what you are trying to do. It would be helpful if you would
> describe the functionality you need so we can help with a good approach.
>
> "Danny" wrote:
>
> > Is there a way of adding say excel to a form - which would have the same
> > functions availabilty as the normal excel application.
> >
> > I wanted to avoid the user changing from one application to another i.e.
> > access to excel and back to access.
> >
> > I have searched all the web sites, but cannot find anything apart from this
> > , but do not know hoe implement it.
> > http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
> >
> > Thanks
> > Danny
> >
> >

It can be done, but it is tricky and takes a lot of work. I suggest you
build an Excel template to use and format it the way you need it. Then, you
will have to open it from Access. Not with the Shell function, but by
establishing an instance of Excel. Then you will have to move the data from
your table or query to the spreadsheet. Check out the CopyRecordsetFrom
command.

Then, before you close the instance of Excel, you will have to read the data
out of the spreadsheet. There are at least a couple of ways to do this.

Without knowing the details, and because of the complexity of the issue, I
can't really give you a detailed answer here. You might try "VBA for
Dummies". It has some good basics on coding for Excel.

"Danny" wrote:

> I use excel to facilitate preparing financial statements ,the data comes from
> Access 2002. Excel is well suited for the need to add/or change minor
> formatting and to add sub totals in the right place. The reporting function
> of access is too restrictive. I have searched for other interactive drill
> down reporting programs that could be used to place on top of forms within
> access but have not found anything to date.
>
> Any way I wanted the spreadsheet function to be able to pull in data from
> Access and prepare the financial statements by using other worksheets on the
> same file or by pulling the amounts on a predefined template on the worksheet
> . I would also like to have any work done the the spreadsheet to be saved on
> the closure of the active form.
>
> I hope the above helps.
> Thanks for your help.
> Regards
> Danny.
>
> "Klatuu" wrote:
>
> > Danny,
> >
> > The site you posted shows how to create an Excel Spreadsheet in VB. That is
> > different from what you are trying to do. It would be helpful if you would
> > describe the functionality you need so we can help with a good approach.
> >
> > "Danny" wrote:
> >
> > > Is there a way of adding say excel to a form - which would have the same
> > > functions availabilty as the normal excel application.
> > >
> > > I wanted to avoid the user changing from one application to another i.e.
> > > access to excel and back to access.
> > >
> > > I have searched all the web sites, but cannot find anything apart from this
> > > , but do not know hoe implement it.
> > > http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
> > >
> > > Thanks
> > > Danny
> > >
> > >

Sounds too complicated for me.-as an alternative would this sort of thing be
any good

http://www.mathworks.com/matlabcentr...?objectId=6889

Danny

"Klatuu" wrote:

> It can be done, but it is tricky and takes a lot of work. I suggest you
> build an Excel template to use and format it the way you need it. Then, you
> will have to open it from Access. Not with the Shell function, but by
> establishing an instance of Excel. Then you will have to move the data from
> your table or query to the spreadsheet. Check out the CopyRecordsetFrom
> command.
>
> Then, before you close the instance of Excel, you will have to read the data
> out of the spreadsheet. There are at least a couple of ways to do this.
>
> Without knowing the details, and because of the complexity of the issue, I
> can't really give you a detailed answer here. You might try "VBA for
> Dummies". It has some good basics on coding for Excel.
>
> "Danny" wrote:
>
> > I use excel to facilitate preparing financial statements ,the data comes from
> > Access 2002. Excel is well suited for the need to add/or change minor
> > formatting and to add sub totals in the right place. The reporting function
> > of access is too restrictive. I have searched for other interactive drill
> > down reporting programs that could be used to place on top of forms within
> > access but have not found anything to date.
> >
> > Any way I wanted the spreadsheet function to be able to pull in data from
> > Access and prepare the financial statements by using other worksheets on the
> > same file or by pulling the amounts on a predefined template on the worksheet
> > . I would also like to have any work done the the spreadsheet to be saved on
> > the closure of the active form.
> >
> > I hope the above helps.
> > Thanks for your help.
> > Regards
> > Danny.
> >
> > "Klatuu" wrote:
> >
> > > Danny,
> > >
> > > The site you posted shows how to create an Excel Spreadsheet in VB. That is
> > > different from what you are trying to do. It would be helpful if you would
> > > describe the functionality you need so we can help with a good approach.
> > >
> > > "Danny" wrote:
> > >
> > > > Is there a way of adding say excel to a form - which would have the same
> > > > functions availabilty as the normal excel application.
> > > >
> > > > I wanted to avoid the user changing from one application to another i.e.
> > > > access to excel and back to access.
> > > >
> > > > I have searched all the web sites, but cannot find anything apart from this
> > > > , but do not know hoe implement it.
> > > > http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
> > > >
> > > > Thanks
> > > > Danny
> > > >
> > > >

I have not seen this before, but I do know that products like this exist. It
would be worthwhile to download it and try it out.

"Danny" wrote:

> Sounds too complicated for me.-as an alternative would this sort of thing be
> any good
>
> http://www.mathworks.com/matlabcentr...?objectId=6889
>
> Danny
>
> "Klatuu" wrote:
>
> > It can be done, but it is tricky and takes a lot of work. I suggest you
> > build an Excel template to use and format it the way you need it. Then, you
> > will have to open it from Access. Not with the Shell function, but by
> > establishing an instance of Excel. Then you will have to move the data from
> > your table or query to the spreadsheet. Check out the CopyRecordsetFrom
> > command.
> >
> > Then, before you close the instance of Excel, you will have to read the data
> > out of the spreadsheet. There are at least a couple of ways to do this.
> >
> > Without knowing the details, and because of the complexity of the issue, I
> > can't really give you a detailed answer here. You might try "VBA for
> > Dummies". It has some good basics on coding for Excel.
> >
> > "Danny" wrote:
> >
> > > I use excel to facilitate preparing financial statements ,the data comes from
> > > Access 2002. Excel is well suited for the need to add/or change minor
> > > formatting and to add sub totals in the right place. The reporting function
> > > of access is too restrictive. I have searched for other interactive drill
> > > down reporting programs that could be used to place on top of forms within
> > > access but have not found anything to date.
> > >
> > > Any way I wanted the spreadsheet function to be able to pull in data from
> > > Access and prepare the financial statements by using other worksheets on the
> > > same file or by pulling the amounts on a predefined template on the worksheet
> > > . I would also like to have any work done the the spreadsheet to be saved on
> > > the closure of the active form.
> > >
> > > I hope the above helps.
> > > Thanks for your help.
> > > Regards
> > > Danny.
> > >
> > > "Klatuu" wrote:
> > >
> > > > Danny,
> > > >
> > > > The site you posted shows how to create an Excel Spreadsheet in VB. That is
> > > > different from what you are trying to do. It would be helpful if you would
> > > > describe the functionality you need so we can help with a good approach.
> > > >
> > > > "Danny" wrote:
> > > >
> > > > > Is there a way of adding say excel to a form - which would have the same
> > > > > functions availabilty as the normal excel application.
> > > > >
> > > > > I wanted to avoid the user changing from one application to another i.e.
> > > > > access to excel and back to access.
> > > > >
> > > > > I have searched all the web sites, but cannot find anything apart from this
> > > > > , but do not know hoe implement it.
> > > > > http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
> > > > >
> > > > > Thanks
> > > > > Danny
> > > > >
> > > > >

"Danny" <(E-Mail Removed)> wrote in message
news:45EFDC41-B095-4BC5-A98B-(E-Mail Removed)...
> Sounds too complicated for me.-as an alternative would this sort of thing
be
> any good
>
>
http://www.mathworks.com/matlabcentr...o?objectId=688
9
>
> Danny
>
> "Klatuu" wrote:
>
> > It can be done, but it is tricky and takes a lot of work. I suggest you
> > build an Excel template to use and format it the way you need it. Then,
you
> > will have to open it from Access. Not with the Shell function, but by
> > establishing an instance of Excel. Then you will have to move the data
from
> > your table or query to the spreadsheet. Check out the CopyRecordsetFrom
> > command.
> >
> > Then, before you close the instance of Excel, you will have to read the
data
> > out of the spreadsheet. There are at least a couple of ways to do this.
> >
> > Without knowing the details, and because of the complexity of the issue,
I
> > can't really give you a detailed answer here. You might try "VBA for
> > Dummies". It has some good basics on coding for Excel.
> >
> > "Danny" wrote:
> >
> > > I use excel to facilitate preparing financial statements ,the data
comes from
> > > Access 2002. Excel is well suited for the need to add/or change minor
> > > formatting and to add sub totals in the right place. The reporting
function
> > > of access is too restrictive. I have searched for other interactive
drill
> > > down reporting programs that could be used to place on top of forms
within
> > > access but have not found anything to date.
> > >
> > > Any way I wanted the spreadsheet function to be able to pull in data
from
> > > Access and prepare the financial statements by using other worksheets
on the
> > > same file or by pulling the amounts on a predefined template on the
worksheet
> > > . I would also like to have any work done the the spreadsheet to be
saved on
> > > the closure of the active form.
> > >
> > > I hope the above helps.
> > > Thanks for your help.
> > > Regards
> > > Danny.
> > >
> > > "Klatuu" wrote:
> > >
> > > > Danny,
> > > >
> > > > The site you posted shows how to create an Excel Spreadsheet in VB.
That is
> > > > different from what you are trying to do. It would be helpful if
you would
> > > > describe the functionality you need so we can help with a good
approach.
> > > >
> > > > "Danny" wrote:
> > > >
> > > > > Is there a way of adding say excel to a form - which would have
the same
> > > > > functions availabilty as the normal excel application.
> > > > >
> > > > > I wanted to avoid the user changing from one application to
another i.e.
> > > > > access to excel and back to access.
> > > > >
> > > > > I have searched all the web sites, but cannot find anything apart
from this
> > > > > , but do not know hoe implement it.
> > > > > http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
> > > > >
> > > > > Thanks
> > > > > Danny
> > > > >
> > > > >

Danny,

Send me an email and I will tell you about an alternative.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(E-Mail Removed)
www.pcdatasheet.com



"Danny" <(E-Mail Removed)> wrote in message
news:45EFDC41-B095-4BC5-A98B-(E-Mail Removed)...
> Sounds too complicated for me.-as an alternative would this sort of thing
be
> any good
>
>
http://www.mathworks.com/matlabcentr...o?objectId=688
9
>
> Danny
>
> "Klatuu" wrote:
>
> > It can be done, but it is tricky and takes a lot of work. I suggest you
> > build an Excel template to use and format it the way you need it. Then,
you
> > will have to open it from Access. Not with the Shell function, but by
> > establishing an instance of Excel. Then you will have to move the data
from
> > your table or query to the spreadsheet. Check out the CopyRecordsetFrom
> > command.
> >
> > Then, before you close the instance of Excel, you will have to read the
data
> > out of the spreadsheet. There are at least a couple of ways to do this.
> >
> > Without knowing the details, and because of the complexity of the issue,
I
> > can't really give you a detailed answer here. You might try "VBA for
> > Dummies". It has some good basics on coding for Excel.
> >
> > "Danny" wrote:
> >
> > > I use excel to facilitate preparing financial statements ,the data
comes from
> > > Access 2002. Excel is well suited for the need to add/or change minor
> > > formatting and to add sub totals in the right place. The reporting
function
> > > of access is too restrictive. I have searched for other interactive
drill
> > > down reporting programs that could be used to place on top of forms
within
> > > access but have not found anything to date.
> > >
> > > Any way I wanted the spreadsheet function to be able to pull in data
from
> > > Access and prepare the financial statements by using other worksheets
on the
> > > same file or by pulling the amounts on a predefined template on the
worksheet
> > > . I would also like to have any work done the the spreadsheet to be
saved on
> > > the closure of the active form.
> > >
> > > I hope the above helps.
> > > Thanks for your help.
> > > Regards
> > > Danny.
> > >
> > > "Klatuu" wrote:
> > >
> > > > Danny,
> > > >
> > > > The site you posted shows how to create an Excel Spreadsheet in VB.
That is
> > > > different from what you are trying to do. It would be helpful if
you would
> > > > describe the functionality you need so we can help with a good
approach.
> > > >
> > > > "Danny" wrote:
> > > >
> > > > > Is there a way of adding say excel to a form - which would have
the same
> > > > > functions availabilty as the normal excel application.
> > > > >
> > > > > I wanted to avoid the user changing from one application to
another i.e.
> > > > > access to excel and back to access.
> > > > >
> > > > > I have searched all the web sites, but cannot find anything apart
from this
> > > > > , but do not know hoe implement it.
> > > > > http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
> > > > >
> > > > > Thanks
> > > > > Danny
> > > > >
> > > > >

I have a question! I want to link a fully functional spreadsheet with
formulas with my access database. I linked them however when in access: one
column that does not contain formulas is blank...also another column with the
following formula =IF(AA4<0,"$0.00",IF(AA4>0,AA4)) is showing up with the
following: #Num!. Also is there a way to use access only and have the
formulas updated? The reason I linked the 2 is all the information was in
excel and I need the formulas and my company wants the info in access to run
reports and to store the info. Am I going about this in the right way?
Help!!!

"Danny" wrote:

> Is there a way of adding say excel to a form - which would have the same
> functions availabilty as the normal excel application.
>
> I wanted to avoid the user changing from one application to another i.e.
> access to excel and back to access.
>
> I have searched all the web sites, but cannot find anything apart from this
> , but do not know hoe implement it.
> http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
>
> Thanks
> Danny
>
>

I have a question! I want to link a fully functional spreadsheet with
formulas with my access database. I linked them however when in access: one
column that does not contain formulas is blank...also another column with the
following formula =IF(AA4<0,"$0.00",IF(AA4>0,AA4)) is showing up with the
following: #Num!. Also is there a way to use access only and have the
formulas updated? The reason I linked the 2 is all the information was in
excel and I need the formulas and my company wants the info in access to run
reports and to store the info. Am I going about this in the right way?
"PC Datasheet" wrote:

> Danny,
>
> Send me an email and I will tell you about an alternative.
>
> --
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications
> (E-Mail Removed)
> www.pcdatasheet.com
>
>
>
> "Danny" <(E-Mail Removed)> wrote in message
> news:45EFDC41-B095-4BC5-A98B-(E-Mail Removed)...
> > Sounds too complicated for me.-as an alternative would this sort of thing
> be
> > any good
> >
> >
> http://www.mathworks.com/matlabcentr...o?objectId=688
> 9
> >
> > Danny
> >
> > "Klatuu" wrote:
> >
> > > It can be done, but it is tricky and takes a lot of work. I suggest you
> > > build an Excel template to use and format it the way you need it. Then,
> you
> > > will have to open it from Access. Not with the Shell function, but by
> > > establishing an instance of Excel. Then you will have to move the data
> from
> > > your table or query to the spreadsheet. Check out the CopyRecordsetFrom
> > > command.
> > >
> > > Then, before you close the instance of Excel, you will have to read the
> data
> > > out of the spreadsheet. There are at least a couple of ways to do this.
> > >
> > > Without knowing the details, and because of the complexity of the issue,
> I
> > > can't really give you a detailed answer here. You might try "VBA for
> > > Dummies". It has some good basics on coding for Excel.
> > >
> > > "Danny" wrote:
> > >
> > > > I use excel to facilitate preparing financial statements ,the data
> comes from
> > > > Access 2002. Excel is well suited for the need to add/or change minor
> > > > formatting and to add sub totals in the right place. The reporting
> function
> > > > of access is too restrictive. I have searched for other interactive
> drill
> > > > down reporting programs that could be used to place on top of forms
> within
> > > > access but have not found anything to date.
> > > >
> > > > Any way I wanted the spreadsheet function to be able to pull in data
> from
> > > > Access and prepare the financial statements by using other worksheets
> on the
> > > > same file or by pulling the amounts on a predefined template on the
> worksheet
> > > > . I would also like to have any work done the the spreadsheet to be
> saved on
> > > > the closure of the active form.
> > > >
> > > > I hope the above helps.
> > > > Thanks for your help.
> > > > Regards
> > > > Danny.
> > > >
> > > > "Klatuu" wrote:
> > > >
> > > > > Danny,
> > > > >
> > > > > The site you posted shows how to create an Excel Spreadsheet in VB.
> That is
> > > > > different from what you are trying to do. It would be helpful if
> you would
> > > > > describe the functionality you need so we can help with a good
> approach.
> > > > >
> > > > > "Danny" wrote:
> > > > >
> > > > > > Is there a way of adding say excel to a form - which would have
> the same
> > > > > > functions availabilty as the normal excel application.
> > > > > >
> > > > > > I wanted to avoid the user changing from one application to
> another i.e.
> > > > > > access to excel and back to access.
> > > > > >
> > > > > > I have searched all the web sites, but cannot find anything apart
> from this
> > > > > > , but do not know hoe implement it.
> > > > > > http://www.vbdotnetheaven.com/Code/Jul2003/2124.asp
> > > > > >
> > > > > > Thanks
> > > > > > Danny
> > > > > >
> > > > > >
>
>
>