Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
i am simply trying to open a dbf file then close it without doing anything and do not want to notify the user plus if any message comes out i want to ignore it...(opening in the background)... i tried with, 'fileToOpen = "c:/path/musa.dbf" 'filenumber = FreeFile 'Open fileToOpen For Random Access As #filenumber 'Close #filenumber it did nothing....then i tried with... 'Workbooks.Open Filename:=fileToOpen 'ActiveWindow.Close this opens up the dbf file in excel and the problem is i have more data than the excel limit so i got a message..... Is there a way to open a dbf file in the background and close it without doing anything to it and ignore any message??...what i found is, without opening the file, excel can not get the data from the file....So, just want to open then colse.....doing this thing manually, everything works ok. Thank you for you time... musa.biralo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error message : I can't close my PERSONAL.XLS file | New Users to Excel | |||
How to disable save message when I click the cross to close the file | Excel Programming | |||
Warning message on file close | Excel Worksheet Functions | |||
Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) | |||
Automate open file, update links, run macro, close and save file | Excel Programming |