Anyone know how to do this? I have a table with my Master data that contains regular fields and some comboboxes. BUT in VB when I bring them into a DataGrid, I don't get the comboboxes. Help!
Yes I've already got this, i contacted support and got it. It didn't work, still getting the error. Beginning to think it is a Client for Microsoft Network issue. I can open the document from here and have NO problems at all.
Blue screen of DEATH everytime our other factories try to open an XLS file over the network. Looked up on Microsoft Website, spoke with microsoft support, gave me a download. Didn't work.
Exception OE in Vredir.vds durning cocreateinstanceex() on remove DCOM server.
Anyone else have any...
I got it...... By setting the column to left Justify it fixed the problem. WIERD! No need for a macro afterall...... Sorry for taking up your time.
Thanx.....Brandi
Actually I got this far, but the on save isn't working. I thought it was
IF ActiveWorkbook.Save = True then
Columns("C:C").Select
Selection.NumberFormat = "General"
End If
MsgBox "Workbook format has been saved" 'just a check msg to see if it works
I...
I want to run a macro on save. The macro needs to check all cells that are 'numeric' and either change the format to 'general' or put a 'tick in front of the numeric expression.
The reasoning behind this is I use this file in a VB application, it opens the file, queries out the data I need and...
I want to run a macro on save. The macro needs to check all cells that are 'numeric' and either change the format to 'general' or put a 'tick in front of the numeric expression.
The reasoning behind this is I use this file in a VB application, it opens the file, queries out the data I need and...
I would think there is a simple line of code that would take one file and rename it. I've tried what you said, modified alittle and still no go..... Thanks for the ideas though.
I have tried so many different ways to do a SaveAs .dbf and nothing is working. I tried the savecopyas and saveas and excel.activeworkbooks.saveas...Ive even tried the xlbuiltindialog.saveas.
Any ideas from anyone would be great!
I have a program that reads an Excel spreadsheet looks for a field with a "Y" flag and then exports it to a text file. Problem is: the excel file has all the fields set to General, but if a dealer changes their partnumber to a full numeric 12345, I have it reading it as a string thru...
I have a program that opens up an excel file and grabs any line that has a "Y" and writes it to a text file. BUT when the user changes the "CUSTNO" to a numeric "12355" it kicks out that line. I have the EXCEL file set to general and I have the VB program set at a...
I'm still alittle new with FoxPro but I need to search a field NAME for a "#" sign or an "@" sign and replace it with nothing. I tried to do a SEEK FOR then a REPLACE/WITH but it didn't work. I'm guessing I put it in the wrong order or syntax. Any help would be appreciated.
Dim errordate1
errordate1 = Date
Dim errordate2 As String
errordate2 = Replace(CStr(errordate1), "/", "")
PCpathLOG = DATpath + "WMS_error" + errordate2 + ".log"
I got the path/filename and date to work. I just needed to copy this file...
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.