| | |
Error msg: "Filename.xls file already open. Choose to reopen or close the excel file"
![]() |
•
•
Join Date: Mar 2007
Posts: 68
Reputation:
Solved Threads: 1
Error msg: "Filename.xls file already open. Choose to reopen or close the excel file"
0
#1 Aug 18th, 2008
Hi, i am having a vb6 program on a local lan server in my company. Recently i did an enhancement to the vb6 program. The program is able write into a blank excel sheet located in the application path. It work fine previously without any problem. After the enhancement, the program work fine in the server but when we as the user access the program through the application shortcut(local lan), it prompt a error msg stating that the blank excel file used by the application to generate report is already open. User will need to choose whether to reopen / close the excel file from a msg box, neither of the option will enable the process of generating report but it work fine in the server pc. When i generate the .exe file from the source code folder, it is working fine for the server as well as the user. After i copy the .exe file into the operating folder(where the actual database reside) the problem occured. For your information, the program will access the database from a path.txt file so no matter where the .exe reside we r still able to connect to the actually database, the problem is all the user is using the shortcut pointing to the operating folder. That's y i need to move the .exe file into the operating folder. Any1 hv clue what is the problem for the application?
![]() |
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: How To Accept Other Languages In Vb6 Textbox
- Next Thread: Check folder path is exists or not?
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





