Paste validation, Copy, Paste Special Validation

Paste validation, Copy, Paste Special Validation

Post by Scot » Thu, 21 Dec 2006 06:54:29


Hi,

I am generating Validation strings in my code, and then trying to paste
the same strings onto several different lines.

I can put the validation strings into any data type necessary in my
code, but the only way I know to Paste Special -> Validation is to do
the following:

1) Put the validation strings into the spreadsheet somewhere.
2) Copy the section.
3) Paste Special -> Validation

Is there a way to either (A) go directly to step 3 from the String
array I have in my subroutine, or (B) bypass the need to paste in step
1, going right to copying?

Hopefully it's clear.

Scott
 
 
 

1. Data Validation - copy > paste > special problem

2. Copy/Paste or Copy/Paste Special of filtered view to access

I am writing a vb appplication in MSAccess to extract field info from project
into Access tables. I also would like to ave a copy of the Gantt view when
filters are applied so that I can create a formatted report from MS Access
which presents MS project data organized in a particualr format, with a
corresponding picture at the top of the report.

I have automated the retrievable of all of the MS oproject field data that I
need. Does anyone know how you can save a picture of a filtered view in MS
project into an OLE field in MS Access.

I am able to programatically filter an MS Project file and, using
EditCopyPicture, can save the picture as a gif file with a new name. I would
like to be able to programatically, using vba, add some input strings to the
EDITCOPYPICTURE dialog to change the file type to gif, re-defining the date
range and renaming the final gif files. Can anyone show me how to add an
input string to a dialog which is generated by MS Project? Once I am able to
programatically create gif views, I will then need to read the gif into an MS
Access OLE field ( or link it so it can be refreshed when the graphic
changes).

Any help would be appreciated.

Dan

3. Getting Data Validation to execute when using Paste Special...

4. Copy; Paste; Paste Special are disabled

5. Insert vs Copy-Paste vs Paste Special etc.

6. Word 2000 - Change Copy-Paste Special paste default from HTML to Unformatted text?

7. Automating copy/paste/paste special when row references change

8. Copy & paste graphics -- only "paste special"?

9. paste special pastes into hidden cells while paste does not in 200

10. Text truncated when pasted into Excel (Paste Special - Paste Link)

11. Copied formulas paste as text and paste special does not work

12. PASTE SPECIAL - Paste Values vs Paste Unicode

13. help w/ generic copy & paste/paste special routine

14. Where can I find the old "Paste Special" (Edit/Paste Special)?

15. data validation and copy/paste.......