Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.querydao,microsoft.public.excel.programming
|
|||
|
|||
Old report suddenly not running
I have an Access 2000 database that has a VB program to output data into
Excel. I've been running it sucessfully a million times over the past few years. Now it doesn't run (on my PC but still does on everybody elses PC). I've done nothing to my system files and the VB program wasn't changed. Excel opens to a blank spreadsheet but nothing happens after than, and when I go back into Access the following error message is waiting for me. What's worse is when I click OK I still have to quit the app or the hourglass doesn't go away. Does anybody recognize this problem? Error occurred: Nbr = 1004 | Src = Microsoft Excel | Dsc = The file could not be accessed. Try one fo the following: | Make sure the specified folder exists etc. Any advice would be appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Old report suddenly not running
-----Original Message----- I have an Access 2000 database that has a VB program to output data into Excel. I've been running it sucessfully a million times over the past few years. Now it doesn't run (on my PC but still does on everybody elses PC). I've done nothing to my system files and the VB program wasn't changed. Excel opens to a blank spreadsheet but nothing happens after than, and when I go back into Access the following error message is waiting for me. What's worse is when I click OK I still have to quit the app or the hourglass doesn't go away. Does anybody recognize this problem? Error occurred: Nbr = 1004 | Src = Microsoft Excel | Dsc = The file could not be accessed. Try one fo the following: | Make sure the specified folder exists etc. Any advice would be appreciated . I've had this kind of thing before when I installed new Anti Virus of firewall software. By chance did you install a new version of Norton or McAfee? It may be blocking you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Old report suddenly not running
Nothing was installed. What's peculiar about this is that it runs on the
other PC's, fortunately. I don't need to run it myself, but will need to if further editing is necessary. I did edit the VB slightly, which might be the culprit except the original version doesn't run either. Something in the connection between Access and Excel I bet. "GJones" wrote in message ... -----Original Message----- I have an Access 2000 database that has a VB program to output data into Excel. I've been running it sucessfully a million times over the past few years. Now it doesn't run (on my PC but still does on everybody elses PC). I've done nothing to my system files and the VB program wasn't changed. Excel opens to a blank spreadsheet but nothing happens after than, and when I go back into Access the following error message is waiting for me. What's worse is when I click OK I still have to quit the app or the hourglass doesn't go away. Does anybody recognize this problem? Error occurred: Nbr = 1004 | Src = Microsoft Excel | Dsc = The file could not be accessed. Try one fo the following: | Make sure the specified folder exists etc. Any advice would be appreciated . I've had this kind of thing before when I installed new Anti Virus of firewall software. By chance did you install a new version of Norton or McAfee? It may be blocking you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
When running a SAP report Excel will only display results if Excel isn't already open | Excel Discussion (Misc queries) | |||
How do I create a running report on Excel | New Users to Excel | |||
How do I produce a running Census report in Excel? | Excel Worksheet Functions |