Export from excell to .inp file by use of a button

Hello

There was a thread similar to this in 2006, but when i tried it it didn't come out as I needed it to or did it show you how to set up a button for it.

This was the answer for 2006 which was creating a .txt file

Please Login or Register  to view this content.

I changed so the output was a .inp file and the result was close but not close enough

the text in my excell file was similar to this:

Please Login or Register  to view this content.

The addition of the """ is the issue and the program I then input this into doesn't accept them. Can someone please tell me how to create this export to .inp without added the """ and also how can i set this up as a button

Thanks

Bryce

Hello Bryce H467,

Welcome to the Forum!

Can you post the workbook? It will help in creating a working solution.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture

Hello Bryce,

This macro will create a CSV from cells on the worksheet in column "A" starting in row 1. The end of the range is automatically found.

Change the FilePath and Filename variables to match what you will using. Paste this code into a VBA Module in your workbook. You can then attach this macro to the button. If you have any problems, let me know.

Please Login or Register  to view this content.

Hello Bryce,

You're welcome. I take it the macro worked correctly?