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: 55
Default Open dbf file then close. do nothing..ignore any message.

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
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
error message : I can't close my PERSONAL.XLS file Roger[_2_] New Users to Excel 2 November 14th 09 09:56 PM
How to disable save message when I click the cross to close the file hon123456 Excel Programming 2 June 21st 06 07:17 AM
Warning message on file close Lambtwo Excel Worksheet Functions 1 October 25th 05 03:31 AM
Adding an error message at close of file when criteria are met Dave Excel Discussion (Misc queries) 3 August 12th 05 07:56 PM
Automate open file, update links, run macro, close and save file Geoff[_7_] Excel Programming 2 August 26th 03 10:13 PM


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