I have two similar reports on separate Excel sheets in different workbooks. I want to compare all cell values on one report to the other. Is there a VBA function that can easily handle this?
How would i work from the bottom up, with the following code?
lngCntr = Columns(1).Find("").Row - 1
For Each varCell In Range("A1", "A" & lngCntr)
Next
skip,
Where should i paste this? It didn't seem to work when I pasted into the format property of the field.
Here's some more info:
Field type = Text
Field length = 17
Field name = Total Amt
Thanks.
In Access, how do you set the format of a 17-byte text field to prefill with zeros so the value will always be 17 bytes long not matter how short the value is?
Example:
Value is 1033 needs to be 00000000000001033.
Thanks in advance.
Check this out. This code does work as does my code. For some reason this does not work while debugging. You have to let the code finish on its own before breaking. This kind of makes sense in that the focus needs to stay on the app during processing. Focus is assume is taken away when...
Thanks for the help but for some reason the code below is opening the print dialogue.
SendKeys "%(FO)C:\Datasheet.pdf", True
It looks like it should work. I don't know what to say.
I am using the Shell method to open a particular PDF file during an Excel macro prior to the code below. I am trying to pass Control + A (Select All) and Control + C to the PDF file. Something is not working correctly. Anyone have any suggestions.
AppActivate "Adobe Reader"
SendKeys...
Copy and Paste is a common Windows function. I would think that I could do this without third-party software. Third party software is not an option in this case. What is the syntax for using pdftotext? I have no experience with using VBA with apps outside of Excel.
Anyone know of any good reference material on this. I have two *.pdf files open and have no clue on how to perform any logic on them with VBA. I basically need to copy all of the data in the two *.pdf files into separate worksheets, where the real processing begins. Thanks for any guidance.
Using VBA, underneath an Excel workbook, how can I open another application, pull data off and continue processing in Excel.
I want to open a specific Adobe Acrobat file, do a copy and paste data into the Excel workbook I was already working in.
Thanks in advance. Let me know what other...
I am familiar with VBA for Excel, but seem a little lost with Access, so plan assumptions accordingly.
I was able to automate most of my process using Access Macros, but some functionality still isn't there. Basically, I am running a Macro which kicks off a series of "Sub-macros". One of...
Is it proper db design to have one product table with all the possible data fields (even the 'unique' ones) some of which you know will be blank depending on the product type?
I know there is a cheap piece of software that you can buy from www.hammerman.com that will allow you to view an already developed crystal report without a Crystal license. This works with any database.
I don't even understand what a proxy server is. Maybe I am out of my league. I am just playing around at home. If you want to provide a definition, that would be great.
Thanks.
I agree with lespaul. What advantage is the company going to have after developing the accounting system in house. Everything you described is covered in the simplest of off-the-shelf apps. Put your time and resources into places where your company needs you most (where you gain a competitive...
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.