Define name -variable- by saving as

**Brie** · 02-16-2010, 07:29 AM

Hi!

I am looking for a solution to define a name by saving as.
I think I'm almost there, but can't find the part where i can name it.

In steps:
1) Define the path and the name of the current file as string - to delete extension (=.csv)
2) Save current file as current name with .xls in folder where is current file saved before.

This is a part of my code - the part that is neccesary to see what I am doing:

Please Login or Register  to view this content.

The comment is in Dutch, but I think the code is readable...

Is there someone who can help me out?

Best regards,

Brigitte

**JeanRage** · 02-16-2010, 07:33 AM

Hi,

For a start, have you simply tried

ActiveWorkbook.SaveAs Filename:=myFilePath

HTH

**Brie** · 02-16-2010, 07:39 AM

Hi JeanRage,

I just tried it.

I used the first part of my code ('Naam van het ... ".csv", "")
And then added your code.

Excel then gives an error; it says that there is already existing such a file-name, because its trying to save a csv file... And it should be an xls file.

Do you know how to change this?

**romperstomper** · 02-16-2010, 08:29 AM

Shouldn't it be:

Please Login or Register  to view this content.

**Brie** · 02-16-2010, 08:43 AM

You're right romperstomper!

This is working!

But... It's only a small part of my code, How can I show the pop-up?
For now it's saved at the right place with the right name, but i would like to accept it manually, if it's possible...

**romperstomper** · 02-16-2010, 09:18 AM

Use myOriginalFileNameForSaving instead of myOriginalFileNameToXls in the SaveAs code then.

**Brie** · 02-16-2010, 09:58 AM

I'm sorry, its better to write down what I'm doing. I used this:

Please Login or Register  to view this content.

This should lead to a pop-up, I thought, which is filled with filename.xls instead of "filename.csv"?

**romperstomper** · 02-16-2010, 10:19 AM

You are not specifying the InitialFileName argument:

Please Login or Register  to view this content.

**Brie** · 02-16-2010, 10:28 AM

Perfect! This is it!

Fool that I am, I'm probably too many characters seen in recent times - just completely overlooked.

Thnx!

Define name -variable- by saving as

LinkBack

Thread Tools

Rate This Thread

Display

Define name -variable- by saving as

Re: Define name -variabel- by saving as

Re: Define name -variabel- by saving as

Re: Define name -variabel- by saving as

Re: Define name -variabel- by saving as

Re: Define name -variabel- by saving as

Re: Define name -variabel- by saving as

Re: Define name -variabel- by saving as

Re: Define name -variabel- by saving as

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions