Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I tried the following in both Excel 2003 and 2007 on a Vista machine:
Sub Test() Dim I As Integer I = FreeFile fName = "C:\aaa.ini" Open fName For Output As #1 Print #1, "Test" Close #1 End Sub I get a Path/Fle access error on the Open line. The above works perfect in other versions of Excel. I tried different folders and still no joy. When I tried manually saving a workbook to the programs file directory where the add-in was located, to the root C drive and to the windows temp directory. , I get a "you don't have permissions" error message each time. Most likely this is what is triggering the path/file error. I guess I could save to the my documents directory, but the file is not one the user needs to see. And if they see it, they are likely to delete Any ideas on how to solve? Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File shows as locked on my machine only | Excel Discussion (Misc queries) | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Corrupted Excel file - but on only one machine? | Excel Discussion (Misc queries) | |||
Corrupted Excel file - but on only one machine? | Excel Programming | |||
file transfer to/from a unix machine | Excel Programming |