Search:
Type: Posts; User: Bezzie
Search:
Search took 0.11 seconds.
-
Where would the best place be to put this code so that it executes on opening the workbook? Don't know what executes when:o
Not too worry. Found Workbook_Open:D
-
I have model in Excel that are run from two different computers (a desktop and a laptop). The model uses a file to import data that is located in a OneDrive folder. The path to that OneDrive folder...
-
Thanks guys. Got it sorted now.
-
Tried both methods and got both to work.
With the method of SamOscarBrown I noticed that one should only select the specific cells that will be effected by the line i.e. to draw the left line only...
-
I'm going to try it. Thanks.
-
Don't really know. Got examples from internet and tried the worksheet creation from my code. Have no experience doing this before.
Dim oXLApp As Object
Dim oXLBook As Object
Dim...
-
It's an accounting (currency) value I want to put in the merged cells but it puts the currency symbol to the left of the cell and the amount to the right of the cell. Even selecting the merged...
-
The last one (xlRight) you have d3:d3 where the others are all c3:d3
I tried with my range specified instead of c3:d3 but it still draws lined around each cell in the range.
-
Where are the xlLeft, xlRight etc. defined? Compiler tells me variable not defined.
-
How do one get a border around a range of cells, and not the individual cells in the range, in Excel worksheet created from VB6?
Everything works when creating the worksheet but for the life of me...
-
I check the MD5 hash of a few files when my program is installed. The program is compiled on English Windows version but when we try to install it on a Chinese Windows version it installs but then...
-
How do one detect that a form lost focus when program loses focus i.e. user go to another program for instance? Program is open and form is open but I go to another program.
LostFocus event of...
-
I've created a custom inputbox so user can select which data to export (to an Excel ws in this case).
On my form, that will call the custom inputbox, I have a Listview control that shows a popup...
-
Got it sorted but man was this a crap one to find.
It turned out to be a call to the database in a function located in sub that was in the Activate event of my main form. So calling the small form...
-
It's just a message that is displayed in a textbox on the screen. I is just a counter from 1 to 10.
-
I narrowed it down to the closing of my database connections (I think:eek:).
Did a search on the forum and find the following to close data connections:
If Not myConnection Is Nothing Then...
-
It has to be something before the DoAutoBackup that is causing the problem. I added some code right before the call to the DoAutoBackup just to waste some time and the error pops up earlier now. Must...
-
It compiles a list of the database files to include in the ZIP file and then add them to the ZIP file to have a backup of data files when the user changed some data.
The Form_Unload event:
...
-
There is no code in the FrmMsgWait form.
In the unload event of the FrmRingneck where the FrmMsgWait is called I set the Caption of the message before FrmMsgWait.Show and after the backup file is...
-
Anybody has an idea why the following code will result in the error message below?
Load FrmMsgWait
FrmMsgWait.LblMessage.Caption = "Writing AutoBackup file..."
FrmMsgWait.Show
FrmMsgWait is a...
-
Great stuff. Thank you.
For the life of me I couldn't remember that website name:blush: Had to reformat my pc a while ago and lost all my bookmarks:sick:
-
How can I export a complete table (structure and data) from my Access database to a new database using VB6?
Is there a easier way to accomplish this than creating a new database then create a new...
-
-
My "problem" is that MSFlexGrid scrolls the whole column at a time.
Calculating the width of the text in the column (I made the column width as wide as can be displayed visually) with the...
-
There are three MSFlexgrids on the screen. User can select entries and move them in and out of the flexgrids as well as sort the grids so while WordWrap and RowHeight will work it's a lot of overhead...
-
Was trying to scroll to be able to read the full entry when the entry in the cell is longer than what is available visibly.
Have been trying something else that works a bit better though. Using...
-
Tried the fixed column (had to fix first two cols as there is a col with zero length). The second (first col is 0 length) column then stays visible but when scrolling to the right with the scrollbars...
-
Found it right after I sent the reply so edited the reply. Property is 0 so changed it to 1 but still scrolls the column away. Still busy trying it out.
-
Will try and see how it than behaves.
-
My MSFlexGrid has two columns, a short Col 1 and a long Col 2 (or is that 0 and 1) which is partially hidden due to the length being longer than the visible flexgrid. When the user click on an entry...
-
I rename them with:
oXLBook.Worksheets(1).Name = "New Name"
Adding the False to the oXLBook.Close sorted that problem of the lockup. Problem was a Save As from Excel that sat behind my program....
-
The lockup happens when trying to rename a sheet that doesn't exist. On my PC Excel opens a workbook with three default worksheets so I renamed the three worksheets to what I need. On another users...
-
Without saving. Only saves the workbook once data is written. This crash happened just after creating and opening the workbook when I tried to rename the three sheets I'm going to use. The crash...
-
Thanks. Got that sorted now.
Just another question: When the program erred for instance because there is not three sheets available for writing it goes to the error handler and shows the error...
-
I need to create a new Excel workbook from within VB6 program and then write to three different sheets in the workbook.
On my version of Excel it opens a new workbook with three default sheets...
-
Thanks for the input. I've decided to bench the idea. Just too many options to try and cater for.
-
According to what I read in the links provided the syntax will be different for different email clients.
Is there a way to determine which default email client the user has in order to construct a...
-
Think there might be misunderstandings somewhere.
My program is a recordkeeping program for birdbreeding hobby. Some of the birds we keep need permits and if we sell of those birds we need to...
-
For info: It's different users each using his/her own combinations of service providers, operating systems and email clients.
Will have a look at the link you posted.
-
My PC's are 64bit OS and the two with Office365 is also Office365 64bit. The third PC with Win10 (64bit) and Thunderbird I think is 32bit. Not sure.
My problem is however that if I want to add...
|
Click Here to Expand Forum to Full Width
|