Search results for query: *

I don't have that luxury. Management wants what it wants and I have to figure out how to supply it.

We have an Excel spreadsheet with numerous 3-D chart objects, mostly the 21st Century pie chart but also other bar charts. I need to embed those objects into an Access report but the shadows show up as dots and lines are jagged. I found that linking the charts to a Word doc first, then embedding...

I don't use Access to chart because the end result looks like a first grader with brightly colored markers had at it. I need to use 3-D type objects like the 21st Century pie chart. The problem is that the shadows and depth show up as dots, and lines and colors are distorted. Very cartoonish.

I am exporting data to an Excel spreadsheet, which creates a couple of charts that I need to link to an Access report. There are a couple of worksheets each containing several charts. 1) when I create an unbound object box and link the spreadsheet file to it, it only picks up part of the first...

To other people like me who have the same question, here is how I solved the problem. In a nutshell, it deletes a file, runs a macro that exports data to Excel, then opens/closes/saves the two Excel files involved, then finally imports the data back to Access and previews a report. Hope this...

I'm sorry but I'm totally frazzled and confused. Is this what you're talking about? ' Open an existing WORKBOOK Workbook.Open ("C:\FS\Plan1.xls") 'set the Excel application object GetObject("Excel.Application") Set appExcel = .Parent...

Ok, I get it, but if I open Excel and try to open Plan1.xls I still have the same problem, which is the file won't visibly open anymore. Now what?

UH OH. I used your recommended code but it hung up Access and Excel. Now I'm unable to visibly open Plan1.xls at all. Excel opens with the toolbars on top and a blank screen below. I have to go to the Task Manager to end the application. Then Access will function. Helllpppppppp!!!!

I wish. I could use a nice big cupa coffee. The Monster updates instantly, probably around a second or two. Still need a way to open Excel from Access, allowing Plan1 to update, then save and close it without anyone noticing. I'm using this... Private Sub Command514_Click() Dim appExcel As...

I'm guessing you are referring to linking the variables in DataFromAccess.xls to the appropriate cells in Plan1.xls--which has already been done. The issue is that it won't update until I open the file, save and close it. Then the import pulls in the right stuff.

Hey!!! I'm taking my MWAHHHH back. In my defense, I have a co-worker who thinks I care about her life. I ignore her but cannot concentrate so my apologies for appearing to be such an airhead. 2) Hit the PROPERTIES button and in External Data Range Properties, select Refresh data when opening...

Well it certainly helps when I follow alllllll of the instructions to a tee, doesn't it? So, if I understand correctly, doing the query thing above allows Plan1.xls to get the variables from DataFromAccess.xls so that I don't have to open either anymore???????? Plan!.xls will update without...

When I drill down to DataFromAccess.xls, the ADD TABLE box comes up but there are no tables to display. I'm assuming it thinks each worksheet is a table? There is only the one called qryExportToExcel but it doesn't even show up. Any idea why?

Hmmm. Never used MS Query in Excel but would like to! I'm using Excel 2013 to manage Plan1.xls and I don't even see an option for query anywhere. The Help Topics talking about something called Power BI when I search for query. Is there a way to have a macro run automatically when Plan1 is...

I need to automate a process of exporting data to Excel, allowing a spreadsheet no-so-affectionately called The Monster, to do its magic, then import the data back to Access to be used in an already-formatted report. I'm smart enough to recognize that this requires VBA but not at all in order...

A macro behind a button runs a query that exports a few fields to Excel that are then linked to a couple of monster Workbooks. The button works fine but I cannot figure out how to ALSO do the following at the same time... I need : 1) to suppress the message that says the Excel file already...