Search results for query: *

Hi all, I've been wrestling with Excel for a few days on this one, and I'm hoping someone can end my misery. I have a sub (Import_Properties) that is played when the user clicks a button. After the user selects the files to import, the code transfers the data to the main workbook. After each...

Hello all, I've tried so many things to get this to work, but I cannot figure it out. Below is my latest code. I have a spreadsheet that pastes a table into Word and does some formatting to the Word document. I've never used VBA in Word before. The code always works the first time but breaks at...

Hi all, I've created a tool in Excel that imports data from a raw data file that the user selects. When the tool has gotten the data it needs it uses this line to close the raw data file: Workbooks(FileName).Close False FileName is the name of the raw data file the user selected. I've set...

Good afternoon, tek-tip folks. I have this relatively small section of code (seen below) that takes 32.4 seconds to run. I'd like to speed it up, but I've improved it as much as I can. Can any experts out there give me some suggestions? Part of the problem is that the raw data I'm formatting...

Good morning, everyone. I apologize in advance for the large amount of code, but thank you for taking the time to look through it. I have a worksheet before double click event set up on a tab called 'BNAGO.' When the user double clicks a Target cell containing a Convention Group name, a new...

Good morning, This is my first time to work with userforms and listboxes, and I've been trying for many, many hours to get this to work. I have a userform with 2 listboxes. All I want to do is transfer a single 2-column row of data from listbox1 (a 2-column listbox) when a user double clicks a...

Good morning, all. I'm somewhat new to VBA, so I need your expert help with something. I have a UDF that looks for a Unique ID (quote number) in a range/array and returns all the corresponding 3-letter codes into a single cell. I only want each 3-letter code to be returned once even though...

Good afternoon, I'm extremely new to DB2. I don't know how to convert a serial date to a common date format. The database I am trying to pull data from uses a serial date which represents the number of days from 01/01/1900. So, June 1 2011 is stored as 40694 in the database. Is there a way to...

Good morning, I'm having an issue with a report where I have placed a page-sized background image with a couple shapes and designs in the page header. I have selected the box to underlay the following sections. However, when I put fields in the page footer, I get an error message that the "Page...

Good morning, In my report, I have a table called GSP. Every field in this table works well except for 1 field. It's a long string field of 55 characters. When I put this field in my report, I get the following error: Database Connector Error: '22018:[IBM][System i Access ODBC Driver]Error in...

Good afternoon, I have two reports that are exactly the same (the same parameters, same fields, same record selection, etc) except for one detail: Report 1 uses three tables, DPSP, FHP, and FDP (connected in that sequence) and Report 2 only uses 2 tables, DPSP and FDP. The reports give me...