Openning an excel doc and editing it from access 1

[hondaman2003]

I just need to open an excel document from access. I would simply like to change a single cell to a percent format. How do I do that?

 

[PHV]

Use Automation.
Have a look at the CreateObject or GetObject functions.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hondaman2003]

I am using automation. I have the document open and know how to refer to a specific cell or a range of cells, but cannot seem to set this particular property. I can't seem to figure out the syntax.

 

[bubba100]

Try starting the Macro Recorder, format the cell then turn off the Recorder and look at the code.

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[henniec]

Assumming everything has been done to change the format the code would be something like this.

.Cells(12, 10).Value = Format(MyReadings1!std, "0.00%")

Bearing in mind there are a few other steps to select the range.

Hennie

 

[PHV]

change a single cell to a percent format
yourCellObject.NumberFormat = "0.00%"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RoyVidar]

This
.Cells(12, 10).Value = Format(MyReadings1!std, "0.00%")

changes the value, try something like this

.Cells(12, 10).Value = MyReadings1!std
.Cells(12, 10).NumberFormat = "0.00%"

Roy-Vidar

 

[SkipVought]

Assumming everything has been done to change the format the code would be something like this.

.Cells(12, 10).Value = Format(MyReadings1!std, "0.00%")

Bearing in mind there are a few other steps to select the range.

That would not be correct!

The Format function returns a STRING, actually CHANGING the value in the cell. This is not an Excel Format!

Rather...

.Cells(12, 10).NumberFormat = "0.00%"

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}