When stepping through and after executing the following line.
@rowSTD=$sthAppendixEPicture->fetchrow_array;
I get the following error message:
This object is either a Visio file or a Powerpoint file.
What I want to do is extract it and put it in a PDF file.
I have a very large MS Access database and I am trying to extract an OLE field as part of my report (currently txt file but will eventually RTF or PDF format)
use DBI;
use User;
use PDF::Create;
use Win32::OLE;
#Open output txt file
open ( FILE_NAME_STD, ">C:\\database\\out.txt") ||...
Skip,
Again Thanks for the advice. Here is the code that I am currently running:
Sub ParseOnCRLF()
Dim wrksht As Worksheet
Dim rng As Range
Set wrksht = ActiveSheet
Set rng = ActiveCell
For ct = Selection.Count To 1 Step -1
Set rng = Selection.Item(ct)
With...
Skip
Thank you for your solution. I made some minor changes to achieve my desired output (Insert an entire row after the current row before I paste the data).
Sub ParseOnCRLF([COLOR=yellow red] [/color yellow red])
[COLOR=red]Dim wrksht As Worksheet
Dim rng As Range
Set wrksht...
Problem:
I would like to create separate rows for 1 B through G and 3 B through E without affecting the formula.
What I currently have is under the before section.
What I want to accomplish is under the after section.
before after
hdr1 hdr2 hdr3 hdr1 hdr2 hdr3
----...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.