| Author |
Message |
Jesper Davidsen
Guest
|
 Posted:
Tue Dec 14, 2004 12:33 am Post subject:
File name & Config name in Excel BOM |
|
|
Hi
I'm having trouble inserting file namse and configuration names in an Excel
bom template. I am atemting to put the text "SW-File Name(File Name)" in to
the name box in the first colum, but excel won't accept it.
Anyone know how it's done?
Jesper
|
|
| Back to top |
|
 |
CS
Guest
|
| Posted:
Tue Dec 14, 2004 12:49 am Post subject:
Re: File name & Config name in Excel BOM |
|
|
What is your current code for entering it into excel?
Are you using an embedded spread sheet or one open in a separate session of
excel?
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdee71$0$50746$edfadb0f@dread15.news.tele.dk...
| Quote: | Hi
I'm having trouble inserting file namse and configuration names in an
Excel
bom template. I am atemting to put the text "SW-File Name(File Name)" in
to
the name box in the first colum, but excel won't accept it.
Anyone know how it's done?
Jesper
|
|
|
| Back to top |
|
|
Jesper Davidsen
Guest
|
| Posted:
Tue Dec 14, 2004 1:32 am Post subject:
Re: File name & Config name in Excel BOM |
|
|
"CS" <C@S.COM> skrev i en meddelelse news:326a60F3i7p7hU1@individual.net...
| Quote: | What is your current code for entering it into excel?
|
I'm not sure what you mean by code
| Quote: | Are you using an embedded spread sheet or one open in a separate session
of
excel?
|
I opened the standard bom template in excel (separate), and the I'm adding
colums whit the info that I need. I have not delete any of the original
colums, just hidden a few.
| Quote: | Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdee71$0$50746$edfadb0f@dread15.news.tele.dk...
Hi
I'm having trouble inserting file namse and configuration names in an
Excel
bom template. I am atemting to put the text "SW-File Name(File Name)" in
to
the name box in the first colum, but excel won't accept it.
Anyone know how it's done?
Jesper
|
|
|
| Back to top |
|
|
CS
Guest
|
| Posted:
Tue Dec 14, 2004 2:00 am Post subject:
Re: File name & Config name in Excel BOM |
|
|
Sorry I kind of misread your post
Try this.
add a column named File
If you want you could name it "File Name" but you have to name the cell
title "File" so that SW can use it properly because you cannot have spaces.
Add a custom property to each model called
"File"
make it's value
$PRP:"SW-File Name"
then generate a bom with your new template and you will have a collumn with
all the file names.
Regards,
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdfc7d$0$85706$edfadb0f@dread15.news.tele.dk...
| Quote: |
"CS" <C@S.COM> skrev i en meddelelse
news:326a60F3i7p7hU1@individual.net...
What is your current code for entering it into excel?
I'm not sure what you mean by code
Are you using an embedded spread sheet or one open in a separate session
of
excel?
I opened the standard bom template in excel (separate), and the I'm
adding
colums whit the info that I need. I have not delete any of the original
colums, just hidden a few.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdee71$0$50746$edfadb0f@dread15.news.tele.dk...
Hi
I'm having trouble inserting file namse and configuration names in an
Excel
bom template. I am atemting to put the text "SW-File Name(File Name)"
in
to
the name box in the first colum, but excel won't accept it.
Anyone know how it's done?
Jesper
|
|
|
| Back to top |
|
|
Jesper Davidsen
Guest
|
| Posted:
Tue Dec 14, 2004 3:17 am Post subject:
Re: File name & Config name in Excel BOM |
|
|
Great, I'll try that.
You wouldn't happen to know how to get the file name extension in there as
well?
"CS" <C@S.COM> skrev i en meddelelse news:326dnsF3j8bjrU1@individual.net...
| Quote: | Sorry I kind of misread your post
Try this.
add a column named File
If you want you could name it "File Name" but you have to name the cell
title "File" so that SW can use it properly because you cannot have
spaces.
Add a custom property to each model called
"File"
make it's value
$PRP:"SW-File Name"
then generate a bom with your new template and you will have a collumn
with
all the file names.
Regards,
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdfc7d$0$85706$edfadb0f@dread15.news.tele.dk...
"CS" <C@S.COM> skrev i en meddelelse
news:326a60F3i7p7hU1@individual.net...
What is your current code for entering it into excel?
I'm not sure what you mean by code
Are you using an embedded spread sheet or one open in a separate
session
of
excel?
I opened the standard bom template in excel (separate), and the I'm
adding
colums whit the info that I need. I have not delete any of the original
colums, just hidden a few.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdee71$0$50746$edfadb0f@dread15.news.tele.dk...
Hi
I'm having trouble inserting file namse and configuration names in an
Excel
bom template. I am atemting to put the text "SW-File Name(File Name)"
in
to
the name box in the first colum, but excel won't accept it.
Anyone know how it's done?
Jesper
|
|
|
| Back to top |
|
|
CS
Guest
|
| Posted:
Tue Dec 14, 2004 8:29 pm Post subject:
Re: File name & Config name in Excel BOM |
|
|
You have to set it in windows explorer.
I believe the setting that is labeled something like
Hide file extentions of known types. turn it off.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41be14e2$0$85622$edfadb0f@dread15.news.tele.dk...
| Quote: | Great, I'll try that.
You wouldn't happen to know how to get the file name extension in there as
well?
"CS" <C@S.COM> skrev i en meddelelse
news:326dnsF3j8bjrU1@individual.net...
Sorry I kind of misread your post
Try this.
add a column named File
If you want you could name it "File Name" but you have to name the cell
title "File" so that SW can use it properly because you cannot have
spaces.
Add a custom property to each model called
"File"
make it's value
$PRP:"SW-File Name"
then generate a bom with your new template and you will have a collumn
with
all the file names.
Regards,
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdfc7d$0$85706$edfadb0f@dread15.news.tele.dk...
"CS" <C@S.COM> skrev i en meddelelse
news:326a60F3i7p7hU1@individual.net...
What is your current code for entering it into excel?
I'm not sure what you mean by code
Are you using an embedded spread sheet or one open in a separate
session
of
excel?
I opened the standard bom template in excel (separate), and the I'm
adding
colums whit the info that I need. I have not delete any of the original
colums, just hidden a few.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdee71$0$50746$edfadb0f@dread15.news.tele.dk...
Hi
I'm having trouble inserting file namse and configuration names in
an
Excel
bom template. I am atemting to put the text "SW-File Name(File
Name)"
in
to
the name box in the first colum, but excel won't accept it.
Anyone know how it's done?
Jesper
|
|
|
| Back to top |
|
|
Jesper Davidsen
Guest
|
| Posted:
Fri Dec 17, 2004 1:47 pm Post subject:
Re: File name & Config name in Excel BOM |
|
|
What I ment was: How do I get the filename extension into the BOM
"CS" <C@S.COM> skrev i en meddelelse news:328em1F3jhq6aU1@individual.net...
| Quote: | You have to set it in windows explorer.
I believe the setting that is labeled something like
Hide file extentions of known types. turn it off.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41be14e2$0$85622$edfadb0f@dread15.news.tele.dk...
Great, I'll try that.
You wouldn't happen to know how to get the file name extension in there
as
well?
"CS" <C@S.COM> skrev i en meddelelse
news:326dnsF3j8bjrU1@individual.net...
Sorry I kind of misread your post
Try this.
add a column named File
If you want you could name it "File Name" but you have to name the cell
title "File" so that SW can use it properly because you cannot have
spaces.
Add a custom property to each model called
"File"
make it's value
$PRP:"SW-File Name"
then generate a bom with your new template and you will have a collumn
with
all the file names.
Regards,
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdfc7d$0$85706$edfadb0f@dread15.news.tele.dk...
"CS" <C@S.COM> skrev i en meddelelse
news:326a60F3i7p7hU1@individual.net...
What is your current code for entering it into excel?
I'm not sure what you mean by code
Are you using an embedded spread sheet or one open in a separate
session
of
excel?
I opened the standard bom template in excel (separate), and the I'm
adding
colums whit the info that I need. I have not delete any of the
original
colums, just hidden a few.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdee71$0$50746$edfadb0f@dread15.news.tele.dk...
Hi
I'm having trouble inserting file namse and configuration names in
an
Excel
bom template. I am atemting to put the text "SW-File Name(File
Name)"
in
to
the name box in the first colum, but excel won't accept it.
Anyone know how it's done?
Jesper
|
|
|
| Back to top |
|
|
CS
Guest
|
| Posted:
Fri Dec 17, 2004 7:11 pm Post subject:
Re: File name & Config name in Excel BOM |
|
|
I know what you meant, and now that I think about it SW may strip that
information. I think what I was thinking was that this method works through
API. When set in windows it grabs the file extention. You could just add
it after the property value.
$PRP:"SW-File Name".sldprt
$PRP:"SW-File Name".sldasm
$PRP:"SW-File Name".slddrw
It shouldn't be too hard and really easy for new parts just setup your
templates with this already assigned.
A macro would take care of that.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41c29d2a$0$65604$edfadb0f@dread15.news.tele.dk...
| Quote: | What I ment was: How do I get the filename extension into the BOM
"CS" <C@S.COM> skrev i en meddelelse
news:328em1F3jhq6aU1@individual.net...
You have to set it in windows explorer.
I believe the setting that is labeled something like
Hide file extentions of known types. turn it off.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41be14e2$0$85622$edfadb0f@dread15.news.tele.dk...
Great, I'll try that.
You wouldn't happen to know how to get the file name extension in there
as
well?
"CS" <C@S.COM> skrev i en meddelelse
news:326dnsF3j8bjrU1@individual.net...
Sorry I kind of misread your post
Try this.
add a column named File
If you want you could name it "File Name" but you have to name the
cell
title "File" so that SW can use it properly because you cannot have
spaces.
Add a custom property to each model called
"File"
make it's value
$PRP:"SW-File Name"
then generate a bom with your new template and you will have a
collumn
with
all the file names.
Regards,
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdfc7d$0$85706$edfadb0f@dread15.news.tele.dk...
"CS" <C@S.COM> skrev i en meddelelse
news:326a60F3i7p7hU1@individual.net...
What is your current code for entering it into excel?
I'm not sure what you mean by code
Are you using an embedded spread sheet or one open in a separate
session
of
excel?
I opened the standard bom template in excel (separate), and the I'm
adding
colums whit the info that I need. I have not delete any of the
original
colums, just hidden a few.
Corey
"Jesper Davidsen" <jesper@hylt.dk> wrote in message
news:41bdee71$0$50746$edfadb0f@dread15.news.tele.dk...
Hi
I'm having trouble inserting file namse and configuration names
in
an
Excel
bom template. I am atemting to put the text "SW-File Name(File
Name)"
in
to
the name box in the first colum, but excel won't accept it.
Anyone know how it's done?
Jesper
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in