-
Created VBA Equivalent to CStr(getFolderNameGD()) (VB.net)
Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It … -
Began Watching VBA Equivalent to CStr(getFolderNameGD()) (VB.net)
Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It … -
Created VBA Equivalent of getFolderNameGD
Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It … -
Began Watching VBA Equivalent of getFolderNameGD
Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It … -
Replied To a Post in Cells changing Fonts and Formats automatically
@Hanif1993, I'm using Microsoft Office Professional 2010. -
Replied To a Post in Macro's saving Worksheet as Strange Name
Changing the code to read `ActiveWorkbook.Close True` made the spreadsheet stop and display an error. -
Replied To a Post in Cells changing Fonts and Formats automatically
ddanbe, That definately isn't the issue. All of our computers are loaded with the "standard issue" fonts and all are exactly the same. Specifically, the heading are saved with the … -
Created Cells changing Fonts and Formats automatically
Group, I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, … -
Began Watching Cells changing Fonts and Formats automatically
Group, I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, … -
Created Macro's saving Worksheet as Strange Name
Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into … -
Began Watching Macro's saving Worksheet as Strange Name
Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into … -
Marked Solved Status for Error Message when Application Opens
Hi Group, I'm getting the following error message as soon as the application opens: ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at … -
Replied To a Post in Error Message when Application Opens
Minimalist, never mind. I believe I've fixed it. I've written the following in: If propertyNo IsNot Nothing Then strLength = propertyNo.Length Blah.. blah.. blah... End If I've tested it and … -
Replied To a Post in Error Message when Application Opens
Minimalist, Bingo! Found it! `strLength = propertyNo.Length` This is happening because I'm getting a "Null" value. The error message says, "NullReference exception occured". I'm fairly sure I know why it's … -
Created General Question regarding the value of Certification
Hello group, I've decided I want to take some classes in SQL, to better understand how to write queries. In looking online for where to turn to for this kind … -
Began Watching General Question regarding the value of Certification
Hello group, I've decided I want to take some classes in SQL, to better understand how to write queries. In looking online for where to turn to for this kind … -
Replied To a Post in Error Message when Application Opens
Rev Jim, thanks for the suggestions! These are absolutely fantastic. I knew there had to be a way to shorten the way it was written. I suspect it will be … -
Replied To a Post in Error Message when Application Opens
Group, I've cleaned up all my errors. Unfortunately I'm still getting my error message. I'm wondering now.... Did I delete a GUI control as Toby_2 suggested? I don't recall doing … -
Replied To a Post in Error Message when Application Opens
"In your case I think it just means that you have to put the as clause at the enf of your function like: Public Function getFolderNameGD(ByVal fullyQualifiedFolderName As String, ByVal … -
Replied To a Post in Error Message when Application Opens
I've changed the Option Restrict to "On". Here's the first error I'm having trouble resolving: Error 1 Option Strict On requires all Function, Property, and Operator declarations to have an … -
Created How to use DECLARE
Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to … -
Began Watching How to use DECLARE
Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to … -
Replied To a Post in Error Message when Application Opens
Group, The GUI does show after the error message displays. I have Option Restrict Off and Option Infer Off. Here's the code I've written: Option Strict Off Option Infer Off … -
Created Error Message when Application Opens
Hi Group, I'm getting the following error message as soon as the application opens: ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at … -
Began Watching Error Message when Application Opens
Hi Group, I'm getting the following error message as soon as the application opens: ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at … -
Marked Solved Status for Creating and Using Variables in SQL (TOAD)
Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL … -
Replied To a Post in Creating and Using Variables in SQL (TOAD)
Thanks for the updates. At least you've got me thinking in the right direction. I'll try finding a TOAD site and ask them. Thank you very much for the help. -
Replied To a Post in Creating and Using Variables in SQL (TOAD)
I think this is what I want. However based on how I've written the code so far, I'm not sure where to insert this new line (or should I modify … -
Replied To a Post in Creating and Using Variables in SQL (TOAD)
@pritaeas, I saw this but didn't understand what any of that meant. So I'm back to square one. Some of my lack of understanding stems from the codes selected in … -
Replied To a Post in Summing values from two tables and summing them separately
I've used your commands as you suggested. It works and appears to bring all of the data back. However I need to do a couple of things: I need separate … -
Replied To a Post in Summing values from two tables and summing them separately
@rch1231, I'm getting some data back, but not all. It seems it doesn't like what I'm trying to return and put in one table. Here's what I'm doing: select LOS2014.PROP_KEY … -
Created Creating and Using Variables in SQL (TOAD)
Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL … -
Began Watching Creating and Using Variables in SQL (TOAD)
Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL … -
Replied To a Post in Summing values from two tables and summing them separately
@rch1231, that makes sense to me. I'll give that a try and report back. Don -
Created Summing values from two tables and summing them separately
Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of … -
Began Watching Summing values from two tables and summing them separately
Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of … -
Replied To a Post in Changing Font size Programmatically using ItextSharp
My assumption is that it's required. I've been reading a good bit and the above code is the only thing that hasn't given me an error message. But keep in … -
Replied To a Post in Changing Font size Programmatically using ItextSharp
FYI... I've now eliminated the error message. However it's not picking up the correct font. Here's what I've done: Dim pdfWrite As PdfWriter = PdfWriter.GetInstance(pdfDoc, New FileStream(newPDFName, FileMode.Create)) Dim bf … -
Replied To a Post in Changing Font size Programmatically using ItextSharp
tinstaafl, Got it and tried it. It worked. Now the next issue: I need to change the font to "Arial Monospaced for SAP". Here's what I've tried: Dim bf = … -
Marked Solved Status for System.IO.File.Move(fileName, destinationFile) "File in Use"
Group, I'm using `System.IO.File.Move` to move an existing file into another folder. However it the program is stopping at this point with the error message "The process cannot access this … -
Replied To a Post in System.IO.File.Move(fileName, destinationFile) "File in Use"
Duh!! I knew that.... why I couldn't think of it, I chalk up to "olds-heimers.... Here's what I ended up doing: If lineNo = 3 And programName = "(res.restran)" Then … -
Created Changing Font size Programmatically using ItextSharp
Group, I'm converting a text file into a .pdf file using ItextSharp. The code below works perfectly to do this. Unfortunately the default font size is to large. I need … -
Began Watching Changing Font size Programmatically using ItextSharp
Group, I'm converting a text file into a .pdf file using ItextSharp. The code below works perfectly to do this. Unfortunately the default font size is to large. I need … -
Created System.IO.File.Move(fileName, destinationFile) "File in Use"
Group, I'm using `System.IO.File.Move` to move an existing file into another folder. However it the program is stopping at this point with the error message "The process cannot access this … -
Began Watching System.IO.File.Move(fileName, destinationFile) "File in Use"
Group, I'm using `System.IO.File.Move` to move an existing file into another folder. However it the program is stopping at this point with the error message "The process cannot access this … -
Replied To a Post in Converting a Text File to a PDF file
Thanks, Jim. I'm going to give that one a whirl! You're the man! Don -
Created Converting a Text File to a PDF file
Group, I'm using VB.net 2010 and would like to convert a text file into a PDF file. In reading through the internet, it appears that I need to download a … -
Began Watching Converting a Text File to a PDF file
Group, I'm using VB.net 2010 and would like to convert a text file into a PDF file. In reading through the internet, it appears that I need to download a … -
Marked Solved Status for Stopping StreamReader to Delete the File
Group, I'm using the following code to read down to the third line of a text file. If it meets the criteria, I need to stop the read and then … -
Replied To a Post in Stopping StreamReader to Delete the File
djjeavons, I specifically used your idea as I have multiple files in the folder, some of which will be deleted and some that won't. So here's what I did: If …
The End.