-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
access to excel
-
R
Access SQL query to Excel output
Hi I am running sql which prompts the user to select the directory where they want to save the result. It worked when I had it as csv, but when I change it to be xlsx as below, I get the error "Excel cannot open the file 'filename.xlsx' because the file format for the file extension is not...- Ronanm
- Thread
- access to excel query sql query to excel sql vba sqll
- Replies: 1
- Forum: Excel Questions
-
Macro to see who has accessed my spreadsheet and when
I know I have asked this before, but I can't find it. I have a spreadsheet that I have about 7 people regularly accessing. As is always the case, somebody messes the file up, or leaves it open, so others can't update. What i am looking for is a macro that will recorded every time a user...- DPChristman
- Thread
- access to excel file macro spreadsheet tracking users
- Replies: 18
- Forum: Excel Questions
-
K
VBA to send Access tables to individual worksheets in Excel...
Hi all, I was wondering if there was some VBA code that could be used to send tables from Access to multiple tabs to an existing Excel document? Or create a new document. I suppose either would work. Please and thank you. Also posted in Excel forum here...- kyleno
- Thread
- access to excel excel multiple tabs tables vba
- Replies: 1
- Forum: Microsoft Access
-
D
Creating a graph for every row of data using Excel exported by Microsoft Access coded in VBA
I need to graph 2D stacked area graphs, so this is how I am trying to do it. I'm using Microsoft Access exporting with VBA into excel and trying to create a 2d stacked area graph based upon two different imported tables. The best part, is I need a separate graph for each row of data being...- doubllehellix
- Thread
- access to excel chart graph vba vba & excel to access
- Replies: 0
- Forum: Excel Questions
-
P
Access query from Excel
Hi everyone, and thanks in advance for your help. I have a splitting headache dealing with queries in excel.:confused: I have an apparently simple problem. I would like to trigger an Access query from Excel and subsequently to export the results to my spreadsheet. What is more, I would like to...- peperosso
- Thread
- access to excel query query answer macro
- Replies: 0
- Forum: Excel Questions
-
K
Excel Macro to grab tables from Access database
Hi Guys, Kindly please guide me if there is any macro to grab lets said 20 tables from access database at specified directory. the access database as per link: https://www.sendspace.com/file/zhhiq0 thank you- kentck86
- Thread
- access access to excel macro
- Replies: 1
- Forum: Excel Questions
-
D
EXTREMELY URGENT: Problem with exlApp.Workbooks.Open() function in VBA
Hi all, I am trying to run a VBA code in Access to open an excel file and export some data into it. This has worked before with Excel 2003. I had to recently migrate to Excel 2007 and I am getting various errors one by one, but at this point I am stuck at this particular step of opening an...- DimlyLitMind
- Thread
- access 07 access to excel vba & excel 2007
- Replies: 6
- Forum: Microsoft Access
-
J
Export field value to excel cell
Hello. This is my fist posting on this forum, and first posting on any forum for that matter. I have been trying for some time to export the value in my access field into an excel cell. The user will dblclick a hyperlink, which will open the corresponding file, as well open an excel template...- jbush
- Thread
- access 2003 access to excel access variable excel 2003 transfer data
- Replies: 1
- Forum: Microsoft Access
