Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by redjoy
-
Read an OLE field from MS Access (mdb)
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. -
MS Access and DBI
[code] #open connection to Access database $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb);dbq=C:\Windows\Desktop\AuditTrail.mdb'); [\code] Try changeing this line to [code] #open connection to Access database $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver... -
Read an OLE field from MS Access (mdb)
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") ||... -
Split multiple line cell into seperate cells
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...- redjoy
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Split multiple line cell into seperate cells
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...- redjoy
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Split multiple line cell into seperate cells
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 ----...- redjoy
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
