Search results

This is probably an Excel question, but I have not found an Excel site as good as this one. I am trying to run an Excel macro every morning that will run some code and then open an Access database that runs some more code and then closes. I know how to go form Access to Excel, but cannot figure...

Our company is needing a new Fixed Asset system to track assets and run the deprecation for the company. I noticed there is a sample database for Asset Tracking, but I am having to tweek it so much to get the depreciation part of it working. I was just wondering if anyone used Access for their...

I use the TransferSpreadsheet command to export tables of information to Excel and it always works very successfully. But, when I tried it today I hit a hang up. The information transfers to the Excel file, but it corrupts the file. When I open the file it says "Excel.exe has generated an error...

Is there a way to start a Macro in Excel and then "jump" to Access and run a Macro there and then "jump" back to the Excel file? I'm building a report that needs massaged in Access, but the end-user does not want to learn Access, they want everything to run at the push of a button in Excel. (?)

I have about 100 queries set up that are using the same table, but pulling different data. As I roll into next year, I want to use the same database with the same queries but I want to rename the table 2003 (from 2002). When I rename the table, some of the queries recognize the new table and...