#Visual basic for excel open file dialog how to#
#Visual basic for excel open file dialog code#

I have never had a file to just disappear with no trace.Set f = Application.FileDialog(msoFileDialogSaveAs) 'msoFileDialogSaveAs Have prayed, rebooted, run spybot, called witch doctor, all with no success. I did) but I remembered that I saved it at least once and I can't even findĪn Excel file that has been modified since Thurs!!!ĭoes anyone have any idea what could have happened to this file? BTW, I I even thought perhaps I didn't save it as often as I thought, (I know that I am just traumatized, because I have NEVER had anything like this Have checked the recycle bin, this did not go into auto recover nothing of Today, when I go to open stuff.xls, it is nowhere to be found!!!!! I haveĭone a search, for any file modified since Thurs and nothing has appeared. Original file -stuff.xls - made changes and saved it as again as I saved it routinely as I was making many changes updates etc. Last night I spent several hours working on anĮxcel 2002 spreadsheet and it has disappeared. It's like the buttons are being disabled when I close or open the file. When I reopen the file none of the buttons work.

The odd thing is if I create a new button it works fine until I save and close the file. I still see the button name 'cmdButtonGetInfo' and '=EMBED('Forms.CommandButton.1','') in the name box and formula bar. I can't seem to locate the command button properties any longer. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties. Now when I open the workbook, the buttons don't work! When I click them nothing happens. Then I saved and closed the workbook and went to lunch.

#Visual basic for excel open file dialog code#

I added the _Click code to run the macros when the user clicked the buttons.Īll of the buttons were working fine.

I got into the button properties and set the background colors. So I removed the form control buttons and created new ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. I'm having a problem in a workbook with several ActiveX command buttons.

#Visual basic for excel open file dialog how to#

csv, close the window and then open that file up again, that dang scientific format is back.ĭoes anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to 'stick' so that they don't revert back to scientific format when I reopen the file? I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. csv file), the numbers are back to being displayed in scientific format. So if I do that, close the Excel window, and then open again (as the. I have saved as a TXT file, pasted the longer number and it displays correctly. I have been successful at preventing Excel from coverting that long number into scientific format. csv files, so this is how I need to save my doc (with this extension). csv file in order to upload to an application that parses out the. I am working with an Excel spreadsheet and saving it as a. I know this question has been asked a bajillion times, so I apologize for the redundancy. Set fd2 = Application.FileDialog(msoFileDialogFilePicker) Set Credit_card_workbook = ActiveWorkbook Filters.Add 'Excel files', '*.xls *.xlsx', 1 Set fd1 = Application.FileDialog(msoFileDialogFilePicker) However I cannot get the filter to show only CSV Files (see the line in bold which ought to restrict the view to just CSV files - bu gives me Excel files). I am trying to use the following code to open first an Excel file and then a CSV file.