LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default Problem with Excel-VBA - Open Command after SP3

You have one guess at your other post.

Wolfgang Wagner wrote:

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.


--

Dave Peterson
 
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
how can I access favorites in the Excel 2007 Open file command GrahamC Setting up and Configuration of Excel 0 August 23rd 07 12:36 AM
Problem with Excel-VBA - Open Command after SP3 Wolfgang Wagner Excel Discussion (Misc queries) 1 June 1st 05 01:25 PM
Open Access DB in Excel with Command Button Darrell[_4_] Excel Programming 1 December 13th 03 01:28 AM
Open Access DB in Excel with Command Button onedaywhen Excel Programming 0 December 12th 03 10:19 AM
Open Access DB in Excel with Command Button Bill Manville Excel Programming 0 December 12th 03 08:11 AM


All times are GMT +1. The time now is 05:09 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"