I've run into a nasty problem, can't find a way around it.
This line of code:
DoCmd.OutputTo acOutputTable, "GSQ_Criter ia", acFormatXLS, FileName
errors with
#2385 - Errors were encountered during the save operation.
The error only occurs on some systems. Other systems (also running XP pro)
get no error at all on that line. Anyone know of another command that can
do the OutputTo? Is there any point in contacting Microsoft? I would be
willing to pay for support if I thought there was a good chance they could
help.
Anyone have a suggestion?
--
Randy Harris
(tech at promail dot com) 7 1465
On Wed, 16 Mar 2005 23:12:08 GMT, "Randy Harris" <ra***@SpamFree .com>
wrote:
One alternative is to use Automation.
Create an object of type Excel.Applicati on.
Using this object, you can control every aspect of Excel. You can
create a new workbook, poke data into the first sheet, and save it.
The help file for Excel's object model is an optional part of the
Office installer. If you chose the defaults, you may have to go back
and explicitly select it.
If you decide to contact MSFT, be sure to reduce the problem to the
minimum: an Access db with a single table and a single macro with a
single line in it.
-Tom. I've run into a nasty problem, can't find a way around it.
This line of code:
DoCmd.OutputTo acOutputTable, "GSQ_Criter ia", acFormatXLS, FileName
errors with
#2385 - Errors were encountered during the save operation.
The error only occurs on some systems. Other systems (also running XP pro) get no error at all on that line. Anyone know of another command that can do the OutputTo? Is there any point in contacting Microsoft? I would be willing to pay for support if I thought there was a good chance they could help.
Anyone have a suggestion?
"Randy Harris" <ra***@SpamFree .com> wrote in
news:c3******** *********@newss vr17.news.prodi gy.com: I've run into a nasty problem, can't find a way around it.
This line of code:
DoCmd.OutputTo acOutputTable, "GSQ_Criter ia", acFormatXLS, FileName
errors with
#2385 - Errors were encountered during the save operation.
The error only occurs on some systems. Other systems (also running XP pro) get no error at all on that line. Anyone know of another command that can do the OutputTo? Is there any point in contacting Microsoft? I would be willing to pay for support if I thought there was a good chance they could help.
Don't you have to specify the XLS extension?
You also might want to try the TransferSpreads heet command instead.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
I neglected to include the previous line, which, (I think) answers the
question.
FileName = CurrentProject. Path & "\GSQ_" & Format(Now, "mmm-dd-yy-hhmm") &
".xls"
DoCmd.OutputTo acOutputTable, "GSQ_Criter ia", acFormatXLS, FileName
--
Randy Harris
(tech at promail dot com)
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@24. 168.128.74... "Randy Harris" <ra***@SpamFree .com> wrote in news:c3******** *********@newss vr17.news.prodi gy.com:
I've run into a nasty problem, can't find a way around it.
This line of code:
DoCmd.OutputTo acOutputTable, "GSQ_Criter ia", acFormatXLS, FileName
errors with
#2385 - Errors were encountered during the save operation.
The error only occurs on some systems. Other systems (also running XP pro) get no error at all on that line. Anyone know of another command that can do the OutputTo? Is there any point in contacting Microsoft? I would be willing to pay for support if I thought there was a good chance they could help.
Don't you have to specify the XLS extension?
You also might want to try the TransferSpreads heet command instead.
-- David W. Fenton http://www.bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassoc
I dug into this about a hundred years ago and now I'm having trouble
remembering yesterday. Is creating the Excel.Applicati on object using
early, rather than late, binding? I was advised to change that, which I
did, way back when.
Part of the difficulty with contacting Microsoft, is that none of the
systems that are failing are local. I can't reproduce the problem here.
--
Randy Harris
(tech at promail dot com)
"Tom van Stiphout" <no************ *@cox.net> wrote in message
news:lp******** *************** *********@4ax.c om... On Wed, 16 Mar 2005 23:12:08 GMT, "Randy Harris" <ra***@SpamFree .com> wrote:
One alternative is to use Automation. Create an object of type Excel.Applicati on. Using this object, you can control every aspect of Excel. You can create a new workbook, poke data into the first sheet, and save it.
The help file for Excel's object model is an optional part of the Office installer. If you chose the defaults, you may have to go back and explicitly select it.
If you decide to contact MSFT, be sure to reduce the problem to the minimum: an Access db with a single table and a single macro with a single line in it.
-Tom. I've run into a nasty problem, can't find a way around it.
This line of code:
DoCmd.OutputTo acOutputTable, "GSQ_Criter ia", acFormatXLS, FileName
errors with
#2385 - Errors were encountered during the save operation.
The error only occurs on some systems. Other systems (also running XP
pro)get no error at all on that line. Anyone know of another command that
cando the OutputTo? Is there any point in contacting Microsoft? I would be willing to pay for support if I thought there was a good chance they
couldhelp.
Anyone have a suggestion?
On Thu, 17 Mar 2005 04:45:37 GMT, "Randy Harris" <ra***@SpamFree .com>
wrote:
If you are sure to have Excel available, use early binding. It also
makes writing the code easier because intellisense will be available.
If not sure Excel is installed, use late binding (Dim objExcel as
Object). I still would develop the code using early binding, and
switch to late binding at the last moment.
-Tom. I dug into this about a hundred years ago and now I'm having trouble remembering yesterday. Is creating the Excel.Applicati on object using early, rather than late, binding? I was advised to change that, which I did, way back when.
Part of the difficulty with contacting Microsoft, is that none of the systems that are failing are local. I can't reproduce the problem here.
Randy Harris wrote: I neglected to include the previous line, which, (I think) answers the question.
FileName = CurrentProject. Path & "\GSQ_" & Format(Now, "mmm-dd-yy-hhmm") & ".xls" DoCmd.OutputTo acOutputTable, "GSQ_Criter ia", acFormatXLS, FileName
I'd still go with David's suggestion and try out TransferSpreads heet.
Also, nothing to do with the problem but a handy tip for putting date
stamps into file names is to use international format yyyy-mm-dd, when
sorted alphabetically they are also sorted by date + avoids confusion
between British and US dates.
Date stamps as provided by the OS are anything but reliable, too easy to
change the last modified (edit or in some apps (Access) just open the
file) and the Created date, if the file is a copy is usually later than
the modified date (i.e. it's the date the file was copied, not
originally created), so no followups about sorting by date in exploder
please :-)
--
This sig left intentionally blank
David's suggestion was indeed a good one. I changed the code to
TransferSpreads heet and it no longer fails. I like your idea for the date
format, I'll be making that change as well.
Thanks to everyone for their input.
--
Randy Harris
(tech at promail dot com)
"Trevor Best" <no****@besty.o rg.uk> wrote in message
news:42******** ******@besty.or g.uk... Randy Harris wrote: I neglected to include the previous line, which, (I think) answers the question.
FileName = CurrentProject. Path & "\GSQ_" & Format(Now, "mmm-dd-yy-hhmm")
& ".xls" DoCmd.OutputTo acOutputTable, "GSQ_Criter ia", acFormatXLS, FileName
I'd still go with David's suggestion and try out TransferSpreads heet.
Also, nothing to do with the problem but a handy tip for putting date stamps into file names is to use international format yyyy-mm-dd, when sorted alphabetically they are also sorted by date + avoids confusion between British and US dates.
Date stamps as provided by the OS are anything but reliable, too easy to change the last modified (edit or in some apps (Access) just open the file) and the Created date, if the file is a copy is usually later than the modified date (i.e. it's the date the file was copied, not originally created), so no followups about sorting by date in exploder please :-)
-- This sig left intentionally blank This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Joe Reazor |
last post by:
I just upgraded to v1.1 of the framework and VS.Net 2003. I opened up one
of my solutions and rebuilt my project and all went well. I then ran my
project in debug mode. My program runs up fine, but then I try to open up a
file that it typically works with, my program has custom serialization to a
file for work that users do. This has always worked in the past, as I could
open and resave my files with no problems. Now I am unable to...
|
by: Naresh |
last post by:
I have been having a problem and I don't know where to go for help. The microsoft support is only for a fees. Can anyone at all please at least point to a site or some place where I can hope for some enlightment
My problem
I am using Windows XP and had installed .NET 2000. I then downloaded the .NET framework 1.1 from teh microsoft site and installed it and then rebooted the machine. When I open the Internet manager console, I find that my web...
|
by: Ravikanth[MVP] |
last post by:
Hi
It is possible that IIS and SQL Server can reside on
Seperate Machines and you can use Integrated Windows
Authentication to connect.
Ravikanth
>-----Original Message-----
|
by: James Radke |
last post by:
Hello,
I was curious, is it possible to create drag and drop interface from listbox
to listbox on a webform application (i.e. vb.net)? Basically the
application would need to load multiple listboxes with values from a
database, allow the user to drag and drop from a listbox to a different
listbox and would 'move' the item and update the database accordingly?
If so, would anyone have any examples of how to do this?
|
by: sp |
last post by:
Is it possible to instal dot net 2.0 SDK on Win 98 or Win ME?
I tried and I received A required resource cannot be found (at the
window bar there ara unusual signs).
I installed .net 2.0 redistrib. package before and it is wotking OK (I
tested my hello world application).
| |
by: Tomasz |
last post by:
Hello Developers,
Here is interesting problem I just came across: how do I wire a GridView
control programmatically?
Here is my sample code using Object Data Source:
protected void Page_Load(object sender, EventArgs e)
{
ObjectDataSource ods = new ObjectDataSource("MyTestTableAdapter",
|
by: Simon |
last post by:
I heard that we could do that by using AJAX. Could anybody share how to do
it? Thanks.
|
by: Oriane |
last post by:
Hi Steven,
"Steven Cheng " <stcheng@online.microsoft.coma écrit dans le message
de news:ZJOyi9J4IHA.4928@TK2MSFTNGHUB02.phx.gbl...
Thanks for the link. I've tried that but there is one withdrawal I can't
explain. I make use of Ajax server pop up extender, and they don't behave as
they should in the window opened with the "open" Javascript function, which
makes this solution not relevant...
Oriane
|
by: =?Utf-8?B?QWxleGFuZGVyIFd5a2Vs?= |
last post by:
Is it possible to automate a COM object ebmeded in an excel document run the
process and return the results in a C# .NET application? Or better yet
extract the com object some how and just run it in .NET?
--
Alexander L. Wykel
AW Software Works
|
by: =?Utf-8?B?c2lwcHl1Y29ubg==?= |
last post by:
Hi
I need to store some configuration settings in a db
using an 2 fileds
ID Field and String Field
The ID Field is a unique key and the string holds a xml string that store my
settings
Now I need to modify my configuration xml to store another parameter which
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |