UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Keeping Excel File Into Access Db Or Create Excel File With Vba Project From Access, Access 2016    
 
   
Sami
post May 25 2019, 11:01 AM
Post#1



Posts: 38
Joined: 3-April 19



Hello every body.
I need to insert an excel file with vba project into an access db to be able to export it with specific format and vba codes then export the data into it. I think in another way but I am not sure from being able to exceute it to create an excel file with vba project into it.
Thanks in advance .
Go to the top of the page
 
GroverParkGeorge
post May 25 2019, 11:27 AM
Post#2


UA Admin
Posts: 35,175
Joined: 20-June 02
From: Newcastle, WA


Unfortunately, the process you describe doesn't seem to be possible, but perhaps it's because it's not clear what you want to have happen.

You can't insert an Excel workbook into Access. So that's not possible. However, you may be able to achieve the desired end result in a different way.

Are you talking about importing DATA from an Excel file into Access tables?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
theDBguy
post May 25 2019, 11:30 AM
Post#3


Access Wiki and Forums Moderator
Posts: 75,604
Joined: 19-June 07
From: SunnySandyEggo


Hi. If you're trying to "package" a macro enabled spreadsheet with your database, one possible approach is to store it as an Attachment in a table. Otherwise, you can just include it in your install package for your app.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
ADezii
post May 25 2019, 11:55 AM
Post#4



Posts: 2,399
Joined: 4-February 07
From: USA, Florida, Delray Beach


  1. You can store the Macro Enabled Workbook (*.xlsm) in an OLE Object Field in a Table.
  2. Create a Form with a Bound Object Frame whose Control Source is the OLE Object Field previously mentioned.
  3. Double-Click the Bound Object Frame to Auto-Activate the Macro Enabled Workbook within Access.
  4. You will now see part the OLE Server's (Excel) Menu Structure interspersed among Access's own Menu Structure.
  5. Keep in mind that if done in this matter, the Workbook is Embedded and NOT Linkked.
Go to the top of the page
 
Sami
post May 25 2019, 12:24 PM
Post#5



Posts: 38
Joined: 3-April 19



Thank you theDBguy
QUOTE
one possible approach is to store it as an Attachment in a table.
I think that what I need as long as I can't insert the excel file in the access so I want to ask about attach the excel files in the access table, can I export it from this table on the same path of access db programmatically?
And can I change the name of this file when I export it programmatically?
Thank you GroverParkGeorge
QUOTE
Are you talking about importing DATA from an Excel file into Access tables?
I want to export data frim access into an excel file with vba project .
This post has been edited by Sami: May 25 2019, 12:34 PM
Go to the top of the page
 
theDBguy
post May 25 2019, 12:33 PM
Post#6


Access Wiki and Forums Moderator
Posts: 75,604
Joined: 19-June 07
From: SunnySandyEggo


QUOTE
...I want to ask about attach the excel files in the access table, can I export it from this table on the same path of access db programmatically?

Hi. If you use an Attachment field, yes you can. Have a look here.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Sami
post May 25 2019, 12:52 PM
Post#7



Posts: 38
Joined: 3-April 19



Thank you greatly theDBguy
Go to the top of the page
 
theDBguy
post May 25 2019, 12:53 PM
Post#8


Access Wiki and Forums Moderator
Posts: 75,604
Joined: 19-June 07
From: SunnySandyEggo


Hi. You're welcome. We're all happy to assist. Good luck and let us know how it goes!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    25th June 2019 - 12:47 PM