Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I access favorites in the Excel 2007 Open file command | Setting up and Configuration of Excel | |||
Problem with Excel-VBA - Open Command after SP3 | Excel Discussion (Misc queries) | |||
Open Access DB in Excel with Command Button | Excel Programming | |||
Open Access DB in Excel with Command Button | Excel Programming | |||
Open Access DB in Excel with Command Button | Excel Programming |