LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Wolfgang Wagner
 
Posts: n/a
Default Problem with Excel-VBA - Open Command after SP3

Hi,

I have following problem. I've programmed an application for a customer in
EXCEL-VBA with several text-file outputs.



The source-code is as below:



Public Sub StartSeiteErstellen()



Dim fileNr



mDateiName = Pfad_AktKatalog & "Katalog.htm"



mstrHTML_Kopf1 = Range("HTML_StartSeite_Kopf").Value

mstrHTML_Kopf1 = mstrHTML_Kopf1 & Range("HTML_StartSeite_Body").Value

mstrHTML_Kopf1 = mstrHTML_Kopf1 & Range("HTML_StartSeite_Fuß").Value

mstrHTML_Kopf1 = fVariablenErsetzen(mstrHTML_Kopf1)



' Datei-Ausgeben:

fileNr = FreeFile

Open mDateiName For Output As fileNr

Print #fileNr, mstrHTML_Kopf1

Close #fileNr



Exit Sub





The variable " Pfad_AktKatalog " is beeing valued (filled) by a cell of an
worksheet.



I developed this application with Excel 2000 (without any SP) and the
customer uses Excel as well.



Up to now everything went right, until the customer istalled Office-SP3 and
got, while executing the OPEN, the " ERROR 53 - File not Found "



The most curious thing is, that when I use the Excel-File from the customer
( where he only changed the output paths within the Worksheet )on my PC, I
also get the same error message ! The program itself runs on 90% of the PCs
we tested, but on a few with the Office SP3.



Does anybody know about this bug, can anybody help in this matter ?

One thing more, please don't joke with changing on "Filesystem Object". ;)



Thanks in advance.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel files in separate program windows Jason Dove Excel Discussion (Misc queries) 27 October 24th 08 07:58 PM
open separate exterior excel windows Jason Dove Excel Discussion (Misc queries) 18 May 3rd 05 05:22 PM
Open excel from htm page den Excel Discussion (Misc queries) 0 April 25th 05 11:58 PM
Cannot open Excel attachment from e-mail when Excel is already ope John P. Excel Discussion (Misc queries) 1 March 1st 05 08:35 PM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"