PDA

View Full Version : Test



pike
01-17-2016, 11:04 PM
v
A
B
C
D
E
F
G
H
1
order
product
qty
1
2
3
10
30

2
1001
orange
3
A
AA
AAA
AAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

3
1002
berry red
1






4
1002
berry red
1






5
1002
berry purple
1






6
1003
apple red
1






7
1003
apple green
2






8
1004
berry red
1






9
1004
apple red
1

SamT
01-18-2016, 02:15 AM
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGH!

pike
01-19-2016, 01:42 AM
v
A
B
C
D
E
F
G
H
1
order
product
qty
1
2
3
10
30

2
1001
orange
3
A
AA
AAA
AAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

3
1002
berry red
1






4
1002
berry red
1






5
1002
berry purple
1






6
1003
apple red
1






7
1003
apple green
2






8
1004
berry red
1

motilulla
06-05-2016, 02:32 AM
v
A
B
C
D
E
F
G
H


1
order
product
qty
1
2
3
10
30


2
1001
orange
3
A
AA
AAA
AAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA


3
1002
berry red
1







4
1002
berry red
1







5
1002
berry purple
1







6
1003
apple red
1







7
1003
apple green
2







8
1004
berry red
1







9
1004
apple red
1








Hello,

Please need help how can I post sheet example as shown in this post

Thank you

Regards,
Moti

SamT
06-05-2016, 08:58 AM
It is a screenshot posted as an image.

If you only need a simple table with no colors and no borders, you can copy the Range in Excel and paste it directly into your post here.

If you "Go Advanced," You can upload attachments, (after a minimum of posts here,) add borders to the Table and add or remove Rows and Columns.

If you want to paste code into your post, please click the # Icon in the Editor menu to insert CODE tags and paste the code between the Tags.

motilulla
06-05-2016, 03:10 PM
It is a screenshot posted as an image.

If you only need a simple table with no colors and no borders, you can copy the Range in Excel and paste it directly into your post here.

If you "Go Advanced," You can upload attachments, (after a minimum of posts here,) add borders to the Table and add or remove Rows and Columns.

If you want to paste code into your post, please click the # Icon in the Editor menu to insert CODE tags and paste the code between the Tags.
Thank you SamT, for your kind help

I understand all except you said the #post3 "It is a screenshot posted as an image." How can it is possible If I highlight the image and can paste in to excel sheet directly and able to read it. Or please tell me how the screen shot is taken.

Thank you

Regards,
Moti

SamT
06-05-2016, 04:48 PM
On the top row of keyboards is a key that says PrntScr. This key copies the screen to the clipboard as a bmp image.

Open an image editor like MS Paint and paste into the image editor.

Use the image editor to Crop the image, then save it as a *png or *jpg file on your desktop.

When you are on VBAExpress.com, the menu Icon between the blue globe and the hash mark icon will let you upload an image from your computer into your post.

motilulla
06-05-2016, 04:58 PM
On the top row of keyboards is a key that says PrntScr. This key copies the screen to the clipboard as a bmp image.

Open an image editor like MS Paint and paste into the image editor.

Use the image editor to Crop the image, then save it as a *png or *jpg file on your desktop.

When you are on VBAExpress.com, the menu Icon between the blue globe and the hash mark icon will let you upload an image from your computer into your post.

Testing

16321

motilulla
06-05-2016, 05:05 PM
Thank you SamT, yes I get success to post screen shot as per your instruction after posting it I tried to copy back to excel it is not possible instead #post1 and #post 3 text yes please will you take a look

Regards,
Moti

SamT
06-05-2016, 06:17 PM
No you can not paste a picture into excel.

My bad. That is not an image in posts #1 & #3

The tables in those posts were hand coded by the OP. He used the A/A Icon to view and edit the Source of his post.

Here is how he did it

[_TABLE="class: thin_grid"] (Remove underscore in "[_Table")

v
A
B
C
D
E
F
G
H


1
order
product
qty
1
2
3
10
30


2
1001
orange
3
A
AA
AAA
AAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA


3
1002
berry red
1







4
1002
berry red
1







5
1002
berry purple
1







6
1003
apple red
1







7
1003
apple green
2







8
1004
berry red
1







9
1004
apple red
1






[/TABLE]

motilulla
06-06-2016, 02:00 AM
No you can not paste a picture into excel.

My bad. That is not an image in posts #1 & #3

The tables in those posts were hand coded by the OP. He used the A/A Icon to view and edit the Source of his post.

Here is how he did it
SamT, I thought that would be created by some Add inns to post easily but it is a bit difficult

Thank you for your time and help

Regards,
Moti

joshman1088
09-06-2016, 07:04 AM
Testing